Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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. |
Filtering
Resolved · Medium Priority · Version 2000
Reply Mon 10 Jan 2011, 16:10Delegate Sarah said...
For upcoming training course dates see: Pricing & availability
RE: filtering
Hi Sarah,
Thank you for your question.
If you click in any cell underneath the main row of headings and go to Data - Filter and then Autofilter.
Each heading will now have a filter button. Click on the filter button for the appropriate field and select the option you want.
E.g. If you have a heading called County, when you click on the filter button it will display the values in the list. Choose the value from the list and it will filter all the records relating to that choice.
I hope that answers your question.
Regards
Simon
|