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

filtering

ResolvedVersion 2003

Sandy has attended:
Excel Introduction course
Word Introduction course
PowerPoint Introduction course
Excel Intermediate course

Filtering

How do I filter unwanted data from my list

RE: Filtering

Hi Sandy,

Thank you for your question.

If you need to extract data from a list for a particular purpose, you can use Autofilter.

Go to Data and then Filter and Autofilter and filter buttons will appear by each column heading. Using the filter buttons select the criteria required. Use the Custom option if you are looking for multiple results.

I hope this answers your question.

Regards

Simon

Tue 14 Apr 2009: Automatically marked as resolved.

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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.33 secs.