As a regular Excel user, it is very common to have data with blank rows within them. It is not recommended to start using or analyzing a data that has blank rows. Some of the problems that a user might face while using such a data are :-

• Unable to apply Filters
• Unable to use shortcuts like [ Ctrl + D ] or [ Ctrl + Down Arrow ]
• Having (blanks) displayed if Pivots or Slicers are applied on such a data

Usually, the way to eliminate blanks from a data is to convert the entire range into a table, filter the blanks, and delete those rows.

However, this method is possible only when there is at least one column in the data set that has blank cells only in case of an entirely blank row. For a data that does not have any such column, an alternative solution needs to be used.

In this video, we have used the COUNTA function to remove blank rows from such a data set.

Do watch the video for the entire step-by-step process of using the COUNTA method and post your Feedback or Queries in the comments section.

Thank you!

Keep EXCELing !