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

filters

ResolvedVersion 2003

Karen has attended:
Excel Intermediate course

Filters

what is an advanced filter?

RE: filters

Hi Karen

Thank you for your question

An advanced filter is a simple technique that allows you to filter a list by multiple criteria.

You start by creating a criteria area in your spreadsheet that contains the column headings of the fields on which you wish to filter, and the criteria underneath the field headings.

You then click inside the list to be filtered and select data-Filter-advanced filter to run the adanced filter wizard

Hope this helps

Regards

Stephen

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

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