Editing data

You can edit data in a cell to change it or replace it entirely. Building your worksheet provides basic information about entering and editing data.

  1. Click the cell you want to edit.

  2. Press F2 to edit directly in the cell, or click the contents box at the top of the worksheet to do your editing there.

  3. Edit the entry using any of the following techniques.

    To Press
    Scroll through the cell contents HOME, END, or the left and right arrow keys
    Delete characters to the right of the cursor DEL
    Delete characters to the left of the cursor BACKSPACE
    Cancel the edits you're making and restore the former contents of the cell ESC
  4. (Optional) To replace the cell entry entirely, just type the new entry.

  5. Press ENTER.



See also
Selecting and deselecting data
Entering a number
Entering text
Entering a date
Entering a time