Excel Keyboard Shortcut to Delete Cells and Shift Data

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+- (Ctrl plus the minus key) to open the Delete dialog. Choose whether to shift surrounding cells up or left, or remove an entire row or column; pressing the Delete key alone clears cell contents instead of deleting the cells.

The shortcut at a glance

The shortcut is useful when you need to remove cells from a worksheet and have Excel close the gap. Select the target first, then press Ctrl+- and choose the deletion behavior that fits your layout. The selection matters: deleting a cell is different from deleting its row or column, and Excel needs to know what to do with the other cells.

On many Windows keyboards, the minus key is on the top row beside the zero key. The minus key on a numeric keypad can also work. If your keyboard layout makes the combination awkward or the dialog does not appear, use the ribbon route: Home > Cells > Delete > Delete Cells. The command opens the same choice of how to handle the surrounding cells.

  • Ctrl+-: open the Delete dialog for a selected cell or range.
  • Delete: clear the contents of selected cells while leaving the cells in place.
  • Ctrl+Z: undo a deletion or clearing action, provided the action is still in the undo history.

What the Delete dialog does

When you select an ordinary cell or rectangular range and invoke Delete, Excel offers four choices: Shift cells left, Shift cells up, Entire row, and Entire column. The first two remove only the selected cells and move other cells to fill the resulting space. The last two remove full worksheet rows or columns, not just the cells where you originally clicked.

For example, suppose a list occupies A1:C10 and a single unwanted entry is in B4. Deleting B4 and choosing Shift cells up moves the values below it in column B upward by one cell. Values in columns A and C do not move. If you instead choose Entire row, Excel removes worksheet row 4, shifting all rows below it upward across the sheet. That broader change can affect other tables or notes on the same row.

If you select a whole row or column before using the shortcut, Excel can delete that entire row or column directly rather than asking you to choose how to shift cells. You can select a row by clicking its number along the left edge, or a column by clicking its letter at the top.

How to choose shift up or shift left

Choose the direction by considering which neighboring cells should move into the gap. Shift cells up is common for removing one or more entries from a vertical list when you want the items below the deletion to move upward. Shift cells left works for removing values from a horizontal sequence when the values to the right should close the gap.

Be cautious when the selected cells are part of a larger table. Shifting only one column upward can misalign records: a customer name might stay in place while that customer’s email address moves up from the next row. If each row represents a complete record, delete the entire row instead of shifting cells in just one field. Likewise, if a row contains related values across several columns, removing only a few cells and shifting left can mix up the relationships.

A practical check before deleting is to ask: should the remaining values move, and should they move across the whole record or only within this small range? If you cannot answer confidently, cancel the dialog with Esc, inspect the surrounding data, or make a copy of the worksheet before proceeding.

Delete cells versus clear contents

This is the most common source of confusion. Pressing the Delete key clears the contents of selected cells; it does not remove the cells or make other cells shift. The cells remain in their original positions. Depending on what the cells contain, clearing removes their values or formulas, while cell formatting generally remains. A cleared formula cell no longer calculates a result, but its borders, fill color, and number format can still be present.

Use Delete when you want an empty cell but want the worksheet layout to stay fixed—for example, removing a mistaken value from a form or clearing an old input without moving the rest of the table. Use Ctrl+- when you want to remove the cell position and close a gap, or when you need to delete a complete row or column.

There is also a separate ribbon command for clearing different cell attributes: Home > Editing > Clear. Its options include clearing contents, formats, or all. This is distinct from the Delete command in the Cells group. If a cell looks blank but still affects formatting or contains something you need to remove, check whether you cleared only its contents or need a different Clear option.

Delete a complete row or column

To remove a full row, select its row number and press Ctrl+-, or use Home > Cells > Delete > Delete Sheet Rows. To remove a full column, select its column letter and use Home > Cells > Delete > Delete Sheet Columns. These commands remove the worksheet rows or columns themselves, so cells elsewhere in those rows or columns are removed too.

