Use the drop-down menus to complete the steps for deleting a range of cells in a worksheet.
Select the range of cells to delete. of
On the Home tab, in the
-group, click Delete, o
Specify where to shift the adjacent cells.
Click OK.