| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data in rows not showing in auto-filter drop down
Work sheet is only about 150 rows. Rows that appear in auto-filter are random.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data in rows not showing in auto-filter drop down
Sometimes blanks and other "junk" will cause the autofilter to fail.
Don't just click on the header cell when you set the autofilter, select the entire table. -- Gary''s Student - gsnu200909 "Denise" wrote: Work sheet is only about 150 rows. Rows that appear in auto-filter are random. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data in rows not showing in auto-filter drop down
Only unique data will appear in the AF dropdown.
Data will appear in ascending order either numerically or alphabetically. Numerics will show at top of mixed list of data. Blanks will not show in the dropdown. What do you see and why do you say "random"? Gord Dibben MS Excel MVP On Mon, 23 Nov 2009 11:41:03 -0800, Denise wrote: Work sheet is only about 150 rows. Rows that appear in auto-filter are random. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort/filter with drop down, all data showing | Excel Discussion (Misc queries) | |||
| Auto Filter not showing all data | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Why don't all my data rows show up in auto-filter? | Excel Worksheet Functions | |||
| Why do I not see all my data when I use the auto filter drop down | Excel Discussion (Misc queries) | |||
Hybrid Mode
