Google 表格(Google Sheets)可以轻松地将自定义区域设置为工作簿中的打印区域(print area in your workbooks)。您可以选择要打印的单个或多个单元格、工作表甚至整个工作簿。
为此,您必须首先了解如何在Google 表格(Google Sheets)中设置打印区域。
将打印区域设置为仅打印选定单元格(Set the Print Area to Only Print Select Cells)
如果您的数据仅在工作表的特定单元格中(specific cells in your worksheet),您可以配置一个选项,以便Google 表格(Google Sheets)仅打印这些选定的单元格。
- 在您的计算机上启动网络浏览器,访问Google 表格(Google Sheets),然后打开您要打印的工作簿。
- 选择要在工作簿中打印的单元格。
- 从 Google 表格的菜单栏中选择文件(File)>打印。(Print)或者,按Ctrl + P (Windows) 或Command + P (Mac)。
- 从右侧的打印(Print)下拉菜单中选择选定的单元格。(Selected cells)这可确保仅打印选定的单元格。
- 选择屏幕顶部的下一步。(Next)
- 按照标准打印流程打印您的单元格。
设置打印区域以打印整张纸(Set the Print Area to Print the Entire Sheet)
如果您的工作簿有多个工作表(workbook has multiple worksheets),并且您想打印一个特定的工作表,您可以使用Google 表格(Google Sheets)来执行此操作。
- 在网络浏览器中使用Google 表格(Google Sheets)打开您的工作簿。
- 在工作簿底部选择要打印的工作表。
- 从 Google 表格的菜单栏中选择文件(File)>打印。(Print)
- 从右侧的打印(Print)下拉菜单中选择当前工作表。(Current sheet)您将在左侧看到当前工作表的预览。
- 选择顶部的下一步,然后按照标准打印向导打印您的工作表。(Next)
设置打印区域以打印整个工作簿(Set the Print Area to Print the Entire Workbook)
有时,您可能想要打印整个Google 表格(Google Sheets)工作簿,其中可能包含多个工作表。谷歌表格(Google Sheets)也可以选择这样做。
当您打印整个工作簿时,请确保您的打印机有足够的墨水来打印您的数据(ink to print your data)。此外,将足够的纸张送入打印机的纸盒,以确保打印工作簿时不会中断。(interruption when you print)
- 在网络浏览器中使用Google 表格(Google Sheets)访问您的工作簿。
- 从 Google 表格的菜单栏中选择文件(File)>打印。(Print)
- 从右侧的打印(Print)下拉菜单中选择工作簿。(Workbook)
- 从选择(Selection)下拉菜单中选择所有工作表。(All sheets)
- 您将在左侧看到整个工作簿的预览。如果这对您来说不错,请选择右上角的下一步。(Next)
- 然后,您将选择您的打印机、选择纸张尺寸和其他选项以最终打印您的工作簿。
将打印区域设置为在每页上打印页眉(Set the Print Area to Print Headers on Each Page)
如果您的Google 表格(Google Sheets)数据分布在多个页面上,您可能希望在打印的每个页面上都包含标题。这使得读取数据更容易,因为您确切地知道每一页上的数据是哪一列。
要在每一页上打印列标题,您首先要冻结标题行(freeze the header row):
- 打开您的工作簿并访问您要打印的工作表。
- 从 Google 表格的菜单栏中选择查看(View)>冻结(Freeze)> 1 行(1 row)以冻结工作表中的第一行。
- 选择文件(File)>打印(Print)以配置工作表的打印选项。
- 选择页眉和页脚(Headers & footers)并在右侧启用重复冻结行。(Repeat frozen rows)
- (Customize)如果您愿意,可以自定义任何其他选项。然后,选择右上角的下一步。(Next)
使用自定义分页符自定义打印区域(Customize the Print Area With Custom Page Breaks)
您可以将自定义分页符添加到您的Google 表格(Google Sheets)工作表中,让您的打印机知道在哪里停止打印页面(stop printing a page)并开始新页面。
要在工作表中添加分页符:
- 从 Google 表格的菜单栏中选择文件(File)>打印。(Print)
- 在右侧边栏中选择设置自定义分页符。(Set Custom Page Breaks)
- 拖动(Drag)工作表中的蓝色虚线以指定分页符。然后,选择右上角的确认休息。(Confirm Breaks)
- 如果您对指定的分页符不满意,请选择顶部的“重置”以重置分页符。(Reset)
- 选择右上角的下一步以继续使用自定义分页符打印工作表。(Next)
在 Google 表格中自定义和设置打印区域很容易(It’s Easy to Customize and Set the Print Area in Google Sheets)
Google 表格(Google Sheets)让您可以灵活地打印工作簿的任何部分。这样,您可以专注于要打印的主要数据,而忽略其他所有数据。我们希望本指南对您有所帮助。
How to Set the Print Area in Google Sheets
Gоogle Sheets makes it еasy to set a custоm area as thе print area in your workbooks. You can select single or multiple cells, a worksheet, or even an entire workbook to be printed.
To do that, you’ll have to first learn how to set the print area in Google Sheets.
Set the Print Area to Only Print Select Cells
If you have your data only in specific cells in your worksheet, you can configure an option so that Google Sheets only prints those select cells.
- Launch a web browser on your computer, access Google Sheets, and open the workbook you’d like to print.
- Select the cells you want to print in your workbook.
- Choose File > Print from Google Sheets’ menu bar. Alternatively, press Ctrl + P (Windows) or Command + P (Mac).
- Select Selected cells from the Print dropdown menu on the right. This ensures only the selected cells are printed.
- Select Next at the top of the screen.
- Follow the standard print process to print your cells.
Set the Print Area to Print the Entire Sheet
If your workbook has multiple worksheets, and you’d like to print a specific worksheet, you can get Google Sheets to do that.
- Open your workbook with Google Sheets in a web browser.
- Choose the worksheet you’d like to print at the bottom of your workbook.
- Select File > Print from Google Sheets’ menu bar.
- Choose Current sheet from the Print dropdown menu on the right. You’ll see your current worksheet’s preview on the left.
- Select Next at the top and follow the standard print wizard to print your worksheet.
Set the Print Area to Print the Entire Workbook
Sometimes, you may want to print your entire Google Sheets workbook, which could include multiple worksheets. Google Sheets has an option to do that, too.
When you print an entire workbook, make sure your printer has enough ink to print your data. Also, feed enough paper into your printer’s paper tray to ensure there’s no interruption when you print your workbook.
- Access your workbook with Google Sheets in a web browser.
- Choose File > Print from Google Sheets’ menu bar.
- Select Workbook from the Print dropdown menu on the right.
- Choose All sheets from the Selection dropdown menu.
- You’ll see a preview of your entire workbook on the left. If this looks good to you, select Next at the top-right corner.
- You’ll then select your printer, choose the paper size, and other options to finally print your workbook.
Set the Print Area to Print Headers on Each Page
If your Google Sheets data is spread across multiple pages, you may want to include the headers on each page that you print. This makes reading the data easier as you know exactly what column is for what data on each page.
To print column headers on each page, you’ll first freeze the header row:
- Open your workbook and access the worksheet you want to print.
- Select View > Freeze > 1 row from Google Sheets’ menu bar to freeze the first row in your worksheet.
- Choose File > Print to configure the print options for your worksheet.
- Select Headers & footers and enable Repeat frozen rows on the right.
- Customize any other options if you’d like. Then, select Next at the top-right corner.
Customize the Print Area With Custom Page Breaks
You can add custom page breaks to your Google Sheets worksheets to let your printer know where to stop printing a page and start a new page.
To add a page break in your worksheet:
- Select File > Print from Google Sheets’ menu bar.
- Choose Set Custom Page Breaks in the sidebar on the right.
- Drag the blue dotted line in your worksheet to specify a page break. Then, select Confirm Breaks at the top-right corner.
- If you’re not happy with the specified page breaks, select Reset at the top to reset the page breaks.
- Select Next at the top-right corner to continue to print your worksheet with your custom page breaks.
It’s Easy to Customize and Set the Print Area in Google Sheets
Google Sheets offers you the flexibility to print whatever part of your workbook you want. This way, you can focus on the main data that you’d like to print while leaving everything else out. We hope this guide helps you out.