Editing Data

To edit any value, click in the cell to select it. Type information and the existing value is overwritten. Data can be sorted, transformed, or transposed in this window. You can also calculate statistics for the worksheet data in this window. New columns or rows can also be added. For instance, if we notice that the value in cell B13 is incorrect, we can change it.

1. Click in cell B13.

2. Type the value 46.2.

3. Press ENTER on the keyboard. The new value is entered in cell B13.

 

Back to Viewing and Editing Data

Next to Calculating Statistics on the Data