使Excel选项卡不打印? [英] Making an Excel tab not print?
问题描述
在打印整个工作簿时,Excel中是否有任何方法可以使其不包含特定的选项卡?像Sheet1,Sheet2和Sheet3一样打印,而不是Sheet4。
Is there any way in Excel to make it so that a particular tab isn't included when you print the entire workbook? As in, Sheet1, Sheet2, and Sheet3 print, but not Sheet4.
所以就像有人去File - > Print或其他任何东西,然后点击OK等等打印输出,除了特定的指定标签(我认为我必须隐藏打印不知何故)。
So like when someone goes to File -> Print or whatever, and hit OK, etc, everything prints out except for a particular designated tab (which I assume I have to "hide from printing" somehow).
我将这个锻炼发送给一群人所以我试图避免强迫他们启用/运行宏和所有的东西。是否只有一个表格的属性像排除从打印?
I'm sending this workout out to a bunch of people so I'm trying to avoid forcing them to enable/run macros and all that stuff. Is there just a property of a sheet somewhere like "exclude from print"?
推荐答案
只需在标签页上设置打印区域不想打印到单个空白单元格,这将意味着它将打印单个空白页,而不是我假设您正在尝试避免打印的数据。
Just set the print area on the tab you don't want to print to a single blank Cell, This will mean that it will print a single blank page rather than the reams of data that I presume you are trying to avoid printing.
这篇关于使Excel选项卡不打印?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!