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

excel consultants - autofilter

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

excel consultants - Autofilter

ResolvedVersion Standard

Amanda has attended:
Excel Intermediate course

Autofilter

How can maky items can i filter in autofilter?

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 tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.