Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Autofilter

	98.1 % recommend us
	More live stats...

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

Training information:

excel consultants - Autofilter

Resolved · Low Priority · Version Standard

Reply Fri 14 Sep 2007, 14:18Delegate Amanda said...

Amanda has attended:
Excel Intermediate course

Autofilter

How can maky items can i filter in autofilter?

For upcoming training course dates see: Pricing & availability

Reply Mon 1 Oct 2007, 13:58Trainer Amanda said...

RE: Autofilter

Hi Amanda

Thank you for your question.

If you are working in Excel 2003 then you can use the custom filter to filter two items from the same column.

Anything more than two items and you'd have to use an advanced filter.

I hope this helps.
Amanda

Excel articles

· Make A Custom Sort List In Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Making The Most Of Filtering In Excel
· How Excel Can Boost Even The Smallest Business
· Do You Need To Run Excel 2007 In Compatibility Mode?

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy