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.

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.

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.