| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding rows
Is there any way to hide a single row based on a value in the row? Or in a
value in another row? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding rows
Manually / Automatically?
One way would be to use a helper column and then have an IF statement or perhaps a VLOOKUP, that returned a value such as "Show" or "Hide" based on whatever criteria you want to set. You can then just use Data / Filter / Autofilter to show just the "Show"s -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) "bobb" wrote: Is there any way to hide a single row based on a value in the row? Or in a value in another row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel hiding rows | Excel Discussion (Misc queries) | |||
| Hiding rows if specific cell does not contain key word | Excel Worksheet Functions | |||
| Hiding Rows Leaves Labels Blank | Excel Discussion (Misc queries) | |||
| 2 questions one on list/combo boxes and the other on "atomically" hiding columns or rows. | New Users to Excel | |||
| Hiding rows before printing | Excel Discussion (Misc queries) | |||
Linear Mode
