Deleting rows or columns
For deleting cells, rows or columns you should first
1. Select the cells, rows, or columns that you want to delete.
2. On the Edit menu, click Delete.
Tip: You can also right-click a selection of cells, rows, or columns, and then click Delete on the shortcut menu. Pressing DELETE deletes the contents of the selected cells, not the cells themselves.
3. If you are deleting a cell or a range of cells, in the Delete dialog box, click Shift cells left, Shift cells up, Entire row, or Entire column.
If you are deleting rows or columns, other rows or columns automatically shift up or to the left. To quickly repeat deleting cells, rows, or columns, select the next cells, rows, or columns, and then press CTRL+Y. If needed, you can restore deleted data immediately after deletion. On the Edit menu, click Undo Delete, or press CTRL+Z.
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.