Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Filtering
|
|
|
The UK's most regular 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 training microsoft - Filtering
Resolved · Low Priority · Version Standard
Reply Thu 9 Aug 2007, 12:25Delegate Bowen said...
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.
For upcoming training course dates see: Pricing & availability
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
Reply Thu 9 Aug 2007, 13:06Delegate Bowen said...
RE: Filtering
Thanks Tracy. I'll have to study up on Advanced Filtering and Custom selections.
|