excel设置打印区域_快速提示：从Excel 2007仅打印所选区域

excel设置打印区域

How many times have you wanted to only print out a portion of the data on an Excel spreadsheet?  About a year ago I shared a tip to save ink and paper by only printing selected text from a webpage.  Instead of analyzing the spreadsheet, printing it out and reanalyzing it to find the pertinent data here I will show you how to print out the specific area.

您只想在Excel电子表格中打印出一部分数据有多少次？ 大约一年前，我分享了一个技巧，通过仅打印网页中的选定文字来节省墨水和纸张。 在这里，我将向您展示如何打印出特定区域，而不是分析电子表格，然后将其打印并重新分析以找到相关数据。

With the spreadsheet open highlight the rows and / or columns you want to print out.

打开电子表格后，突出显示要打印的行和/或列。

Next, click on the Print Layout Tab on the Ribbon.  In the Page Setup section click Print Area and then Set Print Area.  This will show a perforated outline around the selected rows and columns.

接下来，单击功能区上的“打印布局”选项卡。 在“页面设置”部分中，单击“打印区域”，然后单击“设置打印区域”。 这将在选定的行和列周围显示一个穿Kong的轮廓。

Now just hit the Quick Print or go to the Office Button and Print.  Now only the selected area will be printed out!  Simple but effective tip!  Also, this can save printer ink and paper which is always good for Green Computing.

现在，只需单击“快速打印”或转到“ Office按钮并打印”即可。 现在只打印选定的区域！ 简单但有效的提示！ 此外，这可以节省打印机的墨水和纸张，这对于绿色计算总是很有帮助的 。

翻译自: https://www.howtogeek.com/80024/quick-tip-print-only-selected-area-from-excel-2007/

excel设置打印区域