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.

Entering text in a cell

You can enter three types of data in a cell: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values that are used when making calculations. Formulas are mathematical calculations.

To enter data into a cell:

  • Click the cell where you want to type information.
  • Type the data. An insertion point appears in the cell as the data is typed.

    The Insertion Point
  • The data can be typed in either the cell or in the Formula bar.

    Text is Entered in Cell or Formula Bar
  • Data being typed appears in both the active cell and Formula bar.

    Text Appears in Cell and Formula Bar When Typed
  • Notice the Cancel and Enter buttons in the formula bar.

    The Excel 2003 Formula Bar
  • Click the Enter button Enter button to end the entry and turn off the Formula bar buttons.

Excel's AutoComplete feature keeps track of previously entered text. If the first few characters you type in a cell match an existing entry in that column, Excel fills in the remaining characters for you.