Page 214 - Excel 2007 Bible

14_044039 ch10.qxp 11/21/06 11:03 AM Page 171
Printing Your Work
FIGURE 10.9
Use the Size And Properties dialog box to prevent objects from printing.
Creating Custom Views of Your Worksheet 10
If you need to create several different printed reports from the same Excel workbook, setting up the specific
settings for each report can be a tedious job.
For example, you may need to print a full report in landscape mode for your boss. Another department may
require a simplified report using the same data, but with some hidden columns in portrait mode. You can
simplify the process by creating custom named views of your worksheets that include the proper settings
for each report.
The Custom View feature enables you to give names to various views of your worksheet, and you can
quickly switch among these named views. A view includes settings for the following:

n Print settings, as specified in the Page Layout ➪ Page Setup, Page Layout ➪ Scale To Fit, and
Page ➪ Page Setup ➪ Sheet Options groups.
n Hidden rows and columns
n The worksheet view (Normal, Page Layout View, Page Break Preview)
n Selected cells and ranges
n The active cell
n The zoom factor
n Window sizes and positions
n Frozen panes
If you find that you’re constantly fiddling with these settings and then changing them back, using named
views can save you lots of effort.

171