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?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI 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 work-around:
=COUNTIF(C2:K2;"")
and copy for entire column.