Deleting a worksheet row is not the same as clearing the cells in that row. If you clear its contents, the row remains and later rows do not move. If you delete the row, the rows beneath it move up. Similarly, deleting a column shifts columns to its right leftward. Check for other data on the same row or column before choosing a whole-row or whole-column deletion.

In an Excel table, deleting a worksheet row that intersects the table can affect the table’s records and the worksheet row. If the goal is only to remove a table record, use the table’s row deletion options or select the record’s worksheet row with care. Avoid selecting a single cell and choosing Shift cells up in one table column, since that can break the alignment between fields.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. On a Mac, the delete-cells command is generally invoked with Control+- (Control and minus), rather than substituting Command for Ctrl. Keyboard layouts and compact keyboards can make the minus combination less obvious, so the reliable alternative is the ribbon’s Home > Delete command and the relevant Delete Cells option. The Delete key on a Mac keyboard can have different labeling or behavior depending on the keyboard, but clearing contents and deleting cells remain separate operations.

In Excel for the web, keyboard shortcuts may be affected by the browser or the operating system. If Ctrl+- does not bring up the expected choice, select the cells and use the Home tab’s Delete command, then choose the appropriate delete option if it is offered. The web interface can change over time, so menu labels or available choices may differ slightly from the desktop application.

Common problems and safe ways to recover

  • The wrong cells moved. Press Ctrl+Z immediately to undo, then repeat the deletion with the correct shift direction or choose an entire row or column.
  • The Delete key did not close the gap. That is expected: Delete clears contents. Use Ctrl+- or the Delete Cells ribbon command when cells themselves must be removed.
  • Excel removed more data than expected. You likely selected a whole row or column, or chose Entire row or Entire column in the dialog. Undo and check the selection before trying again.
  • The shortcut does not work. Confirm Excel has focus and that the cell or range is selected. Try the numeric-keypad minus or use the ribbon command; keyboard layouts and remote desktop settings can affect key combinations.
  • A formula shows a new result after deletion. Deleting cells can change references and cause formulas to recalculate. Inspect important formulas and dependent cells after making structural changes.

Undo is useful, but it should not be treated as a substitute for checking the selection. Some later actions can make the original operation harder to undo, and saving or closing a file changes what can be recovered through the normal undo history. For a high-impact edit, save a separate copy first.

Examples that clarify which command to use

Removing one item from a standalone list: If a single-column list has an obsolete item in A5 and you want the later items to move up, select A5, press Ctrl+-, and choose Shift cells up. The cells below A5 in that column move upward; other columns remain unchanged.

Removing a complete record: If a table has names in column A, email addresses in B, and status values in C, select the row number for the record and delete the entire sheet row. This keeps the remaining fields associated with the correct records. If other unrelated content shares that worksheet row, consider whether deleting the full sheet row is appropriate.

Keeping a blank space for a future entry: Select the cell and press Delete to clear its contents. The rows below remain where they are, so formulas and layout that depend on fixed row positions are less likely to shift. If you also need to remove the cell’s formatting, use the relevant option under Home > Editing > Clear.

Frequently Asked Questions

What is the Excel shortcut to delete cells? In Excel for Microsoft 365 on Windows, select the cells and press Ctrl+- to open the Delete dialog. Choose how to shift surrounding cells, or remove an entire row or column.

Does pressing Delete remove cells in Excel? No. The Delete key clears the selected cells’ contents but leaves the cells in place. Use Ctrl+- when you want to delete cells and choose how neighboring cells should shift.

How do I delete cells without shifting other cells? Excel’s Delete Cells command removes cells by shifting other cells up or left, or by deleting a whole row or column. To leave the layout unchanged, clear the contents with Delete instead; the cells remain empty in their original positions.

How do I delete a row with the keyboard? Select the row by clicking its row number, then press Ctrl+- on Windows. You can also use Home > Cells > Delete > Delete Sheet Rows. Check the rest of the row first, because the whole worksheet row is removed.

What is the Mac shortcut for deleting cells? In Excel for Mac, Control+- is generally used to invoke the delete-cells command. If the key combination is unavailable or behaves differently on your keyboard, use the Home tab’s Delete command.

Related

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.