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 » excel.advanced.course - Auto filters

excel.advanced.course - Auto filters

ResolvedVersion Standard

Tue 15 Jan 2008, 16:24 Delegate Nina said...

Nina has attended:
Excel Introduction course
Excel Intermediate course

Auto filters

How would i use filters on the whole spread sheet using my own criteria?

Wed 16 Jan 2008, 12:27 Edited on Wed 16 Jan 2008, 12:29 Trainer Carlos said...

Filtering Using Criteria

Hi Nina

If you have a list of records it is possible to extract all records that meet a specified set of criteria and place them elsewhere in your worksheet.

For example in a list of customer details you could find all customers who live in

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel.advanced.course - Auto filters

Auto filters

Filtering Using Criteria

Excel articles

Excel tip:

Change Excel's default font