Home > Articles

Editing Worksheets

  • Print
  • + Share This
This chapter is from the book

The old paper-and-pencil method of calculating was a pain because if you made a mistake or forgot something, you had to do a lot of erasing—maybe even redo the whole thing. With an electronic worksheet, however, you can easily make changes. Forget something? You can insert a cell, row, or column. You also can delete entries. You can change a value, find and replace data, and even check for spelling errors. Besides editing the data in your worksheets, you can add comments to remind yourself of information and track when changes are made and by whom.

Inserting Comments and Changes

Editing Data

Being able to make changes to the values in your worksheet is what makes Excel such a valuable analysis tool. You can change any of your entries and see how that affects the formulas in your worksheet. To put the active cell in Edit mode, press F2 on the keyboard or click the mouse pointer on the data line of the Edit bar. You can then continue typing at the end of the current data, use the Backspace key to delete some data, use the left and right arrow keys to move through the data, or use the Home and End keys to move quickly to the beginning or the end of the data. Press Enter when you have finished editing the data.


1.gif Double-click the cell you want to edit. The insertion point appears to the left of the data in the current cell (the entry also appears in the Formula bar).

2.gif Press the left and/or right arrow keys to move the insertion point where you want to make the change.

3.gif Type your changes (using the Backspace key if necessary).

4.gif Press the Enter key to accept your changes (the cell below becomes the active cell).

5.gif Click in the next cell you want to edit and press the F2 key. The insertion point appears to the right of the data in the current cell (the entry also appears in the Formula bar).

6.gif Type your edits.

7.gif Click the green checkmark Enter button to accept the changes.

8.gif The changes are accepted and the edited cell remains the active cell.


  • + Share This
  • 🔖 Save To Your Account