Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Is AutoFilter an option for you? There you can say show only "not blank" values. Guess its only called Filter in >=Office 2007 – Langhard Sep 19 '12 at 8:58
I believe (Auto)filter is not an option for this case, since rows need to be filtered using criteria based on more than one column here. – kurp Sep 19 '12 at 9:08
up vote 1 down vote accepted

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).
share|improve this answer
Great workaround - thanks! Please note it's a , instead of a ;. i.e. =COUNTIF(C2:K2,"") – Techboy Sep 19 '12 at 9:32
You're welcome! :) Regarding ';' - well, it depends (just another country and another local settings). My Excel accepts semicolon as a arguments' separator only. But thanks for remark, I'll have in mind in future that there may be a difference here. Greetings from Poland! :) – kurp Sep 19 '12 at 9:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .