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?
How to delete empty rows in Excel
Step 1: Select the column first on which basis you want to delete rows
Steps 2: On HOME tab go to the last option Find & Select
Step 3: Click on Go To Special…
Step 4: Select Blanks option
Step 5: Find the Delete â–· option and click on down menu and select Delete Sheet Rows.
That’s it. DONE. You will get the results like below-
All respected columns will also be deleted. I hope this has helped you. Please upvote this if you find this answer helpful.
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. 🙂
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.
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. 🙂
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.
I want to delete complete rows instead of cells, so how to delete blank rows in excel but not blank cells?
Thank you @Jasmine it was really very helpful and exactly what I was searching for. Thanks for providing such a fast solution.