Enter, Edit, and Delete Data

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Editing information in a cell

Information in a spreadsheet is likely to change over time. Information can be changed in the following 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 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