Deleting Rows and Columns

When you delete a row or column, you are removing all of those cells from your workbook. Once you've deleted the row or column, it disappears and the rest of the columns and rows move to replace it.

To delete a row or column:

1. Select the row or column you want to delete.
2. Click Delete on the Edit menu.

Be careful—if you delete a row or column containing data, that data will be lost.

To delete a row or column you can also:

1. Right-click the row or column heading and choose Delete from the menu that appears.
2. Right-click any cell in the row or column, click Delete... on the shortcut menu, and select Entire row or Entire column.