How to Delete Rows, Columns and Cells in Excel

Deleting rows, columns and cells

662925038

It is very easy to delete rows, columns, or cells in an existing worksheet. First, select the cell to be deleted. In the Cells group under the Home tab, click on the Delete down arrow to open the Delete drop-down menu.

  • To delete a single cell, click on Delete Cells to open the Delete dialog box.
  • The Shift cells left option will delete the text of cell B2 and shift the contents of cell C2 to B2 and so on.
  • The Shift cells up option will delete the text of cell B2 and shift the contents of cell B3 to B2 and so on.
  • To delete an entire row, click on the Delete Sheet Rows option. This can also be done by selecting the Entire row option in the Delete dialog box. This will delete the entire row 2 and shift the contents of row 3 to row 2 and so on.
  • To delete a blank column, click on the Delete Sheet Columns option. This can also be done by selecting the Entire column option in the Delete dialog box. This will delete column B and shift the contents of column C to column B and so on.
  • To delete an entire sheet, click on Delete Sheet. This will delete the entire worksheet from your workbook.