View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How can I HIDE a row if all cell values are zero?

You can add a helper column to your tabke which sums the row, or does a
COUNTIF on values greater than 0.

In either case you would filter on that column for all values that are
greater than 0.

If you need more detail about how to do either of these two things let me
know.

Dave
--
Brevity is the soul of wit.


"Cindy" wrote:

I have hidden the zero values, but I would like to hide the entire row if all
cell values are 0. This keeps a list that is 25 lines long, visually, to say
3-4 lines long for printing.