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 · Low Priority · Version Standard

Sarah has attended:
Excel Intermediate course

Auto filter

how do I use auto filter?

RE: auto filter

Highlight an entire header row or a particular heading of a column. Go to data, filter and autofilter. This turns it on. You will be able to click on the little arrow and you will see a list of all unique values in the column. If for example you have the value of 'France' in that column several times (say you are looking at a sales data sheet and want to only return the french sales) then choosing france from the filter list would show only records with France value. Its basically a simple way to show groups of records together. If there is a filter on the column, the arrow will turn blue. You can use more than one filter on the data, for example to show all frenhc sales for a particular month.

 

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:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips


Server loaded in 0.08 secs.