Page 215 - Excel 2007 Bible

14_044039 ch10.qxp 11/21/06 11:03 AM Page 172
Part I
Getting Started with Excel
Unfortunately, the Custom View feature does not work if the workbook contains at least one
CAUTION
CAUTION
table. When a workbook that contains a table is active, the Custom View command is grayed
out. This limitation severely limits the usefulness of the Custom View feature.
To create a named view, begin by setting up the view settings the way you want them (for example, hide
some columns). Then choose View ➪ Workbook Views ➪ Custom Views to display the Custom Views dia-
log box. Click the Add button and provide a descriptive name in the Add View dialog box that appears (see
Figure 10.10). You can also specify what to include in the view by using the two check boxes. For example,
if you don’t want the view to include print settings, remove the check mark from Print Settings. Click OK to
save the named view.
FIGURE 10.10
Use the Add View dialog box to create a named view.
The Custom Views dialog box displays a list of all named views. To select a particular view, just select it
from the list and click the Show button. To delete a named view from the list, click the Delete button.

172