Keyboard Shortcut to Delete Row in Excel: All Methods (2026)

The fastest way to remove a row in Excel is a single keystroke. Most people still right-click and hunt through menus, which costs seconds every time. Those seconds add up fast when you are cleaning a 5,000-row report before lunch.

This guide walks through every keyboard shortcut to delete row in Excel on Windows, Mac, and the web. You will learn the core combo, the multi-row trick most users miss, what changes inside an Excel Table, and how to recover when you accidentally nuke the wrong line. Quick, practical, no fluff.

Ready? Open a sheet and follow along. By the end you will be deleting rows without ever touching the mouse, and your spreadsheet workflow will feel a lot lighter.

The Core Shortcut: Ctrl + Minus (Windows) and Cmd + Minus (Mac)

The universal Excel shortcut for deleting things is Ctrl + - on Windows and Cmd + - on Mac. That little minus key is your delete button. Whether it removes a cell, a row, or a column depends on what you have selected before pressing it.

To delete an entire row with this shortcut, you first select the whole row. The fastest way is Shift + Space, which highlights the row containing the active cell. Then hit Ctrl + - and the row vanishes instantly. No dialog, no confirmation, no menus.

If you only have a single cell selected when you press Ctrl + -, Excel pops up the Delete dialog asking what you want to remove. Choose Entire row and press Enter. That extra click is why pairing Shift + Space with Ctrl + - is the real time saver here.

On a Mac laptop without a numeric keypad, the minus key sits next to the zero. You do not need a special Fn combo. Cmd + - works in Excel for Mac 2019, Microsoft 365, and even older Office 2016 versions. The behavior is identical to Windows.

Deleting Multiple Rows in One Shot

Removing one row is fine. Removing forty is where shortcuts really shine. Click the first row number on the left header strip, then hold Shift and click the last row number. Every row between them is now selected. Press Ctrl + - and the entire block disappears.

Need to delete non-adjacent rows? Hold Ctrl (Cmd on Mac) and click each row number individually. Excel lets you build a custom selection of scattered rows. One Ctrl + - press and all of them are gone at once. This trick alone replaces hours of repetitive deleting work.

You can also use Shift + Space on the first row, then add more rows by holding Shift and pressing the down arrow. The selection grows row by row. When the range looks right, fire the delete shortcut. Pure keyboard, zero mouse contact at any point.

One warning: deleting rows shifts everything below upward. Formulas that reference the deleted range may break or return #REF! errors. Always preview which rows you have highlighted before pressing the combo, especially in shared workbooks where you cannot easily undo across user sessions.

Excel Tables Behave Differently

When your data lives inside an Excel Table (the kind you create with Ctrl + T), row deletion follows different rules. Selecting a table row with Shift + Space only highlights the cells inside the table boundary, not the entire worksheet row. Pressing Ctrl + - then removes just the table row and leaves any data outside the table untouched.

This is actually a feature, not a bug. Tables protect surrounding content so you can have multiple datasets on one sheet without them stomping on each other. If you do want to remove the worksheet row across the whole sheet, click the row number on the gray header strip instead of using Shift + Space.

Another quirk: in a Table, the Delete dialog may not appear at all. Excel assumes you want to remove the table row and just does it. If you want the dialog back, convert the Table to a normal range first using Table Design and then Convert to Range.

Using the Delete Dialog for Precision Control

Sometimes you do not want a whole row gone. You only want to shift cells up or remove a column instead. The Delete dialog gives you that control. To open it without selecting a row first, press Ctrl + - on a single cell or small partial selection.

The dialog offers four choices: shift cells left, shift cells up, entire row, entire column. Use the underlined letters to pick fast. Press R for entire row, C for entire column, L for shift left, U for shift up. Then hit Enter. Three keystrokes total, no mouse needed.

Power tip: combine this with named ranges. Select a named range with Ctrl + G, type the name, press Enter, then Ctrl + - and R. You just deleted every row in that range without ever scrolling to find it. Massive time saver on complex models with dozens of named blocks.

Excel for the Web and Mobile

Excel in a browser supports most desktop shortcuts but with some catches. Ctrl + - opens the Delete dialog as expected. Shift + Space selects the row. The combo works in Chrome, Edge, Firefox, and Safari on both Windows and Mac machines. Microsoft has steadily closed the feature gap since 2023.

One thing missing online: keyboard access to the right-click menu via the Menu key on Windows. Web Excel relies on Shift + F10 instead. After selecting a row with Shift + Space, press Shift + F10 to open the context menu, then arrow down to Delete Row and hit Enter. Slower than Ctrl + -, but useful if your shortcut keys are mapped elsewhere.

Mobile Excel on iPad with a physical keyboard supports Cmd + - the same as Mac desktop. iPhone and Android touch Excel obviously cannot use keyboard shortcuts at all, so you tap the row header and choose Delete from the popup menu. Worth knowing if you switch between devices during the day.

What to Do When You Delete the Wrong Row

Everyone does it. You hammer Ctrl + - on autopilot and realize the row you killed had your boss quarterly numbers. Do not panic. Press Ctrl + Z immediately. Excel restores the row and any formulas that pointed to it. You can undo dozens of actions if you catch it within the same session.

If you saved the file and closed it, undo no longer works. Check File then Info then Version History on a OneDrive or SharePoint workbook. Microsoft 365 keeps snapshots automatically. For local files, look in the AutoRecover folder under AppData Microsoft Excel on Windows or under the Library Containers path on Mac.

