Entering and Editing Data

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

Editing data

You may find that you need to edit or change data you enter into a cell. You can do this two ways.

To use the quick and easy method:

  • Click the cell and type the new entry; the old entry is replaced.

If the original entry is long and only requires a minor adjustment (in spelling, for example), edit the entry.

To edit:

  • Click the cell and edit the entry in the Formula bar.


  • Double-click the cell. This opens the cell for direct editing.
  • Press Enter or click the Enter button on the Formula bar Enter Button to complete the entry.

Enter Text