Excel 2019 Bible

Chapter 7: Printing Your Work

7

The Custom Views feature enables you to give names to various views of your work-

sheet. You can quickly switch among these named views. A view includes settings for the

following:

■ Print settings, as specified in the Page Layout ➪ Page Setup, Page Layout ➪ Scale

to Fit, and Page ➪ Page Setup ➪ Sheet Options groups

■ Hidden rows and columns

■ (^) The worksheet view (Normal, Page Layout, Page Break preview)
■ Selected cells and ranges
■ (^) The active cell
■ The zoom factor
■ (^) Window sizes and positions
■ Frozen panes
If you find that you’re constantly fiddling with these settings before printing and then
changing them back, using named views can save you some work.
Unfortunately, the Custom Views feature doesn’t work if the workbook (not just the worksheet) contains at least one
table, created using Insert ➪ Tables ➪ Table. When a workbook that contains a table is active, the Custom View
command is disabled. This severely limits the usefulness of the Custom Views feature.
To create a named view, follow these steps:

1. Set up the view settings the way you want them. For example, hide some
   columns.


2. Choose View ➪ Workbook Views ➪ Custom Views. The Custom Views dialog box
   appears.


3. Click the Add button. The Add View dialog box (shown in Figure 7.8) appears.

FIGURE 7.8

Use the Add View dialog box to create a named view.