EXCEL 打印時(shí)忽略圖片、圖表等對(duì)象的方法

Technique 2:方法二
1. Right-click the object (Button, Combo Box and more), and select Format Control.(右鍵單擊對(duì)象，選擇設(shè)置**格式[控件,圖片等]
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.
按ctrl+6+6隱藏所有對(duì)象(控件、圖表、自選圖片等),打印之后，再按ctrl+6，取消隱藏.
注:方法二可以就單個(gè)對(duì)象進(jìn)行是否打印的設(shè)置，方法一及方法三只能對(duì)全部對(duì)象進(jìn)行是否打印的控制。