Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows if cells = 0.00
I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell
in column D = 0.00 than hide the row containing that cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows if cells = 0.00
Highlight your data, then from the menu bar select Data Filter
Autofilter. Select the drop-down in column D and choose Custom. Use the drop-downs to set your selection to read 'does not equal' '0.00', then click OK. Those rows with 0.00 in column D should now be filtered out (they're still in your data, just not visible). --Bruce "dford" wrote: I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell in column D = 0.00 than hide the row containing that cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows if cells = 0.00
Thanks Bruce. That is what I was looking for.
"bpeltzer" wrote: Highlight your data, then from the menu bar select Data Filter Autofilter. Select the drop-down in column D and choose Custom. Use the drop-downs to set your selection to read 'does not equal' '0.00', then click OK. Those rows with 0.00 in column D should now be filtered out (they're still in your data, just not visible). --Bruce "dford" wrote: I am trying to hide rows if any cell in a columm = 0.00. Example: If any cell in column D = 0.00 than hide the row containing that cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to hide rows across several worksheets fails | Excel Discussion (Misc queries) | |||
macro to hide rows if cell is blank | Excel Worksheet Functions | |||
Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) | |||
can you hide rows with a formula? | Excel Discussion (Misc queries) | |||
How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions |