Can Auto Filter Limits of 1000 unique entries be increased when y.

  • Thread starter Auto Filter Limitations
  • Start date
A

Auto Filter Limitations

When using Auto Filter in Excel, their is a limitation of 1000 entries that
can be viewed at any one time when you clish the arrow to select a record.
Can this 1000 record limit be increased?
 
P

Paul B

See this for a work around

http://www.contextures.com/xlautofilter02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **


"Auto Filter Limitations" <Auto Filter
(e-mail address removed)> wrote in message
news:[email protected]...
 

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

Double Entry Posting 1
Auto Filter problems... 4
Custom Filtering - Limitations of the "Contains" option 7
Autofilter - 1000 Selection Limitation? 1
auto filter on columns 2
Auto Filter Comma Dilemiation 2
Counting same names in excel (Coulums) 1
Spreadsheet - Deleting Duplicate Records - Self Checking 1

Top