Share this article
Improve this guide
How to Delete Multiple Rows in Excel at Once [Simplified]
Use this shortcut to delete multiple rows in no time
3 min. read
Updated onSeptember 6, 2024
updated onSeptember 6, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Microsoft Excelis one of the popular programs that is used by billions of people to manage their data and bills. It is used by businesses to keep track of their finances, inventory, and more.
The fact that businesses are relying on the application to manage their data, they often need to delete multiple records from Excel documents.
One of the users who experienced problems while deleting multiple rowsreportedon forums.
How can I delete multiple rows inExcel? If I mark everything and try to delete, it just deletes a single row. Even if I right-click and select delete, it still deletes one row at a time. I need to delete all rows separately selected with Ctrl in one go.
Fortunately, there are many ways that you can use to delete multiple rows from an Excel sheet in one go.
How can I delete multiple rows in Excel?
1. Delete Multiple Rows through Contextual Menu
You can easily delete multiple rows in Excel by using the application’s built-in contextual menu. All you need to do is to select the rows you want to remove and to press theDeletebutton.
1. Open theExcelsheet that you want to delete rows from.
-
Select all the rows that you want to delete.
-
Right-click the selection to open theContextual Menu.
-
SelectDeleteorDelete rowsfrom the list of options.
5.A drop-down menu will open on your screen.
6.SelectDelete Sheet Rowsto delete the selection.
2. Delete multiple Rows using a Shortcut key
This method applies to both multiple consecutive and non-consecutive rows.
3. Delete multiple rows through cell selection
4. Delete multiple Rows by running a Macro
Change the row number references (“C4:C6”) to choose the specific rows that you want to delete. For instance, if you want to delete nonconsecutive rows (3,7,8), you can specify the range as (“C3,C7,C8”). Specify the name of your worksheet by changing Sheet1.
Finally, click theRunbutton or pressF5to run the script.
This can come in handy if youcan’t insert a row in Excelbecause there are too many available already.
Which of the following method worked for you? Let us know in the comments section below.
More about the topics:Excel,Microsoft Office,windows 10
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
