Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
filtering

ResolvedVersion 2000

Sarah has attended:
Excel Introduction course

Filtering

How to order table by date or say country

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.