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

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