You can probably think of various reasons as to why you use Excel. Whether it’s a project for work or not, Excel just helps you organize your data better.
Since mistakes will happen, you’ll surely need to erase data on your Excel document. For those times when you have to delete a lot, it’s best to erase more than one row at a time, but how?
How to Erase More than One Excel Row at a Time
A quick way to erase multiple Excel rows is by right-clicking on cells A1 (for example) and dragging your mouse until all the cells you want to delete is selected.
Right-click anywhere in the selected area, and when the side-menu appears, place the cursor on Delete. A new side-window will appear; here is where you choose what you want to delete exactly.
Or, if you prefer, you can click on the Delete option’s drop-down menu at the top right and choose the choice of your interest.
How to Erase Excel Rows with a Keyboard Shortcut
If you prefer to erase Excel rows with a keyboard shortcut, you can try pressing the Ctrl + minus keys. When the window appears, choose the Entire row option, followed by OK.
How to Erase Multiple Excel Rows Using Macros
To erase Excel rows by using Macros, you-ll need to press the Alt + F11 keys. In the new window, click on the Insert tab, followed by the Module option.
Now it’s time to paste the following:
Sub DeleteEntireRow()
Rows(1).EntireRow.Delete
Rows(3).EntireRow.Delete
Rows(5).EntireRow.Delete
End Sub
The rows that the module will delete will depend on the ones you want to erase. Make sure to make those changes in the data above after you paste it.
Save the Macros and now go back to your Excel document and click on the View tab. To the right, click on the Macros drop-down menu and click on View Macros.
When the Macro window appears, it will indicate that it’s to erase the Excel rows, Click on Run, and the rows will be erased.
Conclusion
The first option is the easiest and fastest way to erase various Excel rows at the same time, but it’s always good to know more ways just in case the first ones fail. Which option are you going to go with?
Did this help? Let us know!