Delete Row Shortcut in Excel: The Complete 2026 Keyboard Guide

Spreadsheets sprawl. One minute you're staring at a tidy data set, the next you're knee-deep in junk rows from a CSV import that decided to add forty-three empty trailers. You could right-click each row, hunt for the Delete option, and lose ten minutes — or you could press two keys.

That two-key trick is Ctrl+- (Ctrl and the minus sign). On its own, that combo asks Excel what to delete: cells, columns, the entire row. Pair it with Shift+Space first, though, and the entire active row is selected up front, so Ctrl+- nukes the row instantly without the follow-up dialog. Two keys. One row. Gone.

This guide unpacks every flavour of the delete-row shortcut in Excel — Windows, Mac, Ribbon path, bulk deletes, non-contiguous selections, Tables, and a tiny VBA macro for the times your boss drops a 90,000-row workbook on your lap and walks away. By the end, you'll never reach for the mouse again when a row needs to go.

And just to set the scene before we dive in: the same Ctrl+- key combination also handles columns (after Ctrl+Space) and even cell ranges (with a follow-up choice in the dialog). So while the focus here is rows, you'll pick up sibling tricks along the way without realising it. Keyboard speed compounds — a habit you build for rows pays dividends every time you wrangle data in Excel.

The Two Shortcuts You Actually Need to Memorise

Excel ships with hundreds of keyboard combinations, and most of us only use a handful. For row deletion, you need exactly two:

Shift+Space selects the entire row that contains the active cell. The status bar at the bottom will flip from showing the cell address to showing how many rows are selected. From that highlighted state, Ctrl+- (Ctrl and the minus key, right next to zero on most keyboards) deletes the selection in one motion. No dialog. No prompt. No "are you sure". The row is gone, and everything below shifts up.

If you skip Shift+Space and press Ctrl+- on a single cell, Excel pops the Delete dialog and asks whether you want to shift cells left, shift cells up, delete the whole row, or delete the whole column. Type R for entire row, hit Enter, and you're done — but the two-step (Shift+Space then Ctrl+-) is faster once it lives in muscle memory.

One question new users ask constantly: is it Ctrl+- or Ctrl+Shift+- (Ctrl+underscore)? The answer is Ctrl+- for delete. Ctrl+Shift+- (which physically presses Ctrl, Shift, and minus together — producing what looks like an underscore on the key) is actually the shortcut for removing borders from a selection. Easy mix-up, completely different result. If you've ever pressed what you thought was the delete shortcut and watched your borders vanish instead, that's the culprit.

The minus key matters too. On a US keyboard, that's the minus sign right of the 0, not the minus on the numeric keypad. The numpad minus works in most builds of Excel but can misbehave on laptops where the numpad sits under a Function-key layer. Stick with the top-row minus key for reliability across machines.

Why Excel Even Needs a Delete Dialog

Here's the quirk that trips up new users. When you press Ctrl+- on a single cell, Excel doesn't assume you want to nuke the whole row — because most of the time, you don't. You might just want to shift cells up to close a gap, or delete a single value without disturbing the structure around it. The dialog exists to ask the question.

The moment you select a full row first (Shift+Space), Excel knows exactly what you want. Ctrl+- then becomes unambiguous, the dialog skips itself, and the deletion happens immediately. Same logic applies to columns: Ctrl+Space selects the entire column, and Ctrl+- removes it without prompting.

This is a small thing, but it's the difference between a four-keystroke delete and a two-keystroke delete. Multiply by 200 rows of clean-up and the seconds compound into minutes.

There's a related shortcut worth bookmarking: Ctrl+Shift++ (Ctrl+Shift+plus) is the Insert dialog. It mirrors Ctrl+- in every way except it adds rather than removes. Combined with Shift+Space, it inserts a row above the current one. So your row-management duo is really a quartet: Shift+Space, Ctrl+- to delete, Ctrl+Shift++ to insert, plus Ctrl+Z to undo if anything goes sideways. Learn those four and you'll outpace anyone still mousing around the Ribbon.

