Then choose File | Print, or select the printer icon in the menu bar, or press Ctrl+P.Ģ. If you want to print either the entire Workbook or current Sheet, you continue to the next next step.įigure A To print only a portion of your Sheet, select the cells you wish to print. To print a specific portion of your Sheet, select the cells you want to print (e.g., click-and-hold your cursor in one corner cell of your desired print area, then drag to select adjacent cells) ( Figure A). You will find the Repeat Frozen Rows and Repeat Frozen Columns options in the Headers & Footers section in step 3 below.ġ.
Note: 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. In a desktop-class browser, such as Chrome, Firefox or Safari (including Safari on iPadOS), you may adjust several print options.
#Print selection how to
How to adjust Google Sheet print settings in a browser For more details on Sheet sharing controls, see How to share Google Docs, Sheets, and Slides. Also know that if you are a commenter or viewer of a 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. SEE: Google Docs tips for advanced users (TechRepublic Premium)īefore you perform any of the steps below, first open your Google Sheet on your device (e.g., either your browser or the Google Sheets mobile app). 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.
#Print selection android
You also may print a Sheet from within the Google Sheets mobile apps on either Android or iOS. This sequence differs from both Google Docs and Google Slides, which provide a File | Page setup option, and Google Drawings, with File | Print settings and preview. You adjust print settings options in Sheets after, not before, you choose the Print menu option. Print settings in Google Sheets display after you select File | Print in a Sheet from a desktop-class web browser.
#Print selection software
Top TechRepublic Academy training courses and software offerings of 2022īest project management software and tools 2022 What's hot at TechRepublicīest tech products and most innovative AI/ML companies of 2022 Google Sheets, which is part of Google Workspace, also allows you to adjust many layout, scaling and formatting options. You can choose to print everything in your workbook, your current sheet or a selected set of cells. Google Sheets gives you considerable control over how your pages print. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships.
The Android and iOS Google Sheets apps also lets you print. Using a desktop-class browser, you can adjust many Google Sheets printing settings. How to set your print area in Google Sheets
0 kommentar(er)
