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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
filters

ResolvedVersion Standard

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.

Edited on Thu 6 Mar 2008, 09:38

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 tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

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