Excel Tips and Tricks - Delete All blank Rows

If you have many blank rows in between your table, there is a more productive way to delete them altogether.
Here are the steps.

Deleting All Blank Rows
1) Ctrl + G
2) "Special" button
3) Select "Blank"
4) Ok
5) Ctrl + - (minus)
6) Select "Entire Row"
7) Ok

After the video you should be able to answered the following questions.
Can you Delete blank rows in Excel all at once?
How do I Delete millions of blank rows in Excel?
What is the shortcut to delete all blank rows in Excel?
How do I Delete thousands of rows in Excel?

Can you Delete blank rows in Excel all at once?,How do I Delete millions of blank rows in Excel?,What is the shortcut to delete all blank rows in Excel?,How do I Delete thousands of rows in Excel?,


#microsoft #excel #exceltips #tips #exceltricks #tricksandtips