The best defense is prevention. Keep a copy of large datasets in a separate sheet before you start bulk deletions. Or use Excel Track Changes if you are collaborating. A few seconds of setup beats hours of trying to rebuild lost rows from email backups later.

Advanced Deletion Patterns

Filtered rows behave oddly with Ctrl + -. When a filter is active, selecting visible rows with Shift + Space and pressing the shortcut sometimes also wipes hidden rows that fall inside the selection range. To stay safe, use Alt + ; first to constrain the selection to visible cells only. Then delete with confidence.

Want to delete every blank row in a sheet? Press F5 to open Go To, click Special, choose Blanks, and hit OK. Excel highlights every empty cell. Then Ctrl + - and pick Entire row from the dialog. Every blank row across your dataset disappears in one move. The full walkthrough lives in the remove empty rows in Excel guide.

For VBA fans, the equivalent code line is Rows(5).Delete or Range("A5:A10").EntireRow.Delete. Wrap it in a loop and you can clean thousands of rows based on any criteria. The VBA in Excel guide covers the syntax in depth, and the Excel VBA macros guide has ready-made cleanup snippets.

Building Speed With Practice

Keyboard shortcuts only stick when you force yourself to use them. For one week, ban yourself from right-clicking to delete rows. Every time your hand reaches for the mouse, stop and use Shift + Space then Ctrl + -. By Friday it will feel automatic. Muscle memory takes about 100 reps to form properly.

Pair row deletion with insertion practice. The insert row shortcut guide covers Ctrl + Shift + + for adding rows, the mirror image of what you just learned. Together they let you restructure a sheet with zero mouse contact, which is exactly how Excel pros stay fast every day.

Curious about other shortcuts? The Excel shortcuts cheat sheet lists 80 plus combos worth memorizing, and Excel hotkeys breaks them down by category. Pick three new ones each week and you will be a power user inside two months.

One last habit: keep a printed cheat sheet next to your monitor. Looking at the row delete combo for two seconds is faster than fishing for the menu. Eventually you stop looking and just type. That is when Excel finally feels like a tool that bends to your speed rather than slowing you down at every step.

Final Take on Excel Row Deletion

If you only remember one thing from this guide, make it the two-step combo: Shift + Space then Ctrl + - on Windows, or Shift + Space then Cmd + - on Mac. That single pair handles 90 percent of all row deletion work in any spreadsheet you will ever open.

For the remaining 10 percent, lean on the Delete dialog when you need shift-up behavior, the Go To Special trick when you need to clear blanks in bulk, and Ctrl + Z when you inevitably make a mistake. These three tools together cover almost every situation Excel can throw at you.

Practice the combo on real work tasks for a week and it will stop feeling like a shortcut and start feeling like the default. That is when you save real time and stop dreading large cleanup tasks. Open a sheet now and try it. Your future self will thank you when the next big dataset lands in your inbox.

Why Excel Chose This Particular Shortcut

The Ctrl + - and Cmd + - combo is not arbitrary. Microsoft picked the minus key because it visually represents removal, which makes the combo easier to remember years after you first see it. The pairing dates back to Excel 97 on Windows and stayed identical through every version since, a rare example of UI consistency across three decades.

Why use Ctrl instead of just the minus key? Ctrl is the modifier that signals a command rather than literal input. Without it, pressing minus in a cell would just type a minus sign. The same logic applies to Cmd on Mac. Modifier plus action key gives Excel a clean way to separate keyboard commands from data entry without conflicts.

Older versions, Excel 95 and 5.0, used different combos that disappeared after the 1997 redesign. If you maintain really old workbooks or run Excel in a virtual machine for legacy reasons, the shortcuts may behave differently. Anything from Excel 2007 onward uses the modern Ctrl + - or Cmd + - pattern though, so most users will never need to worry about that legacy history at all.

How Row Delete Compares to Other Excel Cleanup Shortcuts

Knowing Ctrl + - alone is not enough. The shortcut sits inside a family of cleanup combos that work together to scrub a worksheet fast. Delete contents (not the row itself) lives on the Delete key, which clears values but keeps the row in place. Use it when you want an empty row rather than a removed one entirely.

Cut a row with Ctrl + X and then paste it somewhere else with Ctrl + V to move data without losing formulas. This is different from deleting because nothing disappears, it just relocates. Pair it with Shift + Space to grab the full row first, exactly like the delete combo we covered earlier.

Clear formats with Alt + H + E + F on Windows. The keyboard ribbon walk lets you strip styling without touching values. Combine all three (delete, cut, clear formats) and you can reorganize a messy import sheet in under five minutes once the muscle memory is built up properly through daily practice.

One More Speed Tip Worth Knowing

Once you have the basic combo down, layer on the keyboard ribbon walks for power moves. Alt + H + D + R on Windows opens the Home tab and walks the keyboard down to Delete Rows, an alternative path that lives in the ribbon instead of the Ctrl + - shortcut. Some users prefer it because it shows visual feedback at each step.

Mac users can hit Fn + F10 to focus the ribbon, then arrow over to Home and use the same H, D, R sequence. The extra keystrokes seem slower at first, but they teach the ribbon structure and unlock dozens of other commands you can chain together the same way. Worth practicing for an afternoon if Excel is core to your daily work routine.

Finally, remember that Excel keyboard mastery compounds. Every new shortcut saves a few seconds, but ten new shortcuts save several minutes per workbook. Multiply that across hundreds of spreadsheets per year and the time savings hit serious numbers, easily reaching dozens of working hours back in your calendar annually.