Excel 2010 Bible

Chapter 9: Printing Your Work

189

If you find that you must regularly hide data before you print certain reports, consider using the

Custom Views feature, discussed later in this chapter (see “Creating Custom Views of Your

Worksheet”). This feature allows you to create a named view that doesn’t show the confidential

information.

Preventing Objects from Being Printed ..............................................................................

To prevent objects on the worksheet (such as charts, Shapes, and SmartArt) from being printed,

you need to access the Properties tab of the object’s Format dialog box (see Figure 9.7):

1. Right-click the object and choose Format xxxx from the shortcut menu. (xxxx varies,
   depending on the object.)


2. In the Format dialog box that opens for the object, click the Properties tab.


3. Remove the check mark for Print Object.

Note
For a chart, you must right-click the chart’s Chart Area (the background of the chart). Or, double-click the
chart’s border to display the Format Chart Area dialog box. Then click the Properties tab and remove the check
mark from Print Object. n

FIGURE 9.7

Use the Properties tab of the object’s Format dialog box to prevent objects from printing.