Create, apply, or delete a custom view

You can use a custom 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.) to save specific display settings (such as column widths, row heights, hidden rows and columns, cell selections, filter settings, and window settings) and print settings (such as page settings, margins, headers and footers, and sheet settings) for a worksheet so that you can quickly apply these settings to that worksheet when needed. You can also include a specific 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.) in a custom view.

You can create multiple custom views per worksheet, but you can only apply a custom view to the worksheet that was active when you created the custom view. If you no longer need a custom view, you can delete it.

What do you want to do?


Create a custom view

  1. On a worksheet, change the display and print settings that you want to save in a custom view.
  2. On the View tab, in the Workbook Views group, click Custom Views.

Excel Ribbon, View tab, Workbook Views group

  1. Click Add.
  2. In the Name box, type a name for the view.

 Tip   To make a view easier to identify, you can include the name of the active worksheet in the name of a view.

  1. Under Include in view, select the check boxes of the settings that you want to include.

 Notes 

  • All the views that you add to the workbook appear under Views in the Custom Views dialog box. When you select a view in the list, and then click Show, the worksheet that was active when you created the view will be displayed.
  • If any worksheet in the workbook contains an Excel table, the Custom Views command will not be available anywhere in the workbook.

Top of Page Top of Page

Apply a custom view

  1. On the View tab, in the Workbook Views group, click Custom Views.

Excel Ribbon, View tab, Workbook Views group

  1. In the Views box, click the name of the view that you want to apply, and then click Show.

 Note   The worksheet that was active when you created the custom view is automatically displayed.

Top of Page Top of Page

Delete a custom view

  1. On the View tab, in the Workbook Views group, click Custom Views.

Excel Ribbon, View tab, Workbook Views group

  1. In the Views box, click the name of the view that you want to delete, and then click Delete.

Top of Page Top of Page

 
 
Applies to:
Excel 2010