excel filter

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 » Excel Filter

Excel Filter

resolvedResolved · Low Priority · Version 2003

Margaret has attended:
Excel Introduction course

Excel Filter

What is auto-filter?

RE: Excel Filter

Hi Margaret,

Thank you for your question.

If you have an excel list holding information on employees in your company, you can use autofilter to filter all the people who live in a particular county or who work in a particular department. It will only display the information you are asking for and hides the rest.

I hope this answers your question.

Regards

Simon


 

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.09 secs.