This class was exactly what I needed for my job.”

Online Learner

Creating Opportunities For A Better Life.®

Excel XP

Single page view print copy

Enter, Edit, and Delete Data

Editing Information in a Cell

Information in a spreadsheet is likely to change over time. Information can be changed in either of two ways.

Quick and Easy Method:

  • Click the cell that contains the information to be changed.
  • Type the new entry. The old entry is replaced by the new entry.

If the original entry is long and requires only a minor adjustment (in spelling, for example), then you can directly edit the information in the cell.

To Edit Information in a Cell:

Method 1: Direct Cell Editing

  • Double-click on the cell that contains the information to be changed.
  • The cell is opened for direct editing.

    Direct Cell Editing

  • Make the necessary corrections.
  • Press Enter or click the Enter button on the Formula bar Enter button to complete the entry.

Method 2: Formula Bar Editing

  • Click the cell that contains the information to be changed.
  • Edit the entry in the formula bar.

    Edit Information in the Formula Bar

1 2 3 4 5 6 7