Delete All blank Rows - Excel Tips and Tricks

Описание: 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?

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