Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select your range (don't let excel guess) and then use:
Data|Filter|Autofilter (in xl2003 menus) Then you'll be able to use the dropdown arrows in that first header row to show just the values you want. There's a custom option, too. Jeff wrote: I would like to be able to conditonally hide row based upon a value in a column of the spreadsheet. I assume I would need to create a macro, but I'm nt real good with macros. Can anyone help with this? Thank you. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I conditionally hide or show a column in Excel | Excel Discussion (Misc queries) | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Way to conditionally hide rows? | Excel Worksheet Functions | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |