problem with filter

P

Pascale

Hello
I work with Excel 2003 and when I use the filter to scroll down my list of
names, I can only see up to the names starting with M when my spreadsheet
goes up to Z (of course).
Any suggestion please?
Many thanks
 
P

Pascale

Sorry Roger, it's not exactly what I mean. Imagine you have 3 columns for 1st
name, surname and address. you select these column headings and go to Data,
filter and auto.

Appears next to each heading a little arrow pointing downward. when you
click on the one next to "Surname", you see all the surnames sorted
alphabetically. Without applying the filter but just scrolling down that list
I can only see up to M rather than Z. Why is that and what can be done about
it please?
Thanks
 
R

Roger Govier

Hi Pascale

I apologise for the mistake in my previous post, I meant to type 1000
not 100.
The same applies to the dropdown.
If there are more than 1000 different names between A and M, then you
will only see through to M

Enter Number in cell A1 of a blank sheet.
In A2 enter =ROW()
drag A2 down through A3:A1100
Apply an Autofilter to A1, and use the dropdown
How many do you see the list go up to?
 
G

Gord Dibben

Roger meant 1000 rows in the dropdown box, not 100.

Go to the site he pointed you to and re-read the information.


Gord Dibben MS Excel MVP
 
Top