Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In , Tom Ogilvy
spake thusly: Not sure this is what you want, but If you want to hide all arrows, go to Tools=Options=View and under the objects entry, select hide all. Interesting. I want most of them, though. Only want to hide a subset of the AutoFilter arrows. (I'm using Excel 2002 under XP Pro.) I know I can have the arrows only on a set range. E.g., if my sheet has columns A-Z but I highlight only columns C-E, then select Data - Filter - AutoFilter, the pull-down arrows are only there for those columns. That's fine as far as it goes. The range apparently has to be contiguous. So I can't just highlicht columns C, H, and Y and have the arrows visible there only. All columns between C and Y also get arrows when I try to turn on AutoFilter for that range. If only C, H, and Y had arrows, I'd be happy enough. However, I'm only setting a static filter choice once in Columns H and Y -- the rest of the time, I'm only filtering with Column C. So ideally, I'd like only to see a pull-down arrow for Column C, but have Columns H and Y retain the filtering that I've given them. -dman- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn on Auto Filter?? It is grayed out. | Excel Discussion (Misc queries) | |||
Cell protection & Auto Filter | Excel Worksheet Functions | |||
Auto Filter problem | Excel Worksheet Functions | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) |