Delete cells, rows, or columns
- Select the cells, rows, or columns you want to delete.
- On the Edit menu, click Delete.
- If you are deleting a range of cells, click Shift cells left, Shift cells up, Entire row, or Entire column in the Delete dialog box.
Note Microsoft Excel keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations. However, a formula that refers to a deleted cell displays the #REF! error value.