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?
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? 


Here is an easy workaround:


