NO values in Auto-filter drop-down

G

Guest

I have a column with 721 values. I placed Auto-filter in the row just above
the data. There are no blank rows among my rows of data. However, the
drop-down shows NO values.

The workbook is not shared or protected.

what do you recommend?

thanks in advance!! Jane
 
D

Dave Peterson

If you remove the data|filter|autofilter, then select the entire range to be
filtered and reapply the data|Filter|autofilter, does it work ok?

I never let excel guess at the range to filter, sort, chart, ...

It doesn't always guess what I want.
 
P

Peo Sjoblom

Remove the filter, put a header on top, then select all 722 rows header
included and then apply the filter. Still the same?
 
G

Guest

HI Dave and Peo,
Your suggestion worked.

The weird thing is that I have always applied auto-filter in that manner I
did and have never had a problem.

Oh well, perhaps, on of those days.

thanks so much for the help! :) jane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto filter for multiple columns 2
Auto-filter selection 1
Filtered drop down list 2
Auto filter drop down box 1
Auto-filter not grabbing all the data 2
Filter (blanks) with two or more unique values not working 1
Auto Filter skips first row 3
Auto Filter in EXCEL 2007 4

Top