Shortcuts Recipe Remove Blank Rows

Tip: Shortcuts Recipe Remove Blank Rows

In this video, we’ll look at a simple shortcut recipe for removing thousands of blank rows in a large set of data. Shortcut recipes are just a series of shortcuts you perform in a certain sequence to solve a specific problem.

In this first example, we have a big set of data that contains a lot of blank rows. If I move to the last cell, you can see that there’s over 36,000 rows of data, and, looking at the count, just over 33,000 rows actually contain data, which means over 3000 rows are blank.

Duration 
1:46
Author 

Related shortcuts

CtrlSpace

Space

Ctrl

Leave a Reply

Your email address will not be published. Required fields are marked *