How to hide rows in Excel if all of the columns are not blank?

I have an Excel spreadsheet with 10 columns.

The cells within the first 2 columns contain text and the remaining 8 cells contain 'blank', 0 or 1.

How can I hide all rows where the 8 columns do not contain any blank cells?

1 Answer

Here is an easy work-around:

1. Go to the empty column K.
2. Input the following function: =COUNTIF(C2:K2;"")and copy for entire column.
3. Blank cells will be counted.
4. "8" means all columns are empty for a particular row.
5. Use filter on K column to hide all "8" (to hide empty rows) or mark all numbers except "8" (to display empty rows only).