Home » Microsoft Excel 2003 » 08 - Viewing Workbooks and Worksheets
8
Creating Custom Views
You can save a set of display and print settings as a custom view, then apply your custom view at any time. For example, you have a worksheet that contains data about four different sales regions. You can set up a view of each region's data and then save
What Can Be Stored in Custom Views? The stored settings include display options, window size, position on the screen, window splits, frozen panes, the active sheet, and the cells that are selected at the time the view is created. You also have the option to save hidden rows, hidden columns, filter settings, and print settings.
The custom view includes the entire workbook. If you hide a sheet before a view is added, Excel hides the sheet when you show the view.
