Part I: Getting Started with Excel
- Expand the Properties section of the dialog box.
- Remove the check mark for Print Object.
FIGURE 7.7
Use the Properties tab of the object’s Format dialog box to prevent objects from printing.
For a chart, you must right-click the chart’s chart area (the background of the chart). Or double-click the chart’s bor-
der to display the Format Chart Area dialog box. Then expand the Properties section and remove the check mark from
Print Object.
Creating custom views of your worksheet
If you need to create several different printed reports from the same Excel workbook, set-
ting 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.
