谷歌虚拟打印位置在哪_如何在Google表格中打印特定的单元格选择

谷歌虚拟打印位置在哪

By default, when you print in Google Sheets, all data in the spreadsheet is used. Should you only want to print a specific set of cells, there’s a simple method to specify selected cells. Here’s how.

默认情况下，当您在Google表格中打印时，会使用电子表格中的所有数据。 如果您只想打印一组特定的单元格，则有一种简单的方法可以指定选定的单元格。 这是如何做。

Fire up the Google Sheets home page in a browser and open an existing spreadsheet you want to print some data from within.

在浏览器中启动Google表格首页 ，然后打开要从中打印一些数据的现有电子表格。

Next, highlight the cells you want to print. You can click and drag cells or hold the Shift key while you click on the range of cells.

接下来，突出显示要打印的单元格。 您可以单击并拖动单元格，或者在单击单元格范围时按住Shift键。

After you select the range of cells, click the printer icon in the toolbar to access Sheets’ printer settings.

选择单元格范围后，单击工具栏中的打印机图标以访问Sheets的打印机设置。

Alternatively, you can use the keyboard shortcut Ctrl+P (Windows/Chrome OS) or Cmd+P (macOS) to get there instead.

或者，您可以使用键盘快捷键 Ctrl + P(Windows / Chrome OS)或Cmd + P(macOS)到达那里。

As mentioned before, the default option is to print everything on the current sheet, but we want to print only our specific cell selection. To do that, click the drop-down list and choose “Selected Cells” from the choices.

如前所述，默认选项是在当前工作表上打印所有内容，但我们只希望打印特定的单元格选择。 为此，请单击下拉列表，然后从选项中选择“选定的单元格”。

The preview will now show you only the selection of cells you made and nothing else.

现在，预览将仅显示您选择的单元格，而没有其他显示。

Depending on how many cells you chose and the width of the selection, you might want to orient the page to landscape to fit it all on one page. Click on “Landscape” under the “Page Orientation” section to flip the page on its side.

根据您选择的单元格数量和选择的宽度，您可能需要将页面调整为横向以使其适合一页。 单击“页面方向”部分下的“横向”以翻转页面。

Otherwise, if you need the page orientation in Portrait, click the drop-down menu in the “Margins” section and click either “Narrow” or “Custom Numbers” to choose a predetermined margin or set your own custom size.

否则，如果您需要纵向模式下的页面方向，请单击“边距”部分中的下拉菜单，然后单击“窄”或“自定义编号”以选择预定的边距或设置自己的自定义尺寸。

Now all the cells fit comfortably on one page. After you configure the page setup, click “Next” to proceed.

现在，所有单元格都可以舒适地放在一页上。 配置页面设置后，单击“下一步”继续。

In the next window, click “Print” to complete the job and send it along to your printer.

在下一个窗口中，单击“打印”以完成作业并将其发送到打印机。

That’s it. Your printer will now shoot out the page with only the specific selection of cells that you wanted to print.

而已。 现在，您的打印机将只显示要打印的特定单元格，从而将页面射出。

翻译自: https://www.howtogeek.com/473174/how-to-print-a-specific-selection-of-cells-in-google-sheets/

谷歌虚拟打印位置在哪