Editing data

To change any of the data already on the worksheet, you simply click on the cell and type the new data. There is no need to delete what is already there; it will be replaced when you press Enter at the end of the new data.

If you change a figure that has been used in a formula, the result of the formula calculation will be changed automatically. Let’s try this out now.

The prices of the Beta model have come down in the second half of the year. The figures for projected sales have to be increased. (Use the buttons at the bottom left of the image to play the demonstration.)