Yes, it's a useful one. I have a spreadsheet at home that has many more
names than will show up in the drop-down list, but I have a helper column
using the LEFT() function to give the first letter of the name, which I use
for an initial filter by that column to get the number of names to what
autofilter can handle.
--
David Biddulph

"anromath" wrote in message
...
I don't this this will work for the person whose question I posted -- she
is
a very, very unsophisticated user of Excel. But, I will keep it in mind
for
myself. Thanks for teaching me a new trick!

"David Biddulph" wrote:

The answer I gave below is for if the filter isn't including the rows.

If your problem is that you're not seeing more than 1000 different values
in
the drop-down list, then the answer is different:
http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Switch off the Autofilter.

Select the range of rows and column you want to include in your filter
before switching on the Autofilter again.

"anromath" wrote in message
...
I've never experienced this before...

Spreadsheet has 18 columns and 3400 rows. For some reason, auto
filter
stops at row 1593. I've tried copying and pasting to a new workbook,
turning
filters on and off, using format painter to ensure the formats are all
the
same, and various other random things.

Any ideas on what is wrong, and more importantly, how to fix?