Table of Contents
To delete cells in Excel, select the cell or cells that you want to delete. Then, right click on the selected cells and choose “Delete” from the drop-down menu. You can also use the “Delete” button on your keyboard. This will shift the remaining cells to the left or up to fill the deleted space. Alternatively, you can use the “Clear” option under the “Home” tab to remove the contents of the selected cells without shifting the remaining cells. Additionally, you can use the “Insert” option to insert new cells in place of the deleted cells. It is important to note that deleting cells cannot be undone, so it is recommended to save your workbook before making any deletions.
Excel Delete Cells
Delete Cells
Cells can be deleted by selecting them, and pressing the delete button.
Note: The delete function will not delete the formatting of the cell, just the value inside of it.
Let’s have a look at three examples.
Example 1
Pressing the delete button:
Example 2
Pressing the delete button:
Example 3
With formatting:
Pressing the delete button:
Note that it only deletes the value in the cells, and not the formatting (the color).
Note: You will learn more about formatting, and how to style cells in a later chapter.