Removing Cells

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Removing Cells


Besides adding cells, a list maintenance also consists of deleting or moving cells. In Lesson 2, we saw how to delete one or more columns. The problem is that, when you delete a column, all of its cells a lost. In the same way, if you delete a row, all of its cells are lost also. Sometimes you want to remove only one or more cells but keep the other cells of the same column or the same row. Fortunately, Microsoft Excel supports various techniques of removing cells from a list.

Instead of deleting a whole column, you can delete just one cell or more cells. Because a cell is surrounded by other cells, you must indicate what would happen to the other cells or how they would adjust to he new empty spot.

Deleting a Cell

Before deleting a cell, you first make it active. Then you specify if, by removing it, the cells on on its right would be moved to the left to close the left empty space. The alternative it to draw the cells from under it up. When the cell has been removed, and the cells from the right side have been move left, Microsoft Excel adds a new cell from the last column. If the cells have moved up, Microsoft Excel creates a cell in the last position of that column.

To delete a cell:

  • Right-click the cell and click Delete...
  • Click the cell. On the Ribbon, click Home. In the Cells section, click Delete and click Delete Cells...

This would display the Delete dialog box. To 

To delete more than one row, first select the rows, whether in a range or randomly. Then:

  • Right-click one of the rows (whether one of the row headers or a box on the right side of one of the selected rows) and click Delete
  • (After selecting the rows,) On the Ribbon, click Home. In the Cells section, click Delete and click Delete Sheet Rows

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z