| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding rows or columns based on cell contents
I am looking for a solution to hide row or columns in a worksheet based upon
a value in a cell of another worksheet. To be more specific, I have a "setup" worksheet, with a column if entires. I have a second worksheet, "checklist" that I would like to format according to the entries in "setup". If setup:A1 is empty, I want to hide columns checklist 1-3 If setup:A2 is empty, I want to hide columns checklist 4-6. ANy ideas how to set this up automatically ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding rows based on a cell? | Excel Worksheet Functions | |||
| hiding or showing rows based on a cell value | Excel Discussion (Misc queries) | |||
| Hiding rows based value of cell within row | Excel Discussion (Misc queries) | |||
| hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
| Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
Threaded Mode
