Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filters

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Filters

Resolved · Low Priority · Version Standard

Reply Tue 4 Mar 2008, 21:24Delegate Jeremy said...

Jeremy has attended:
Excel Intermediate course

Filters

How can I apply filters to sheets that apply to multipul pages. For example I can apply filters in the data range but it only seem to apply to the page selected and not the rest of the sheet.

For upcoming training course dates see: Pricing & availability

Reply Thu 6 Mar 2008, 09:36 Edited on Thu 6 Mar 2008, 09:38Trainer Mark said...

RE: Filters

Hi Jeremy

Hope you enjoyed the course on Tuesday, the answer to your question is a simply one but not the one you were hoping for you can not apply filters to the multi sheets at the same time, but you can apply filter to seperate sheet at anytime but the difference is that this type of filter one sheet at a time will only apply to the sheet you are on

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel articles

· Excel: Save Time With AutoFill
· Getting To Grips With Gantt In Excel
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Create Buttons To Navigate Between Worksheets
· Advanced level training: Microsoft Excel and the Web

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

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips