Free tools Windows power users keep installed
One-click scans. No signup required.
To delete several rows in Excel, select their numbered row headers, then right-click the selection and choose Delete, or use Home > Delete > Delete Sheet Rows. Excel removes the selected worksheet rows and shifts the rows below upward. On Windows, the keyboard route is Shift+Spacebar to select a row followed by Ctrl+Minus (-) to delete the selected rows.
The important distinction is selecting the row headers rather than cells inside the rows. Selecting cells and clearing their contents leaves the worksheet structure in place; deleting sheet rows removes the rows themselves.
As an Amazon Associate I earn from qualifying purchases.
What deleting rows actually changes
A worksheet row is the complete horizontal strip identified by a number on the left side of the grid. When you delete one or more of those rows, Excel removes the rows and closes the gap by moving every later row upward. Formulas, references, formatting, and tables can therefore change position or adjust to the deletion.
Clear Contents, by contrast, removes values (and, depending on the command, formulas or formatting) from existing cells but leaves the row numbers and worksheet layout where they are. Use deletion when the records and their positions must disappear. Use a clear command when you need empty rows to remain available for a template, spacing, or fixed-position report.
#1 Best Overall
- Classic Office Apps | Includes classic desktop versions of Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, and presentations with ease.
- Install on a Single Device | Install classic desktop Office Apps for use on a single Windows laptop, Windows desktop, MacBook, or iMac.
- Ideal for One Person | With a one-time purchase of Microsoft Office 2024, you can create, organize, and get things done.
- Consider Upgrading to Microsoft 365 | Get premium benefits with a Microsoft 365 subscription, including ongoing updates, advanced security, and access to premium versions of Word, Excel, PowerPoint, Outlook, and more, plus 1TB cloud storage per person and multi-device support for Windows, Mac, iPhone, iPad, and Android.
Check the range before you remove anything
Deleting rows is easy to undo, but a quick check prevents a large accidental change.
- Read the first and last row numbers in the selection.
- Confirm that the entire row headers are highlighted, not just a few cells.
- Look for active filters, hidden rows, grouped outlines, or frozen panes that could make the visible layout misleading.
- If the rows contain formulas or linked data, consider whether moving later rows upward will alter references or downstream calculations.
- Save the workbook, or at least make sure you can use Undo immediately if the result is not what you intended.
Delete a block of adjacent rows with the mouse
Adjacent rows form one continuous block, such as rows 12 through 18. This is usually the quickest method when you can see the target range.
- Find the first row to remove and place the pointer over its numbered header on the far left.
- Press and hold the mouse button, then drag down or up until every row in the block is highlighted. You can also click the first header, hold Shift, and click the last header to select the range.
- Verify that the highlight covers the full row width and that all intended row numbers are included.
- Right-click any highlighted row header.
- Choose Delete. Excel removes the selected sheet rows and moves the remaining rows upward.
If you right-click a cell instead of a row header, Excel may offer a cell-deletion dialog with options such as shifting cells left or up. That is a different operation. Return to the numbered headers and select the whole rows when the rows themselves must be removed.
Recommended Free Tools
Delete non-adjacent rows
Non-adjacent rows are separated by rows you want to keep, such as rows 5, 9, and 14. Excel can delete several separate ranges in one operation when the client supports multi-range selection.
- Select the first target row by clicking its numbered header.
- Add another row or range with the platform’s multi-range selection modifier. Keep the modifier pressed while clicking each additional row header or dragging across another contiguous range.
- Continue until every row to remove is highlighted. Rows between the selected ranges should not be highlighted.
- Right-click one of the highlighted headers and choose Delete, or use Home > Delete > Delete Sheet Rows.
- Inspect the resulting row numbers. Because the remaining rows close upward, their numbers will change after deletion.
Selection behavior and modifier keys vary between Excel for Windows, macOS, the web, iOS, and Android. If separate ranges cannot be maintained in your client, delete one range at a time and verify the sheet after each operation. Always select headers, not isolated cells, so each command targets complete worksheet rows.
Rank #2
![Microsoft Office Home & Business 2024 | Classic Desktop Apps: Word, Excel, PowerPoint, Outlook and OneNote | One-Time Purchase for 1 PC/MAC | Instant Download [PC/Mac Online Code]](https://m.media-amazon.com/images/I/41H8B5iqO4L._SL160_.jpg)
- [Ideal for One Person] — With a one-time purchase of Microsoft Office Home & Business 2024, you can create, organize, and get things done.
- [Classic Office Apps] — Includes Word, Excel, PowerPoint, Outlook and OneNote.
- [Desktop Only & Customer Support] — To install and use on one PC or Mac, on desktop only. Microsoft 365 has your back with readily available technical support through chat or phone.
Use the Windows keyboard shortcut
Windows Excel provides a fast sequence for row deletion. The shortcut works best when the active selection is a complete row or set of complete rows.
- Click any cell in the row you want to select.
- Press Shift+Spacebar. Excel selects the entire row containing the active cell.
- For a contiguous range, extend the selection with Shift+Arrow, or select additional numbered headers directly with the mouse.
- Press Ctrl+Minus (-). Excel deletes the selected rows.
Microsoft’s shortcut reference lists Shift+Spacebar for selecting a row and Ctrl+Minus for deleting selected cells, rows, or columns. The minus key is the hyphen/minus key represented in the shortcut; keyboard layouts and compact keyboards can place it differently. If Excel opens a Delete dialog instead of immediately removing rows, check that the selection is the full row rather than a few cells, then choose the row-deletion option.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Use the Home ribbon command
The ribbon is useful when you prefer visible commands or when your keyboard layout does not match the shortcut examples.
- Select one or more complete rows using the numbered headers.
- Open the Home tab.
- Open the Delete menu in the Cells area.
- Choose Delete Sheet Rows.
This command makes the scope explicit: it deletes worksheet rows rather than merely removing the contents of selected cells. The same menu also contains other deletion choices, so read the command label before confirming.
Mac, web, iPhone, and Android differences
Excel has separate shortcut documentation for Windows, macOS, the web, iOS, and Android. Key combinations and menu labels can differ, and Microsoft notes that its shortcut examples use a US keyboard layout. A shortcut that works on Windows may therefore do nothing, invoke another command, or require a different key on another platform.
Rank #3
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
The platform-neutral approach is to select the numbered row headers and use the client’s visible Delete command. On a desktop browser or Mac, right-click (or the equivalent secondary-click gesture) a highlighted header and choose the row-deletion command if it is offered. On a phone or tablet, use the row-selection handle or row menu exposed by that Excel app, then choose its Delete option. If a command is unavailable, use the platform’s Home or contextual menu and confirm that it says rows, not contents.
Delete rows or clear their contents?
| Goal | Command to use | Result |
|---|---|---|
| Remove the records and close the gap | Delete on selected row headers, or Delete Sheet Rows | The worksheet rows disappear and later rows shift upward. |
| Keep the row positions but make them empty | Clear Contents or the appropriate clear command | Values or formulas are removed while the rows remain in place. |
| Remove formatting without removing rows | A formatting-specific clear command | The worksheet structure remains; only the selected formatting is changed. |
| Remove a record from a structured table | The table’s row-deletion command | The table record is removed according to the table’s own structure and totals behavior. |
Do not substitute a clear command when a report, import range, or dataset must close up. Conversely, deleting rows from a fixed layout can move labels, formulas, or print areas unexpectedly.
Rows hidden by filters, outlines, or panes
Hidden rows make selection harder to read. A filter may display only matching records, an outline may collapse groups, and frozen panes may keep headers visible while the target area scrolls. Before deleting, inspect the filter indicators and the row numbers around the highlighted area.
- Confirm whether the selection includes only visible rows or also rows hidden by the current view.
- Temporarily clear or review the filter when you need certainty about which records are selected.
- Expand grouped rows if you need to see every row in the proposed deletion range.
- After deletion, check the first visible row below the selection and the filter result to ensure the expected records remain.
Microsoft’s shortcut and row-selection pages document row commands and hidden-row controls but do not specify every filtered-deletion behavior for every Excel build. If the workbook uses complex filters, test the operation on a copy or delete a small, clearly identified range first, then verify the result in the specific version you use.
Deleting records inside a structured table
An Excel table has its own record boundaries, header row, calculated columns, filters, and optional totals row. If your intention is to remove table records, use the table’s row-deletion command rather than treating the grid as an ordinary range.
Rank #4
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- Up to 2 TB Shared Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Share Your Family Subscription | You can share all of your subscription benefits with up to 6 people for use across all their devices.
- Click inside the record or records to remove.
- Use the table-specific context or ribbon command that deletes table rows.
- Check that the table’s filter, calculated columns, and totals row still cover the intended range.
- Confirm that you deleted records, not merely the values inside their cells.
Deleting entire worksheet rows that intersect a table can also affect content immediately above or below the table. When the task is “remove these table entries,” stay within the table command set and inspect the table boundary afterward.
Undo an incorrect deletion
Excel’s Undo command can reverse a recent row deletion. On Windows, Microsoft lists Ctrl+Z; on macOS, the corresponding shortcut is Cmd+Z. You can also use the Undo control in the application interface.
- Stop editing the workbook as soon as you notice the mistake.
- Use the appropriate Undo shortcut or button once.
- Check that the deleted rows and their contents have returned.
- If several unrelated actions occurred afterward, use the undo history carefully so you do not remove valid work.
Undo availability can be affected by closing the workbook or by operations that reset the action history. Saving a backup copy before a large deletion is safer than relying on recovery after the fact.
Choose the method that fits the selection
| Situation | Most practical method | Why |
|---|---|---|
| A visible block of neighboring rows | Drag across row headers, then right-click Delete | It is quick and makes the range easy to inspect. |
| Several separated rows | Build a multi-range header selection, then delete once | One command removes all selected ranges while leaving unselected rows. |
| Repeated work on Windows | Shift+Spacebar, extend the selection, then Ctrl+Minus | The keyboard avoids moving between the grid and menus. |
| Unfamiliar keyboard or platform | Use row headers and the visible Delete command | It avoids relying on a platform-specific key combination. |
| A filtered or grouped worksheet | Review the view first, then delete a verified selection | Hidden rows can make the apparent range differ from the actual selection. |
| Records inside an Excel table | Use the table’s row-deletion command | It preserves the table’s record and calculated-column behavior. |
Common problems and fixes
Only cell values disappeared
You probably used a clear command or selected cells instead of headers. Press Undo, select the numbered row headers, and use Delete or Delete Sheet Rows.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsThe wrong rows moved upward
The selection was broader than intended, or hidden rows were included. Undo immediately, inspect the row numbers and filter state, and repeat with a smaller, visible selection.
Best Value
- GREAT ALTERNATIVE - This Open Office Suite is a great alternative to MS Office and enables you to create beautiful and practical Documents, Spreadsheets, and Presentations.
- VERSITLE - This DVD includes both Windows and Mac installation files, just follow the steps included on installation guide.
- LICENSE - Perpetual License granted and when connected to the internet the Open Office Suite will check for uptades and will give you the option to install them.
- EXTRAS - Enjoy all the Extras- Installation Guides, User Guides, Clipart Library, Template Library are all included on the DVD.
- COMPATIBLE - Extensive compatibility across Windows 11, 10, 8, 7, Vista, XP and MacOS 10.7 to 10.15
Ctrl+Minus did not remove the rows
Check that the active selection is a complete row. Press Shift+Spacebar first, extend the selection if needed, and try the shortcut again. A non-US keyboard layout or a web/mobile client may use different shortcuts; use the visible Delete command when in doubt.
Excel shows a choice between shifting cells and deleting rows
That dialog appears when Excel sees a cell-range selection. Cancel it, select the full row headers, and invoke the command again. Choose a cell-shift option only when you intentionally want to rearrange cells without removing worksheet rows.
The table still contains an empty line
Clearing a table record’s contents is not the same as deleting the table row. Use the table-specific row-deletion command and then verify the table boundary and totals row.
Worked examples
Removing rows 20 through 24
Click row header 20, drag through header 24, right-click the highlighted block, and choose Delete. The former row 25 moves into row 20, and every later row receives a new number.
Removing rows 3, 8, and 15 while keeping the others
Select header 3, add header 8 with the platform’s multi-range modifier, then add header 15. Confirm that headers 4–7 and 9–14 are not highlighted. Delete the selected headers in one operation, then inspect the records now occupying the new row positions.
Emptying a form without changing its layout
Select the input cells rather than the row headers and use Clear Contents. The form’s labels, spacing, and row numbers remain fixed, which is the desired result for a reusable template.
Quick Recap
Final safety checklist
- Select complete numbered row headers.
- Check the first and last selected row numbers.
- Review filters, hidden groups, and table boundaries.
- Use right-click Delete, Home > Delete > Delete Sheet Rows, or the Windows keyboard sequence when appropriate.
- Choose a clear command instead when rows must stay in place.
- Inspect the worksheet after deletion and use Undo immediately if the result is wrong.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
