How to delete blank rows in excel shortcut?

How to delete blank rows in excel shortcut?

How to remove empty rows in excel at the bottom and in between rows. I have thousands of rows and hundreds of blank spaces and I want to remove all those blank rows. How do I delete those empty rows from my excel workbook? Is there any formula or shortcut to do this job?

Answered question
6

How to delete empty rows in Excel

Step 1: Select the column first on which basis you want to delete rows

Select Column

Steps 2: On HOME tab go to the last option Find & Select

Excel Home X Find Select

 

Step 3: Click on Go To Special…

Go To Special

 

Step 4: Select Blanks option

Select Blanks

 

Step 5: Find the Delete ▷ option and click on down menu and select Delete Sheet Rows.

Delete Sheet Rows

That’s it. DONE. You will get the results like below-

Result After Process

All respected columns will also be deleted. I hope this has helped you. Please upvote this if you find this answer helpful.

Posted new comment

Thank you @Jasmine it was really very helpful and exactly what I was searching for. Thanks for providing such a fast solution.

This is a good and helpful guide. Before this, I was doing it manually and it used to take 30 min to 90 min but now it just took 50 seconds to apply that formula. Kudos. 🙂

Add a Comment
3

I want to delete complete rows instead of cells, so how to delete blank rows in excel but not blank cells?

Changed status to publish
0

That’s what I was looking for. Thank you so much for this easy to understand guide. I used to do it manually but this guide saved me more than half an hour.

Changed status to publish
0

This is a good and helpful guide. Before this I was doing it manually and it used to take 30 min to 90 min but now it just took 50 seconds to apply that formula. Kudos. 🙂

Answered question
0

Your guide was really helpful for me. No tricky ideas or complex formulas, even a non-technical person could implement it easily. Screenshots helped me a lot to understand easily.

Answered question
0
Write your answer.