How to work with Excel data with blank rows

How to work with Excel data with blank rows without using a macro.
Select the complete data
Go to the Data Tab
Select Filter from the command group Sort & Filter
Click on one of the drop-down arrows on the header row
Under Text Filters de-select the item (Blanks).
Click OK.
All the blank rows are removed.
Now you can perform actions on the data like AutoFilter.

Watch the training video:

Further reading:
Guidelines for organizing and formatting data on a worksheet

Leave a Reply

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