Web Analytics Made Easy -
StatCounter

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.

Selected answer as best
3

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

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

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

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
Write your answer.