You are here KNOWLEDGE Excel Tips Excel General Preventing the Printing of Objects

Query, Share and Manage Excel workbooks on LAN, Internet

Preventing the Printing of Objects

To prevent objects from being printed:

Technique 1:

1. From the File menu, select Page Setup.
2. Select the Sheet tab.
3. In Print, select the Draft quality checkbox, and then click OK.

Technique 2:

1. Right-click the object (Button, Combo Box and more), and select Format Control.
2. Select the Properties tab.
3. Deselect the Print object checkbox, and then click OK.

Technique 3:

Objects make printing slower, so you may want to temporarily hide them before printing.
1. Press Ctrl+6+6 to hide objects in the sheets.
2. After printing, press Ctrl+6 to unhide the objects in the sheet.
Screenshot // Preventing the Printing of Objects
Preventing the Printing of Objects