excel电子表格插件
Sometimes you might need to print out data contained in an Excel Spreadsheet, but printing out the entire thing is a waste. Today we show you how to print out only specific areas of the document that you need.
有时您可能需要打印出Excel电子表格中包含的数据,但是打印出整个内容却很浪费。 今天,我们向您展示如何仅打印所需文档的特定区域。
Open the Spreadsheet with the data you need and hold down the Ctrl key while highlighting the area of the document you want to print out.
用所需的数据打开电子表格,并按住Ctrl键,同时突出显示要打印的文档区域。
Click the Page Layout tab on the Ribbon, then the Print Area button and Set Print Area…
单击功能区上的“页面布局”选项卡,然后单击“打印区域”按钮和“设置打印区域...”。
While still under Page Layout click on Print Titles…
仍在页面布局下时,单击打印标题…
The Page Setup screen opens up and you’ll want to select the Sheet tab. From here type in the Columns and Rows that you want to repeat (if any) then click on Print Preview. This allows you to include any headers or labels associated with the data.
“页面设置”屏幕打开,您将要选择“图纸”选项卡。 在此处输入要重复的“列和行” (如果有),然后单击“打印预览”。 这使您可以包括与数据关联的任何标题或标签。
Now you’ll be able to preview the area you’ve selected and can print it out.
现在,您可以预览所选区域并可以将其打印出来。
You can also select multiple areas of the spreadsheet. Just select another area and when you click on Print Area select Add to Print Area.
您还可以选择电子表格的多个区域。 只需选择另一个区域,然后单击“打印区域”,然后选择“添加到打印区域” 。
Then when you go into Print Preview you can page through the different areas you’ve selected.
然后,当您进入“打印预览”时,可以在所选的不同区域中进行分页。
The Print Areas will stay set until you clear them out. Just click on Print Area then select Clear Print Area.
在您清除它们之前,打印区域将保持不变。 只需单击“打印区域”,然后选择“清除打印区域” 。
This also works basically the same in Excel 2010, but when you select Print Preview, Backstage View opens and you can select your printing options from there.
这在Excel 2010中也基本上相同,但是当您选择“打印预览”时,将打开Backstage视图,您可以从那里选择打印选项。
This is a great way to save ink and paper if you only need to print out specific areas of a spreadsheet. Being able to include column headings and row labels is also nice so the data you print out makes more sense.
如果只需要打印出电子表格的特定区域,这是节省墨水和纸张的好方法。 能够包含列标题和行标签也很好,因此您打印出的数据更有意义。
翻译自: https://www.howtogeek.com/howto/10451/print-only-selected-areas-of-a-spreadsheet-in-excel-2007-2010/
excel电子表格插件