Clearing and Deleting Cells, Rows, and Columns

Deleting cells removes the cells and shifts the surrounding data to fill the space. Clearing cells leaves the cells in place but deletes any data or formatting in them.

To delete cells:

1. Select the cells, rows, or columns you want to delete.
2. Select Edit > Delete to display the Delete dialog box.
3. Select a Delete option button to specify a direction you want the surrounding rows, columns, or cells to shift.
4. Click OK.

To clear cells:

1. Select the cells, rows, or columns you want to clear.
2. Choose one of the following, depending on what you want to clear from the cells:

   Select Edit > Clear > Contents to clear the values and formulas, but leave the formats.

   Select Edit > Clear > Formats to clear the cell formats, but leave the values and formulas.

   Select Edit > Clear > All to clear the formulas, values, and formats.

3. Click OK.