View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default problem with filter

Hi Pascale

Autofilter has a limit of 100 rows for display when a filter is applied.
For a workaround take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Limits
--
Regards

Roger Govier


"Pascale" wrote in message
...
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