Deleting Cells

You can customize your workbook and change the layout of data by deleting cells. Deleting cells not only deletes the information and formatting in the cell, but also shifts the layout of the workbook. By deleting an empty cell, you shift all the surrounding cells as well.

To delete a cell:

1. Select Delete... from the Edit menu.
2. Click the Shift cells left or Shift cells up radio button.
3. Click OK.

Pressing the Delete key on the keyboard will delete the contents of the cell but not the cell itself.

Use this technique to delete an entire row or column as well.

To open the Delete dialog box, you can also right-click in a cell and select Delete... from the shortcut menu.