If you want to print your Google Sheets document or only a specific area of a Google spreadsheet, you can set the print area with these tips. Show
Google Sheets gives you considerable control over how your pages print. You can choose to print everything in your workbook, your current sheet or a selected group of cells. Google Sheets, which is part of Google Workspace, also allows you to adjust many layout, scaling and formatting options for your print area. SEE: Google docs tips for advanced users (TechRepublic Premium) Printing options are available in both browser and app versions of Google Sheets. In this tutorial, we’ll walk through how to set your print area in Google Sheets, as well as some other questions that might arise during this process. Jump to: How to set print area in Google SheetsPrint settings in Google Sheets display after you select File | Print in a Sheet from a desktop-class web browser. You’ll adjust print setting options in Sheets after — not before — you choose the Print menu option. This sequence differs from both Google Docs and Google Slides, which both provide a File | Page setup option. It also differs from Google Drawings, which uses File | Print settings and preview. SEE: The complete Google Master Class bundle (TechRepublic Academy) If you’re looking for an alternative printing method, you can also print a Sheet from within the Google Sheets mobile app on either Android or iOS. However, when you print from the Google Sheets mobile app, you have access to fewer settings and controls than you do when you print a Google Sheet from a desktop-class browser. Before you perform any of the steps below, you must first open your selected Google Sheet on your browser or the Google Sheets mobile app to check that you have the right permissions to print. If you only have Commenter or Viewer access to the Sheet, you might not be able to print, download or copy the Sheet, since a Sheet owner or editor has the option to disable these features. For more details on Sheet sharing controls, see How to share Google Docs, Sheets and Slides. Adjust Google Sheets print settings in a browserIn a desktop-class browser, such as Chrome, Firefox or Safari, you can adjust several print options. If you wish to print one or more rows and/or columns repeatedly on each page, choose View | Freeze, then select the respective rows and/or columns before you proceed to print below. You will find the Repeat Frozen Rows and Repeat Frozen Columns options in the Headers & Footers section in step 3 below. Follow these steps to adjust Google Sheet print settings in a browser: 1. To print a specific portion of your Sheet, select the cells you want to print. To do this, click and hold your cursor in one corner cell of your desired print area, then drag your cursor to select adjacent cells (Figure A).
Figure A 2. Choose File | Print. Alternatively, you can press Ctrl+P or select the printer icon displayed below the menus, to the right of the Redo right arrow. 3. On the print preview screen you can adjust the following items:
As you adjust each setting, the display adjusts to reflect your selected options. Change as many of the settings above until the print preview matches the output you desire (Figure B). Figure B 4. Select Next in the upper right corner. 5. Modify any of the following options as necessary:
Either select Print or Save, depending on your options and system (Figure C). In some circumstances, you might save your Sheet as a PDF first, then open your PDF and print it. Figure C How do I print header rows for each Google Sheets page?Freezing header rows can help to keep your Google Sheet organized and makes it easier for you to use, especially when you are working with a large amount of data covering several rows. With this approach, you won’t have to scroll up or flip through several pages to check headers. The following steps will allow you to print header rows for each Google Sheets page in a browser-based version of the application: 1. Open the Google Sheets file that you want to print. 2. Click on the View tab at the top of the window. 3. Click Freeze, and then select the header row option, which is typically row 1. The Freeze option will display the top row even when you scroll down. 4. Click File at the top left, and then click Print. This will open the Print Preview window to show you how your Google Sheet will appear when printed. 5. Click on Headers & Footers in the right column. 6. Scroll down to select Repeat Frozen Rows. Users can also repeat more than one row at the top of the page. They can select to repeat more rows through the options in the Freeze menu. Additionally, you can add page numbers through the Edit Custom Fields tab. How do I change print margins in Google Sheets?Margins are the unused white space between the content and the edges of a printed page. Google Sheets offers the option for you to change the size of your print margins. SEE: How to change the header margins in Microsoft Word (TechRepublic) Although the default settings work for most use cases, you might occasionally need to adjust the margins to modify the Sheet’s appearance. You can also change the Scale of the pages to fine-tune how you want the Sheet to appear when printed. To get to the Margin and Scale settings, click on File and then click on Print. Margin settings
Scale settings
How to print from Google Sheets appYou can print from the Google Sheets mobile app on either Android or iOS devices. 1. Android devices, tap the three-vertical dot menu in the upper right. On iOS, tap the three-horizontal dot menu in the upper-right (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/or printer, you may be able to adjust additional options. For example, on Android, you can tap the down arrow to adjust options. These might include paper size, paper orientation, specific pages to print, color vs. black and white printing, or two-sided printing. Learning resources for Google Sheets usersGoogle Sheets has many straightforward features, but for more sophisticated use cases and projects, secret formulas, shortcuts and tips make a huge difference. To use Google Sheets more productively and efficiently, these learning resources from our Google tutorial library are especially helpful:
These tutorials cover a variety of business projects and specific goals. However, they may not be what you need to boost your overall expertise in Google Sheets. For additional tips and training, this Google Sheets and Microsoft Excel certification course from TechRepublic Academy is a great resource. Read next: Google Workspace vs. Microsoft 365: A side-by-side analysis (TechRepublic Premium) Google Weekly NewsletterLearn how to get the most out of Google Docs, Google Cloud Platform, Google Apps, Chrome OS, and all the other Google products used in business environments. How do I print landscape in Google Sheets?Change page orientation or paper size. On your computer, open a spreadsheet at sheets.google.com.. At the top, click File. Print.. Under “Orientation,” choose Landscape or Portrait.. Under “Paper size,” choose the size of paper you want to print on. To add a custom paper size, choose Custom size and enter a height and width.. How do I change the print orientation in Google Sheets app?You can adjust the print settings like paper orientation, paper size, and which pages you want to print.. Open your Google Sheets app.. Select the spreadsheet you want to press More.. Choose Share & Export, then choose Print.. Select the Paper Size and adjust print settings.. Select your printer.. Hit the print button.. Can I print landscape from iPad?On iPad, tap the document name or tap the More button depending on what you see in the toolbar. Tap Document Options, then tap Document Setup. To change the page orientation, tap Portrait or Landscape.
How do I print landscape in Google Sheets mobile?Open the Google Sheets app on your device. Open the spreadsheet you'd like to print and tap on “More” in the top right corner of your screen. Tap on “Share & export.” and then tap on “Print.” Tap on “Paper size.” This will allow you to adjust your print settings and specify things like paper orientation and color.
|