Welcome to Tech Leveller! I’m Lee, I’m going to show you how to use Excel in a simple, yet effective way. You can learn How to Delete Row in Excel with this tutorial.
How to Delete Row in Excel Video
How to Delete Row in Excel
It’s easy, simply click on the row heading on the left side of the spreadsheet, right-click and select ‘Delete‘.
This will adjust the order of the rows accordingly.
How to Remove Multiple Rows
For more efficiency, you can remove multiple rows at once by selecting the first row and then dragging your mouse through all the rows you want to delete.
Excel will take care of counting them for you.
Just look at the small box on the right to see the row count.
But be careful!
If the rows you need to delete are not consecutive, you’ll have to use a different approach.
Select the rows by clicking on each one, while pressing the ‘Ctrl‘ key on your keyboard.
Then right-click and choose ‘Delete‘.
Remember, if you want to keep the data contained in the rows, it’s better to hide them instead of deleting them.
If you would like to know more on how to manage rows in Excel, like how to hide or unhide rows, read our next tutorial.
If you found this tutorial helpful, and if you want to learn Excel. Our complete guide section is the place to go that will help you use Excel like a boss!
Want to learn how functions work in excel then check out my excel functions page where you will learn many of the functions. Or looking for formulas? Well, we have you covered there too with our Excel Formulas page.