Bug Article

Subject:
Custom Views Description
Name:
HT
Date:
Thursday, March 10, 2005
Email (spam proof):

Email the originator of this post
Product:
Workbook Rebuilder
Bug:

Custom Views are an Excel user defined feature. When you create a Custom View, all current page layouts and print settings are saved.

They save settings like hidden rows/columns, frozen panes, scroll positions, print settings.

To access Custom Views look under View->Custom Views...

Here is the blurb from the MS Help file:

Create or delete custom views
Before you create a view set up the workbook to appear the way you want to view and print it. If you include print settings in a view, the view includes the defined print area, or the entire worksheet if the sheet has no defined print area.

Create a custom view

Change the settings that you want to save in the view. 
On the View menu, click Custom Views. 
Click Add. 
In the Name box, type a name for the view. 
Make sure to include the active sheet name in the name of a view to make it easier to identify. When you display a view, Microsoft Excel switches to the sheet that was active when you created the view. Excel lists all views in the workbook in the Custom Views dialog box.

Under Include in view, select the options you want. 
Delete a custom view

On the View menu, click Custom Views. 
In the Views box, click the name of the view you want, and then click Delete.