When working with Excel, you may often need to delete cells. Please follow the steps below to delete cells and shift other cells up:
Step 1: Click the cell or cells where you want to delete;
Step 2: Right-click, and select "Delete" from the list in the dialog box.
Alternatively, please use the commands from the ribbonl
Step 1: Click the "Home" tab from the ribbon;
Step 2: Click "Delete" from the Cells area, and select "Delete Cells" from the drop-down list;
Step 3: In the "Delete" dialog box, click "Shift cells up";
Step 4: Click "OK" at the bottom.