Cell Basics

In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.

Cell content

Each cell can contain its own text, formatting, comments, formulas, and functions.

To insert content:

  1. Click a cell to select it.
  2. Enter content into the selected cell using your keyboard. The content appears in the cell and in the formula bar. You can also enter or edit cell content from the formula bar.
    Inserting content Inserting content

To delete content within cells:

  1. Select the cells containing content you want to delete.
  2. Click the Clear command on the Ribbon. A dialog box will appear.
  3. Select Clear Contents.
    Clearing cell contents Clearing cell contents

You can also use your keyboard's Backspace key to delete content from a single cell or the Delete key to delete content from multiple cells.

To delete cells:

  1. Select the cells you want to delete.
  2. Choose the Delete command from the Ribbon.
    Deleting cells Deleting cells

There's an important difference between deleting the content of a cell and deleting the cell itself. If you delete the cell, by default the cells underneath it will shift up and replace the deleted cell.