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

204 A Spreadsheet with a View
Freeze Panes in the worksheet display have a parallel feature when printing a spreadsheet called Print Titles. When you use Print Titles in a report, the columns and rows that you define as the titles are printed at the top and
to the left of all data on each page of the report. (See Book II, Chapter 5 for details.)
Saving custom views
In the course of creating and editing a worksheet, you may find that you need to modify the worksheet display many times as you work with the document. For example, you may find at some point that you need to reduce the magnification of the worksheet display to 75% magnification. At another point, you may need to return to 100% magnification and hide different col- umns in the worksheet. At some later point, you may have to redisplay the hidden columns and then freeze panes in the worksheet.
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 doc- ument 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. (See Book II, Chapter 5 for details.)
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 in Figure 3-12, where you add the view that you’ve just set up in the worksheet.
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.