avanced filters

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Avanced filters

Avanced filters

resolvedResolved · Low Priority · Version 2003

Bridget has attended:
Excel Intermediate course

Avanced filters

can you give a simple explanation of how to use advanced filters? Thank-you

RE: Avanced filters

Hi Bridget

Thank you for your question

The first thing is to make sure that the list that is to be filtered has column headings at the top of each column. this is important as the filter references the column headings.

Next, you need to specify the criteria for your filter. This is done by creating a seperate table, with the column headings naming the column to be fltered and the criteria for the filter underneath it.

For example if you had a list of data comprising name, product, order quantity and price and you wanted all the sales of shirts made by William and Mary, then your criteria range would look something like:-

Name Product
William Shirts
Mary Shirts

Once you have created this, simply click on DATA-FILTER-ADVANCED FILTER and and select the ranges for the data to be filtered and the criteria range. You will also need to specify where the filtered data will go. Then simply click on OK to complete the filter

I have atached a file with another example for your information


Hope this is useful

Regards

Stephen

Attached files...

Advanced Filter Example.xls


 

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips


Server loaded in 0.09 secs.