Microsoft Office Tutorials and References
In Depth Information
Preventing Objects from Printing
Preventing Objects from Printing
You can place a wide variety of objects on a worksheet — charts, shapes, pictures, SmartArt, and
controls (such as check boxes), for example. By default, all these objects are printed when you
print the worksheet.
You can, of course, specify that a particular object doesn’t print. However, the procedure varies
with the type of object.
The following list describes how to keep a particular object from printing. In all cases, start by
clicking the object to select it.
h Chart: Select the Chart Area (the background), right-click, and choose Format Chart
Area. In the Format Chart Area dialog box, click the Properties tab and deselect the Print
Object check box.
h SmartArt: Right-click the background of the SmartArt object and choose Format Object.
In the Format Shape dialog box, click the Properties tab and deselect the Print Object
check box.
h WordArt: Right-click the object and choose Format Shape. In the Format Shape dialog
box, click the Properties tab and deselect the Print Object check box.
h Shape, Textbox, Picture, or Clipart: Right-click the object and choose Size and
Properties (or Format Shape) from the shortcut menu. In the Format Shape dialog box,
click the Properties tab and deselect the Print Object check box.
h Form control: (You insert it by choosing Developer
Form Controls.)
Right-click the control and choose Format Control from the shortcut menu. In the Format
Control dialog box, click the Properties tab and deselect the Print Object check box.
Controls
Insert
h ActiveX control: (You insert it by choosing Developer
Controls
Insert
ActiveX
Controls.) Make sure that Excel is in Design mode. (Click the Developer
Controls
Design Mode button.) Right-click the control and choose Format Control from the
shortcut menu. In the Format Control dialog box, click the Properties tab and deselect the
Print Object check box.
 
Search JabSto ::




Custom Search