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

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
You are viewing 1 out of 5 answers, click here to view all answers.
Write your answer.