Filter Option

S

saraskandan

Hi,

If someone could help me with the Auto Filter option.

I have 8000 records in a worksheet. If I choose Auto Filter option and
click drop down button I am able to view only 1000 records and not more
than that. If I need to view all the records. How can I do it and what
is the option?
 
D

Debra Dalgleish

There may be other workarounds, but there's no setting you can change to
increase the 1000 item limit.
 

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

VBA: How can I use a string variable as autofilter criteria? 4
MSExcel auto filtering 1
How to Unfilter a List that has been filtered via Advanced Filter >Unique Records only 1
Filter option not working 3
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Hyperlink shortcut not appearing 1
autofilter problem 1
Filter by criteria in one row - display that row and previous row 3

Top