Editing Data

After you have entered data into a cell, you may edit it in either the Formula bar or in the cell itself.

To edit an entry in Excel:

  1. Click the cell in which you want to edit data.

  2. To begin editing, click the Formula bar, press F2, or double-click the cell. This puts you in Edit mode; the word Edit appears in the status bar.

  3. Press ⟸ or ⟹ to move the insertion point within the entry. Press the Backspace key to delete characters to the left of the insertion point; press the Delete key to delete characters to the right. Then type any characters you want to add.

  4. Click the Enter button on the Formula bar or press Enter on the keyboard ...

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.