Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do my Autofilter icons no longer appear?
Until recently, the small Autofilter icon at the head of one or more columns
(indicating that the Autofilter function is enabled for that column) was there when expected. This morning, for the first time, I don't see them. When I pull down Data - Filter I see that the Autofilter is indeed checked but there are no icons at the top of any of the columns. I used filtering extensively. What happened? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do my Autofilter icons no longer appear?
Did you apply AutoFilter to a different part of the worksheet? If so, that
would replace your original AutoFilter. There can only be one set per sheet. Try turning off AutoFilter, then selecting your column(s) and re-apply AutoFilter. Does it come back? HTH, Elkar "MacSkip" wrote: Until recently, the small Autofilter icon at the head of one or more columns (indicating that the Autofilter function is enabled for that column) was there when expected. This morning, for the first time, I don't see them. When I pull down Data - Filter I see that the Autofilter is indeed checked but there are no icons at the top of any of the columns. I used filtering extensively. What happened? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do my Autofilter icons no longer appear?
When you pull down DataAutofilter, is it grayed out?
ToolsOptionsViewObjects. "Hide all" is checked maybe? Try "Show All" Gord Dibben MS Excel MVP On Mon, 3 Jul 2006 13:44:01 -0700, MacSkip wrote: Until recently, the small Autofilter icon at the head of one or more columns (indicating that the Autofilter function is enabled for that column) was there when expected. This morning, for the first time, I don't see them. When I pull down Data - Filter I see that the Autofilter is indeed checked but there are no icons at the top of any of the columns. I used filtering extensively. What happened? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying an AutoFilter to a string | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
Can I make 2003 use the buttons icons of 2000? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |