Autofilter

  • Thread starter Thread starter Abid Ali
  • Start date Start date
A

Abid Ali

Hi Pals,
I have a huge spread sheet. Since some days am facing a
problem.
There are more than 1000 rows in the sheet that i have
been using. When i apply auto filter it only shows first
1000 rows and not all....

Is there any problem with my software or a limitaion of
excel?????/

Pl. help me out.

Thanx,


Abid
 
An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the drop-down list, and type the criteria, as
you're currently doing. Also, there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html
 
Back
Top