The Ribbon Keyboard Path: Alt+H+D+R

Not everyone trusts shortcuts they can't see. If you'd rather watch Excel walk you through the menu, the Ribbon has a fully keyboardable path: Alt+H opens the Home tab, D drops the Delete menu, and R picks "Delete Sheet Rows".

It's four keystrokes instead of two, but it has a nice property — you can pause between each press and Excel will draw the next menu, showing you exactly which key triggers which action. Great for training a colleague, terrible for daily use once the muscle memory's there.

There's also Alt+H+D+C for deleting columns and Alt+H+D+S for deleting the active sheet. Worth knowing if your boss ever asks you to clear a workbook without touching the mouse.

Bulk Delete: Contiguous Rows in One Hit

One row's easy. Forty rows in a block need the same shortcut with one twist: select all of them first.

Click the row number of the first row you want gone. Hold Shift and click the row number of the last row in the block. Every row in between is now selected. Press Ctrl+- and the whole stack disappears. No dialog, no prompt — Excel knows you've picked full rows.

Keyboard-only? Put the active cell on the first row, press Shift+Space to grab that row, then Shift+Down arrow repeatedly (or Shift+Ctrl+Down to jump to the next data boundary) to extend the selection. Ctrl+- finishes the job.

This is the move for cleaning up imported data with header junk, trailing blanks, or sub-totals you don't want.

A real-world example: you've imported a 5,000-row CSV from your accounting system and the first 12 rows are header junk — company name, report title, date range, blank line, column descriptions. You want them gone. Click row 1, Shift-click row 12, Ctrl+-. Twelve rows vanish, the actual data slides up to row 1, and you can start working immediately. Total time: maybe four seconds.

