EASY Trick - Delete All Blank Rows - Excel Tips and Tricks

Discover how you can delete all blank rows with a simple clicks.

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?

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

Видео EASY Trick - Delete All Blank Rows - Excel Tips and Tricks канала Rabi Gurung