| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Hide Rows
How about just selecting that column and doing data|Filter|autofilter.
Then you can show cells not equal to 0. wrote: HI All, How do I conditionally rows if a certain cell = 0? For example, if any cell within range BA5:BA37 =0 then hide row. Any help will be appreciated. Thanks. James -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Way to conditionally hide rows? | Excel Worksheet Functions | |||
| a way to conditionally hide tabs in a range | Excel Discussion (Misc queries) | |||
| Is there a way to conditionally hide a row? | Excel Discussion (Misc queries) | |||
| Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
Threaded Mode
