Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filters
Resolved · Low Priority · Version Standard
Jeremy has attended:
Excel Intermediate course
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.
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:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |
We'll call during UK business hours
Server loaded in 0.09 secs.