How to set the print area in Google Sheets: a step-by-step guide

Google Sheets gives you a lot of control over how your pages print, whether your sheets contain Bard, customer data, or financial analysis tables. You can choose to print everything in your workbook, the current sheet, or a selected group of cells. Google Sheets also lets you adjust many layout, scaling, and formatting options for the print area.

Print options are available in both the browser and app versions of Google Sheets. This tutorial explains how to set up a print area in Google Sheets and answers any other questions you may have during this process.

Before you start

Before following the steps below, you must first open the Google Sheet of your choice in a browser or the Google Sheets mobile app and ensure that you have the appropriate permissions to print. If you have Commenter or Viewer-only access to a sheet, you cannot print, download, or copy the sheet, as the sheet owner or editor has the option to disable these features. It may not be possible. For more information about sheet sharing controls, see How to share Google Docs, Sheets, and Slides.

How to set print range in Google Sheets

To view print settings in Google Sheets,[ファイル]|[印刷設定]Choose. Print to sheets from a desktop-class web browser. The spreadsheet print settings options are[印刷]Make adjustments after you select a menu option, rather than before. This sequence is different from both Google Docs and Google Slides, which provide File | Page setup options. It is also different from Google Drawing, which uses File | Print settings and previews.

See also: Get Master-level training on Google Workspace Take advantage of this bundle from TechRepublic Academy.

Adjust Google Sheets print settings in your browser

Desktop-class browsers such as Chrome, Firefox, and Safari allow you to adjust several printing options. To adjust Google Sheet print settings in your browser, follow these steps:

1. To print a specific part of the sheet, click and hold the cursor in a corner cell of the desired print area, drag the cursor to select adjacent cells, and select the cells you want to print. To do. (Figure A).

Diagram A

Note: If you want to print the entire workbook or the current sheet, skip this step and proceed to the next step.

2.[ファイル]|[ファイル]Choose. Print. Or press Ctrl + P or[やり直し]You can also select the printer icon that appears to the right of the right arrow.

3. On the print preview screen, you can adjust the following items:

• Print range: Current sheet, workbook, or selected cells.
• size of paper: Choose from a variety of preset sizes or enter a custom size.
• Page orientation: landscape or portrait.
• scale: Width, height, fit to page, or enter a custom percentage.
• margin: Enter standard, narrow, wide, or custom size.
• New Page
• Formatting: Add gridlines and notes. Adjust page order. Select horizontal (center, left, or right) and/or vertical (top, center, bottom) alignment options.
• Header and footer: Page number, title, name, date, time, etc.

As you adjust each setting, the display adjusts to reflect the options you select. Change the above settings as much as possible until the print preview matches your desired output. (Figure B).

Diagram B

4. Select Next in the upper right corner.

5. Change any of the following options as needed:

• destination: Select your printer or choose Save as PDF or Save as PDF to Google Drive.
• page: Specify all or specific pages to print.
• Number of pages per sheet: Select 1, 2, 4, 6, 9, or 16.
• margin: Default, None, Minimum, or Custom.
• Option box for printing background graphics.

6. Select Print or Save depending on your options and system. (Figure C). In some situations, you may want to first save the sheet as a PDF, then open and print the PDF.

Figure C

How can I print the header row for each page in Google Sheets?

Freezing header rows can help keep your Google Sheets organized and easier to use, especially when you have large amounts of data that span multiple rows. Using this approach, you don't have to scroll up or flip through multiple pages to see the header.

Reference: Check these out Google Docs tips for advanced users.

The following steps enable you to print header rows for each page of Google Sheets in the browser-based version of the application.

1. Open the Google Sheets file you want to print.

2.[表示]|[表示]Click. Freeze and select the Header Row option (usually row 1). If you select the fixed option, the top row will be visible even if you scroll down. There are other header row options that you can select based on your needs. These vary depending on the cursor position.

3. Click “File” in the top left, then click “Print”. This will open a print preview window so you can see how your Google Sheets will look when printed.

4. Click Header and Footer in the right column.

5. Scroll down and select Fixed Row Repeat.

Users can also repeat multiple rows at the top of the page.[フリーズ]You can choose to repeat more rows using the options in the menu. moreover,[カスタム フィールドの編集]You can add page numbers from the tab.

How do I change print margins in Google Sheets?

Margins are the unused blank space between the content and the edges of a printed page. Google Sheets has an option to change the size of the print margins.

Reference: Here's how Change header margins in Microsoft Word.

The default settings work for most use cases, but you may need to adjust the margins to change the appearance of your sheet. You can also change the page scale to fine-tune how your sheet looks when printed.

To access margin and scale settings,[ファイル]|[スケール]Click. Print.

Margin settings

• usually: Default configuration.
• wide: Increasing the margins creates more white space around the edges. This reduces the space on the page for content.
• narrow: Reducing margins gives you more space for your content and reduces the number of printed pages, but it also reduces blank space.
• Custom number: You can enter a custom size for the margins based on how the page will be printed.

Scale settings

• usually: Default configuration.
• Fit width: This setting compresses cells so that all columns fit on one page. This setting is best when printing many rows with only a few columns.
• Fit to height: Content is compressed as necessary to fit all lines on one page. This setting is ideal for printing many columns in just a few lines.
• Fit to page: This setting adjusts the worksheet content or selected content to fit on one page. If your data range is small, you can use this setting to improve data visibility.
• Custom number: You can also enter your customer number in the scale settings.

How to print from Google Sheets app

You can print from the Google Sheets mobile app on your Android or iOS device.

1. On an Android device, tap the three vertical dots menu in the top right corner. For iOS, tap the horizontal three-dot menu in the top right corner (Figure D).

Figure D

2. Tap Share & Export.

3. Tap Print.

4. Next, select your printer and adjust the number of copies.

Depending on your platform and printer, you may be able to adjust additional options. For example, on Android, you can tap the down arrow to adjust options. These may include paper size, paper orientation, specific pages to print, color versus black and white printing, or duplex printing.

How to change printing options in the Google Sheets mobile app

When you print from the Google Sheets mobile app on Android, iOS, or iPadOS, you have access to fewer settings and controls than when you print Google Sheets from a desktop-class browser. As of August 2023, it is not possible to select specific cells to print.

On Android, you can make the following adjustments within the Google Sheets mobile app:

• Device (printer or save as PDF).
• Number of copies.
• Color vs. black and white.
• Double-sided (if supported by printer).
• Paper size (if supported by printer).
• Orientation (portrait or landscape).
• Pages selected for printing.

Learning resources for Google Sheets users

Google Sheets has many simple features, but for more advanced use cases and projects, shortcuts and tips can make a big difference. Now that you can use Google Sheets as a data source for mail merges in Gmail, you might not even need to print.

To use Google Sheets more productively and efficiently, the following learning resources from the Google Tutorials Library may be particularly helpful.

These tutorials cover a variety of business projects and specific goals. However, these may not be what you need to increase your overall Google Sheets expertise. For additional tips and training, this Google Sheets and Microsoft Excel certification course from TechRepublic Academy is a great resource.

Read next: Consider this side-by-side analysis of Google Workspace and Microsoft 365.