filtering

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filtering

Filtering

resolvedResolved · Low Priority · Version 2007

Retha has attended:
PowerPoint Introduction course
Excel Introduction course

Filtering

How to filter

RE: Filtering

Hi Retha, thanks for your query. The simplest way to filter your data is to switch on the autofilter. This is located on the Data tab and is the big filter icon in the middle. If you click on that you'll get drop down arrows appearing on the headings of your data and from there you can filter your data as much as you like!

Hope this helps,

Anthony

Thu 23 Dec 2010: Automatically marked as resolved.

 

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:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.09 secs.