Excel 2016 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

In the course of creating and editing an Excel 2016 worksheet, you may find that you need to modify the worksheet display many times as you work with the document. Excel's Custom Views feature enables you to save any of these types of changes to the worksheet display.

This way, instead of taking the time to manually set up the worksheet display that you want, you can have Excel re-create it for you simply by selecting the view. When you create a view, Excel can save any of the following settings: the current cell selection, print settings (including different page setups), column widths and row heights (including hidden columns), display settings on the Advanced tab of the Excel Options dialog box, as well as the current position and size of the document window and the window pane arrangement (including frozen panes).

To create a custom view of your worksheet, follow these steps:

  1. Make all the necessary changes to the worksheet display so that the worksheet window appears exactly as you want it to appear each time you select the view. Also select all the print settings on the Page Layout tab that you want used in printing the view.

  2. Click the Custom Views command button in the Workbook Views group at the beginning of the View tab or press Alt+WC.

    This action opens the Custom Views dialog box, similar to the one shown here, where you add the view that you've just set up in the worksheet.

    Adding a new view for the worksheet in the Custom Views dialog box.
    Adding a new view for the worksheet in the Custom Views dialog box.
  3. Click the Add button.

    This action opens the Add View dialog box, where you type a name for your new view.

  4. Enter a unique descriptive name for your view in the Name text box.

    Make sure that the name you give the view reflects all its pertinent settings.

  5. To include print settings and hidden columns and rows in your view, leave the Print Settings and Hidden Rows, Columns and Filter Settings check boxes selected when you click the OK button. If you don't want to include these settings, clear the check mark from either one or both of these check boxes before you click OK.

    When you click OK, Excel closes the Custom Views dialog box. When you next open this dialog box, the name of your new view appears in the Views list box.

  6. Click the Close button to close the Custom Views dialog box.

    Custom views are saved as part of the workbook file. To be able to use them whenever you open the spreadsheet for editing, you need to save the workbook with the new view.

  7. Click the Save button on the Quick Access toolbar or press Ctrl+S to save the new view as part of the workbook file.

After you create your views, you can display the worksheet in that view at any time while working with the spreadsheet. To display a view, follow these steps:

  1. Click the Custom Views command button in the Workbook Views group on the View tab or press Alt+WC.

  2. Double-click the name of the view that you want to use in displaying your worksheet in the Views list box or click the name and then click the Show button.

Always start by defining a Normal 100% view in the Custom Views dialog box that represents the standard view of the worksheet before you go about defining custom views that hide columns, freeze panes, and mess with the worksheet's magnification. This way, you can recover from a special view (especially one that you only use in printing part of the spreadsheet but never use when editing it) simply by double-clicking Normal 100% in the Views list box of the Custom Views dialog box.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

This article can be found in the category: