- How to Insert Cells and Shift Cells Down
- How to Delete Cells and Shift Cells Left
- How to Insert Cells and Shift Cells Right
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.
Is the delete + Shift option available if I have a filter on. I thought I was able to do that before but now when I attempt it it deletes the entire row. Do you have any advice?