Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter trouble
I am trying to apply Autofilter to the headers in a table that has
already been created. But in the dropdown list there are only : All, Top Ten, and Custom. Any clue as to why none of the items in the table or blanks, non-blanks are not appearing in the dropdown?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter trouble
It sounds like you only selected the column headings and none of the data
below them. Try selecting the entire data range (including the headings) Or just one cell within the range (to let Excel figure out where it begins and ends.) Then engage the AutoFilter Does that help? *********** Regards, Ron XL2002, WinXP "Matt" wrote: I am trying to apply Autofilter to the headers in a table that has already been created. But in the dropdown list there are only : All, Top Ten, and Custom. Any clue as to why none of the items in the table or blanks, non-blanks are not appearing in the dropdown?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter trouble
Sounds like you have an empty row after your headings, try selecting the
entire data area. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Matt" wrote: I am trying to apply Autofilter to the headers in a table that has already been created. But in the dropdown list there are only : All, Top Ten, and Custom. Any clue as to why none of the items in the table or blanks, non-blanks are not appearing in the dropdown?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofilter trouble
That did the trick! Thanks!
John Bundy wrote: Sounds like you have an empty row after your headings, try selecting the entire data area. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Matt" wrote: I am trying to apply Autofilter to the headers in a table that has already been created. But in the dropdown list there are only : All, Top Ten, and Custom. Any clue as to why none of the items in the table or blanks, non-blanks are not appearing in the dropdown?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Images and Autofilter | Excel Discussion (Misc queries) | |||
Applying an AutoFilter to a string | Excel Discussion (Misc queries) | |||
Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |