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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Filtering

ResolvedVersion 2003

Wed 3 Dec 2008, 16:15 Delegate Kirsty said...

Kirsty has attended:
Excel Introduction course

Filtering

How do you add a filter to a column?

Thu 4 Dec 2008, 13:02 Trainer Amanda said...

RE: filtering

Hello Kirsty

Thank you for your question and welcome to the forum.

The most simple way to be able to filter a column is using AutoFilter.

To show an AutoFilter dropdown next to a column, select a cell within the column which has some data in it; then go to Data - Filter and choose AutoFilter.

Filtering is covered as part of our Excel Intermediate course.

Kind regards
Amanda

Wed 10 Dec 2008: Automatically marked as resolved.

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Filtering

Filtering

RE: filtering

Excel articles

Excel tip:

Creating charts in Excel 2010