spreadsheets

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

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

Spreadsheets

resolvedResolved · Low Priority · Version 2003

MARGARET has attended:
Excel Intermediate course

Spreadsheets

how do I filter my lists

RE: spreadsheets

Hi Margaret

Thank you for your question. The fastest way to do this is to click within your table of data then from the Data menu choose filter > autofilter.

From the drop down triangles that appear at the top of each column you can select criteria to filter your list.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

 

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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.09 secs.