ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Views (https://www.excelbanter.com/excel-discussion-misc-queries/260935-custom-views.html)

parls

Custom Views
 
I see from other posts that there is no way to copy a custom view from one
worksheet to another (aside from using "save as" as a work around). My next
question then is there any way to disply what settings are inherent in a
custom view so that I can re-create it in another sheet?

Thanks,
Parls

Gord Dibben

Custom Views
 
What types of Custom Views?

If you have a view of a filtered worksheet would that filter necessarily be
valid for the next sheet?

If some columns or rows were hidden would you want the same view for the
next sheet?

You could just make a copy of the sheet and Custom Views go with it.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:07:01 -0700, parls
wrote:

I see from other posts that there is no way to copy a custom view from one
worksheet to another (aside from using "save as" as a work around). My next
question then is there any way to disply what settings are inherent in a
custom view so that I can re-create it in another sheet?

Thanks,
Parls




All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com