98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Filtering
excel training microsoft - Filtering
Resolved · Low Priority · Version Standard
Bowen has attended:
Excel Advanced course
Filtering
Is their a maximum number of rows that Excel will accept for a filter? I have less than 1200 rows and yet the Filter will not display in the drop down any more than about 1150. I have tried turning the filter off and then on again to no avail. Suggestions welcomed.
RE: Filtering
Hi Bowen,
Thanks for the question.
In answer to your question there is a limit of 1000 unique entries when using the AutoFilter. Your AutoFilter will function correctly if you have more that 1000 unique entries in your data list column, but you'll have to use a Custom selection or use an Advanced Filter with a criteria setting.
Tracy
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Value of a ConstantWhen using a named constant in a worksheet, you may wish to change the value of that constant. |