Create or delete custom views - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Create or delete custom views

Applies to: Microsoft Office Excel 2003

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 (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.), or the entire worksheet if the sheet has no defined print area.

Show 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 (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.).
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.

Note You cannot create a custom view when a worksheet contains an Excel list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.). If one or more worksheets contain an Excel list, the Custom Views command is disabled for the entire workbook.

Show Delete a custom view

On the View menu, click Custom Views.
In the Views box, click the name of the view (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.) you want, and then click Delete.