How to delete rows in Excel quickly and safely
To delete one or more rows in Excel using the fastest keyboard shortcut, select the row or rows you want to remove, then press Ctrl+- (Windows) or Command+- (Mac). Always confirm the shift direction in the dialog that appears when Entire Row is selected, and use Undo (Ctrl+Z or Command+Z) if needed. This shortcut deletes rows instantly and works consistently across recent versions of Excel for Windows and Mac.
Keyboard shortcut details
The core shortcut for deleting rows relies on the minus key on the numeric keypad or main keyboard. After selecting an entire row or multiple rows, pressing Ctrl+- opens a compact action dialog. For predictable results, choose Entire row and confirm with OK. Once you confirm, Excel shifts remaining rows up to fill the gap. This method is stable, widely supported, and suitable for regular use in most workflows.
Verify selection before deleting
Before you run the shortcut, ensure only the target rows are selected. If formulas reference cells in the rows above or below, deleting rows can change the sheet structure and affect calculation results. Double-check the active cell or range to prevent unwanted changes. Because this shortcut immediately removes data, develop a habit of verifying the selection and keeping an eye on the dialog options.
Step-by-step guide
- Select the row or rows you want to delete by clicking the row number or dragging across multiple row numbers.
- Press Ctrl+- (Windows) or Command+- (Mac). If the Delete dialog appears, choose Entire row and then OK.
- Confirm that the rows above the deleted selection move down (or up) to close the gap. If needed, press Ctrl+Z (Windows) or Command+Z (Mac) to undo immediately.
Ribbon and right-click alternatives
If you prefer using the mouse, you can delete rows from the ribbon. Select the rows, go to Home → Cells → Delete → Delete Sheet Rows. Another quick method is right-clicking the selected row number and choosing Delete from the context menu. These options produce the same result as the keyboard shortcut but require more steps.
Ribbon path
- Home → Cells → Delete → Delete Sheet Rows
Undo and recovery best practices
Because deleting rows is irreversible for visible data, leverage Undo immediately if anything looks incorrect. Excel retains Undo for most row-deletion actions, so you can recover content within the same session. If you plan multiple deletions, consider inserting a helper column to tag rows first, or copy the sheet to a backup tab. For critical work, save the file before performing bulk deletions to reduce risk.
Behavior with tables and filtered data
When your range is formatted as an Excel Table, the ribbon and shortcut still work, but behavior can differ slightly. Deleting rows inside a table removes only the data in those rows while keeping the table structure intact. If you apply a filter and then use the shortcut, only visible rows are deleted, which can be useful but may surprise new users. Always check whether you are working with a table or a normal range to avoid unexpected results.
Quick comparison: shortcut vs UI options
| Method | Speed | Undo friendliness | Best use case |
|---|---|---|---|
| Ctrl/Cmd + - shortcut | Fastest | High (immediate Undo) | Quick single or bulk deletes |
| Home → Delete → Delete Sheet Rows | Moderate | High | Ribbon users and mouse workflows |
| Right-click → Delete | Moderate | High | Context menu preference |
Common pitfalls and how to avoid them
A frequent issue is accidentally deleting the wrong rows when similar data appears nearby. To reduce risk, double-check row numbers and ensure filters are cleared unless you intend to delete only visible rows. Another pitfall occurs when other worksheets or formulas refer to the deleted rows; update links and review dependent sheets after large removals. For complex models, perform deletions in a controlled session and keep a clearly labeled backup tab nearby.
Platform notes
The shortcut Ctrl+- is consistent in most current Excel versions for Windows. On Mac, use Command+-. If the shortcut does not work as expected, confirm that you are not in a multi-cell editing state; exit edit mode by pressing Esc or Enter first. Interface differences are minimal across Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016.
Related actions you might need
After deleting rows, you may want to adjust numbering, refresh external data, or clean up broken formulas. Shortcuts such as Ctrl+Shift+= to insert rows or F2 to edit a cell can help you restore sequences quickly. If you frequently manage large removals, consider learning how to filter, hide, or group rows instead of deleting them outright.
When to use alternative methods
For one-time cleanup, the keyboard shortcut is efficient. For ongoing tasks or shared templates, consider helper columns, filters, or table features that hide rather than delete rows. These alternatives let you preserve raw data while presenting a refined view. Choose the approach that matches your comfort level and long-term maintenance needs.