The ribbon command Home | group Cells | Delete 
not only deletes the content of the selected cells but also removes them completely from the worksheet.
If you click on this command, the program displays a dropdown menu in which you can determine how the other cells should be moved up after the deletion process.
The following options are available:
▪Delete cell, move cells up
| If you select this option, the selected range of cells will be deleted and the cells below will move up. |
▪Delete cell, move cells to the left
| If you select this option, the selected range of cells will be deleted and the cells to the right of it will move to the left. |
▪Remove complete rows
| This option deletes the complete rows within the selected range of cells and not just the selected cells. The rows below move up accordingly. |
▪Remove complete columns
| This option deletes the complete columns within the selected range of cells and not just the selected cells. The columns to the right of them move to the left accordingly. |
▪Delete worksheet
| This option removes the worksheet (including its content). For more information, see Managing worksheets. |