auto filter

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auto Filter

Auto Filter

resolvedResolved · High Priority · Version 2003

Fam has attended:
Excel Intermediate course

Auto Filter

Can you auto filter a row and column the same time?

Edited on Fri 11 Apr 2008, 21:29

RE: Auto Filter

Hi Fam, Thanks for the post, welcome to the forum, in answer to your question, Auto Filter only works on columns, when we set Custom Filters we can use AND and OR to extract from different columns using those criteria, even when we use Advanced Filter we are extracting complex criteria but still only from columns. the reason behind this is that we always set up our databases in the same way, with field headings along the first row, and under each heading (down the column) the data relating to the heading.
Therefore each row becomes a single record.
I hope that answers your question, if so please click the resolved link, best regards Pete.

 

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:

Removing custom dictionary entries

If you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there.

View all Excel hints and tips


Server loaded in 0.08 secs.