EXCEL 打印时忽略图片、图表等对象的方法
中国教程网zhangditony翻译，转载请保留此信息 .
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 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.
![20070721_52679cb75102776c6fa7dfd7byzrqltc[1].jpg](https://atts.w3cschool.cn/attachments/image/20151103/1446548805478896.jpg "1446548805478896.jpg")
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.
![20070721_2d9df17911aa82804f7aa4oxbknsojaz[1].jpg](https://atts.w3cschool.cn/attachments/image/20151103/1446548842410820.jpg "1446548842410820.jpg")
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.
按ctrl+6+6隐藏所有对象(控件、图表、自选图片等),打印之后，再按ctrl+6，取消隐藏.
注:方法二可以就单个对象进行是否打印的设置，方法一及方法三只能对全部对象进行是否打印的控制。