| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I HIDE a row if all cell values are zero?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
