filters excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filters in Excel

Filters in Excel

resolvedResolved · Low Priority · Version 2003

Diana has attended:
Excel Introduction course

Filters in Excel

How are they used

RE: Filters in Excel

Hi Diana

Thank you for your question.

Filters are used when you are using Excel to store data in a series of columns, with a heading above each column, e.g. sort of like an address book where you would have First name, Last name, Street address, City, Postcode.

The filter allows you to get Excel to display only those items in your list that match certain criteria, e.g. with the address book example, you only want to see a list of people that live in London.

We do cover filtering and other list management tools in the Excel Intermediate course.

Kind regards
Amanda

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips


Server loaded in 0.09 secs.