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.
On the Home tab, in the
✔ Cells
group, click Delete, or
✔ right-click the selection and click Delete
.
Specify where to shift the adjacent cells.
Click OK.