Page 223 - Excel 2013 All-in-One For Dummies

A Spreadsheet with a View 205
Figure 3-12:
Adding a new view for the worksheet in the Custom Views dialog box.
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.
Book II Chapter 3
Editing and Proofing Worksheets