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

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