Deleting Rows or Columns

Using the delete option in Excel removes the selected rows or columns and any information they contain.

To delete a row:

1. Click the heading of the row(s) you wish to delete. (This will highlight the entire row.)
2. Select Delete from the Cells Group.

The row that was located beneath the deleted row will now move up.

To delete a column:

1. Click the lettered column heading(s) to delete. (This will highlight the entire column.)
2. Select Delete from the Cells Group.

The column located directly to the right of the column being deleted will shift to the left.

EXCEL EXTRAS
Excel maintains formulas by adjusting absolute references to the shifted cells to reflect their new locations. However, a formula that refers to a deleted cell displays the #REF! error value.