Excel Shortcut to Delete Cells and Shift Them Upward

In Excel for Microsoft 365 on Windows, select the cells to remove, press Ctrl+- (Ctrl and the minus key), choose Shift cells up in the Delete dialog, and press Enter. Excel deletes those cells and moves the cells below them upward to fill the space; it does not automatically move neighboring columns.

The keyboard shortcut and Delete dialog

The shortcut is a two-stage command: Ctrl+- opens the Delete dialog, and you then choose what Excel should do with the selected cells. This choice matters because deleting cells is different from clearing their contents or deleting a whole row.

Select the cell or contiguous range you want to remove.
Press Ctrl+-. Use the minus key, not the plus key.
In the Delete dialog, select Shift cells up.
Press Enter, or click OK, to apply the deletion.

If the dialog initially highlights another option, change the selection rather than accepting it automatically. Depending on what you selected, Excel may offer choices such as shifting cells left, shifting cells up, deleting an entire row, or deleting an entire column. Read the options before confirming.

What “Shift cells up” does

Excel removes the selected cells and moves the cells directly below them upward by the same number of rows. The shift happens in the selected column or columns, not across the entire worksheet. If you delete B4, for example, B5 moves into B4, B6 moves into B5, and so on. The final affected cell at the bottom of the worksheet becomes blank.

If you select a rectangular block, Excel shifts cells upward in each column covered by that block. It does not move the same rows in columns outside the selection. That makes the command useful for removing a misplaced entry from a single list, but potentially risky when several columns contain records that belong together.

Formulas and other cell contents below the deleted area move along with their cells. Excel also adjusts formula references where appropriate, but shifting only part of a data record can still leave related values out of alignment. The operation changes the worksheet layout; it is not merely a visual hiding or filtering action.

Choose a range that keeps data aligned

Before using Shift cells up, consider whether the selected cells are independent or part of a row of related information. A list of product codes in column A might be safely compacted on its own. But if each row contains a product code, description, price, and stock count in columns A through D, deleting only a cell in column A can pair the remaining codes with the wrong descriptions and prices.

For a complete record, select all the cells in the record and use the appropriate row-deletion option instead of shifting just one column. If you truly intend to remove a value from one column while leaving other columns untouched, shifting cells up may be right—but check the resulting relationships carefully.

One-column list: Select the unwanted cell or cells in that column and choose Shift cells up to close the gap.
Related data across columns: Delete the entire record row if the whole record should go.
Keep the layout but remove a value: Clear the cell contents instead of deleting the cell.
Remove a whole field: Delete the entire column, rather than shifting just a portion of it.

A concrete example

Suppose column A contains a short list of names in A2:A6, and the entry in A4 is an accidental duplicate. Select A4, press Ctrl+-, choose Shift cells up, and confirm. The former A5 entry moves to A4, the former A6 entry moves to A5, and A6 becomes blank. The cells in column B do not move unless they were also included in the selection.

That last detail is important if column B contains a phone number for each name. Shifting only A4 upward would change which name appears beside each phone number. If each name and number form one record, remove the duplicate by deleting the entire corresponding row instead. If the names are deliberately independent of column B, a one-column shift may be suitable.

Delete cells versus clear contents or delete a row

These commands solve different problems. Pressing the Delete key on Windows clears the contents of selected cells, while leaving those cells in place. Their formatting and position remain, and cells below do not move up. This is the better choice when you want an empty cell but need to preserve the worksheet structure.

By contrast, Ctrl+- opens the Delete dialog for removing cells or whole rows and columns. Choosing Shift cells up closes a gap within the selected columns. Choosing Entire row removes the selected row across the worksheet, so values in neighboring columns stay together. A whole-row deletion can also be initiated by selecting the row header first and then pressing Ctrl+-.

In short, use Clear Contents when the cell should remain empty in its original position, Shift cells up when the list below should compact within the selected columns, and Entire row when a complete record should be removed.

Use the ribbon if you prefer not to use a shortcut

You can reach the same cell-deletion choices from the ribbon. Select the cells, then choose Home > Cells > Delete > Delete Cells. In the dialog, select Shift cells up and confirm. The exact layout of the ribbon can vary with the Excel window size, but the command is in the Home tab’s Cells group.

The ribbon route can be easier when you are unsure which deletion option the shortcut will present, or when you want to inspect the command name. It does not change the result: the selected cells are removed and the cells below shift upward only in the affected columns.

Common problems and precautions

If Excel reports that it cannot complete the shift, check whether the selection intersects merged cells. A merged area may prevent Excel from shifting part of its contents. You may need to unmerge the affected cells or select a range that respects the merged layout. Also check whether the worksheet is protected; protection can restrict deleting cells, rows, or columns until the sheet is unprotected with permission.

Be especially deliberate in filtered lists and Excel tables. A table is designed to keep each record in a consistent row, so removing a table entry is generally a row-level task rather than shifting one cell independently. If the goal is to remove a record from a table, use the table’s row-deletion command or delete the worksheet row as appropriate. When a filter is active, verify which records are selected before deleting; do not assume a selection represents only the visible entries.

For a safer edit, you can first save the workbook or duplicate the worksheet. After deletion, inspect the cells above and below the gap as well as adjacent columns. If the result is wrong, press Ctrl+Z immediately to undo it. Undo is available for ordinary cell deletion, but later actions can affect how far back you can undo.

Windows, Mac, and Excel for the web

The instructions above target Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the cell-deletion shortcut is generally Control+- (Control and minus), rather than Command+-; choose Shift cells up in the dialog that appears. Keyboard layouts can place the minus character differently, so the Home tab’s Delete Cells command is a useful alternative if the shortcut does not open the dialog.

Excel for the web runs in a browser, where browser and operating-system shortcuts can affect key combinations. If Ctrl+- does not open the expected Excel dialog, use Home > Delete > Delete Cells if available, or use the web app’s displayed cell-deletion controls. Confirm that the dialog or menu offers the shift-up choice before proceeding. The desktop shortcut and dialog steps are the most direct guidance for the Windows version covered here.

Frequently Asked Questions

What is the Excel shortcut to delete cells and shift up?
On Windows, select the cells, press Ctrl+-, choose Shift cells up in the Delete dialog, and press Enter. On Mac, use Control+- in Excel, then choose the same option.

Does pressing Delete shift cells up?
No. On Windows, the Delete key clears the selected cells’ contents but leaves the cells in place. Use Ctrl+- and choose Shift cells up when you want cells below to move upward.

Can I delete a cell without moving cells below it?
Yes. Clear the cell’s contents with the Delete key on Windows, or use the Clear Contents command. The cell remains in its position, so the surrounding layout does not shift.

How do I delete an entire row instead?
Select the row by clicking its row header, then press Ctrl+- on Windows. You can also right-click the row header and choose Delete. Deleting the full row keeps values in that row’s different columns together.

Why is Shift cells up unavailable or not working?
The selection may intersect merged cells, the sheet may be protected, or you may be working inside an Excel table where records are managed as rows. Check the selection and protection settings, and use a row-deletion command when removing a table record.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.