Compare that to the right-click approach: highlight row 1, drag down to row 12 (hoping you don't overshoot), right-click somewhere in the selection, scroll the context menu, find Delete, click. You're looking at fifteen seconds easily, and that's assuming nothing goes wrong. Across a typical analyst's week, the keyboard approach saves real time — not minutes, but cumulatively dozens of them.

Non-Contiguous Rows: The Ctrl-Click Method

What about rows scattered across the sheet — row 3, row 17, row 42, row 88? You can't Shift-click those because Shift selects everything in between. You need Ctrl-click instead.

Click the row number of the first row you want gone. Hold Ctrl and click each additional row number. Each one lights up without losing the previous selection. When you've got them all, release Ctrl and press Ctrl+-. Excel deletes all of them at once and shifts everything below up to fill the gaps.

Heads-up: don't release Ctrl between the click and the shortcut, or you'll lose the multi-selection. And if you accidentally Ctrl-click a row you already selected, that click deselects it. Quick way to fine-tune the set without starting over.

This trick really shines when you're cleaning a list of duplicates. Sort the data, eyeball the duplicate rows, Ctrl-click each second occurrence, Ctrl+-, done. You haven't disturbed the surrounding data, you haven't used any formula, and you've kept the first occurrence of each value intact. Same job that Remove Duplicates does, but with manual control over which copy stays — handy when one row has richer notes than the other.

Excel Tables: A Slightly Different Delete

If your data lives inside a formal Excel Table (Insert > Table, or Ctrl+T), the delete behaviour shifts. Pressing Ctrl+- on a cell inside a Table doesn't ask the usual question — it asks whether you want to delete the Table Row or shift cells. Pick Table Row (or just press T then Enter) and only the row inside that Table object is removed. Other content elsewhere on the sheet stays put.

This is brilliant when you've got several tables on one sheet and you don't want a row delete to bulldoze through all of them. It's also the safer option when your Table has structured references in formulas — Excel keeps the references valid as rows disappear.

To use the Ribbon route inside a Table: click any cell in the Table, go to Table Design tab (appears when a Table is active), then use the Delete dropdown for row-specific options.

One subtlety worth noting: Tables behave like data ranges, so Total Rows (if you've turned them on) move automatically as you delete content rows. The Total Row is special — it sits at the bottom, contains formulas like SUM or COUNT, and it isn't itself a "Table Row" in the delete sense. You can't accidentally delete it with Ctrl+- on a content row. To remove the Total Row you toggle it off via the Table Design tab.

Power Query refreshed data sits inside a Table too. If you Ctrl+- a row from a Query-loaded Table, that deletion only lasts until the next refresh — Power Query overwrites with fresh source data and your manually-deleted row returns. So for Query-backed Tables, the cleaner approach is to filter or transform the data inside Power Query itself before it lands. Manual deletion is a temporary patch, not a fix.

The VBA One-Liner for Bulk Deletes

Got a 90,000-row sheet with empty rows scattered through it? Manual selection's a non-starter. Press Alt+F11 to open the VBA editor, insert a module, and drop in this:

Sub DeleteBlankRows()
  On Error Resume Next
  Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

Run it with F5 and every row with a blank in column A gets deleted instantly. Adapt the column letter and the SpecialCells type for different criteria — xlCellTypeFormulas, xlCellTypeConstants, even rows containing specific values via a Find loop.

For non-VBA folks, the same outcome's possible with Filter: filter to show only the rows you want gone, select them, press Ctrl+- to delete, then remove the filter. Slower than VBA but no code involved.

A note on Macros and trust: VBA-enabled workbooks need to be saved as .xlsm (macro-enabled) and you'll see a security warning when reopening them. That warning is doing its job — VBA can do almost anything Excel can, including reach out to the file system. If you're sharing macro-laced workbooks with colleagues, document what the macro does in the workbook itself, and consider signing it with a digital certificate so the warning only fires once per recipient.

The keyboard-only alternative: F5 (Go To) > Special > Blanks > OK selects every blank cell in the current region. Then Ctrl+- > R > Enter deletes the entire rows of those blanks. Five keystrokes plus one click. No code, no macro warnings, same result. This is the recipe most analysts settle into once they realise VBA isn't strictly necessary for the common case.

One Last Tip: Undo Is Your Insurance

Excel's Ctrl+Z (Cmd+Z on Mac) reverses any delete, and the undo history stretches back through quite a few actions. So if you nuke the wrong row — or you delete 40 when you meant 4 — don't panic. Hit Ctrl+Z. It comes back.

One caveat: undo gets cleared when you save the workbook in some older versions of Excel, so if you've just done a major clean-up and you're nervous, copy the sheet first or save a backup. Belt and braces.

The other safety net is Ctrl+Y (or F4 on Windows), which redoes the action you just undid. So if you Ctrl+Z'd one too many times and you've lost the wanted deletion, Ctrl+Y brings it back. Between Z and Y you can step through your history pretty granularly, which is reassuring on big clean-up sessions.

Worth knowing: collaborative workbooks (the ones with multiple people editing at once via SharePoint or OneDrive) maintain individual undo stacks per user. Your Ctrl+Z only reverses your own actions, not the colleague's deletion that just landed three seconds before yours. If a teammate deletes the wrong row in a shared workbook, they have to undo it themselves, and quickly — once another action overwrites the history, the row is gone unless you've kept a backup.

That's the whole story. Shift+Space, Ctrl+-, done. Cmd+- on Mac. Alt+H+D+R if you want a guided tour. Bulk deletes via Shift-click or Ctrl-click. Tables get their own polite dialog. And VBA for when the workbook's bigger than your patience.

The mind-shift that makes all of this stick is small but real: stop thinking of Ctrl+- as "the row delete shortcut" and start thinking of it as "the structural delete shortcut". It works on rows, columns, and cell shifts. What you've selected before pressing it determines what disappears. Once that clicks, you've not just learned a keystroke — you've learned a whole category of Excel behaviour. The same Shift+Space + Ctrl+- pattern will serve you across every workbook, on every operating system, for as long as Excel keeps shipping. That's a solid return on two seconds of practice.