Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft-excel-courses - Excel

Resolved · Low Priority · Version Standard

Reply Fri 27 Jul 2007, 09:55Delegate Christine said...

Christine has attended:
Excel Intermediate course

Excel

how to filter a table

For upcoming training course dates see: Pricing & availability

Reply Sat 28 Jul 2007, 06:59Trainer Tracy said...

RE: excel

Hi Christine,

Thank you for your question.

You can filter a table by clicking within the table and using the AutoFilter menu. This can be found under Data > Filter > AutoFilter. This is where you get the drop down options to pick from a selection. There are other filters as well, but this is the easiest and quickest one to use. Have a go see if it works and if you get stuck just get back to me!

Tracy

Excel articles

· How To Convert Text To Columns In Excel
· Sorting Out Your Data In Excel
· How To Use Conditional Formatting In Excel
· Using Dates Within Excel
· Some Simple Yet Less Common Excel Functions

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips