Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering
Resolved · Medium Priority · Version 2000
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
|
Excel tip:Removing custom dictionary entriesIf you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there. |
We'll call during UK business hours
Server loaded in 0.1 secs.