filtering

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

Filtering

resolvedResolved · Medium Priority · Version 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


 

Excel tip:

Removing custom dictionary entries

If 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.

View all Excel hints and tips


Server loaded in 0.1 secs.