使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屋！