Filtering

The UK's most regular instructor-led training courses.
Training information: excel.training.course.london · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Filtering

Matt has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Matt [1 post] (2008 Feb 21 Thu, 17:04) Reply

Is it possible to run an advanced filer on a database that already has a customized filter applied?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Filtering

by - trainer Mara silver contributer [73 posts] (2008 Mar 8 Sat, 18:13) Reply

Hello Matt,
I hope you enjoyed your Excel training sessions with us.

To answer your question, while it is possible to run an advanced filter where a custom filter has been applied, I would recommend that you actually run the advanced filter on the full database with all filters cleared. It is easy enough to clear your custom filters, by going to Data > Filter > Clear All, and then your advanced filter can incorporate the custom filter criteria, if you so choose.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· Excel and Inventory Management
· Training Budgets In A Bad Economy
· Microsoft Excel Courses Teach Advanced Macro Techniques
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Reasons Why VBA for Excel Training Fails

Please browse our web site to find out more about
excel.training.course.london and other Microsoft training courses.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Rate this page: