98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Custom views
Custom views
Resolved · High Priority · Version 2003
Tue 8 Jul 2008, 11:14Delegate Liz said...
Liz has attended:
SharePoint course
Custom views
We have a template with custom views.
We want to create other similar worksheets within the same workbook, and we'd like the custom views to apply the same filters, etc. but in the new worksheet.
We find that by using copy sheet, applying the custom view displays the original worksheet. Is there a solution please?
Thu 10 Jul 2008, 08:09
Edited on Thu 10 Jul 2008, 08:10Trainer Pete said...
RE: custom views
Hi Liz,
Thank you for your post: To my knowledge Custom Views is only available on the worksheet on which it was created, therefore any custom views that are invoked on another worksheet even though a copy will always point to and open on the original worksheet. (As you have discovered).
Sadly there is no workround available. You will have to re-create the custom views for each new worksheet. Pete
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |
