How to Delete Rows in Excel

How to Delete Row in Excel

Would you like to know how you could easily delete one or more rows in Excel? We can take a look at it together in this video tutorial!

See the video tutorial and transcription below:

See this video on YouTube: 
https://www.youtube.com/watch?v=xlwrRrVORKg

If you’re asking how to remove rows in Excel, you’re in the right place! To find the answer, we’ll use the data table you can see right in front of you now.

First, you need to click on the selected row heading represented by a number located on the left side of the spreadsheet. That’s how you mark the row you want to remove. In our case, this is gonna be row 3 with Lucy.

How to Delete Rows in Excel - mark the row you want to delete

Now right-click and choose the option ‘Delete’.

How to Delete Rows in Excel - delete option

And that’s all you need to do! You may have spotted that the order of the rows got adjusted to the change we’ve made. George’s not in row 4 anymore, but he’s moved to row 3.

How to Delete Rows in Excel - deleted row

And here are two tips to make your life with Excel easier:

How to Remove Multiple Rows That Are Next to Each Other at Once in Excel

If you need to remove multiple rows that are next to each other at once, select the first row of the batch – click on the left button of the mouse, then hold and drag through all the rows you want to delete.

You don’t need to waste your time counting the number of rows you’re highlighting – Excel will do that for you! Just look at the little box on the right where you’ll see the selected row count.

How to Delete Rows in Excel - delete multiple rows

Once you’ve marked all the rows you want to remove, repeat the steps you already know – right-click into the highlighted area and select ‘Delete’.

How to Delete Rows in Excel - delete more rows at once

Good job!

How to Delete Rows in Excel - delete multiple rows at once

But watch out!

How to Remove Multiple Rows That Are Not Consecutive

If the rows you need to delete are not consecutive, you’ll have to try a slightly different way to remove them.

Select the rows by clicking on the first one, then find and press on the keyboard the ‘Ctrl’ key. While holding it, select any row you need by simply clicking on it. Let’s pick rows 4, 7 and 10, now.

How to Delete Rows in Excel - delete not consecutive rows

Use the right-click, choose ‘Delete’, and we’re done!

How to Delete Rows in Excel - choose delete option

There’s one thing to keep in mind, though.

How to Prevent Loss of Data in Excel

In this tutorial, you saw how to delete rows from a spreadsheet.  Before you remove any rows, make sure you won’t need the data they contain, since all the information becomes lost after deletion.

If you still need the information contained in the rows you intend to remove, it’s always better to hide them.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a ‘like’ and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.