![]() ![]() 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). To print a specific portion of your Sheet, select the cells you want to print. You will find the Repeat Frozen Rows and Repeat Frozen Columns options in the Headers & Footers section in step 3 below.įollow these steps to adjust Google Sheet print settings in a browser:ġ. 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, you can adjust several print options. Adjust Google Sheets print settings in a browser For more details on Sheet sharing controls, see How to share Google Docs, Sheets and Slides. 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. ![]() 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.īefore 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’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. SEE: The complete Google Master Class bundle (TechRepublic Academy) It also differs from Google Drawings, which uses File | Print settings and preview. This sequence differs from both Google Docs and Google Slides, which both provide a File | Page setup option. You’ll adjust print setting 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. Learning resources for Google Sheets users.How do I change print margins in Google Sheets?.How do I print header rows for each Google Sheets page?.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. Printing options are available in both browser and app versions of Google Sheets. SEE: Google docs tips for advanced users (TechRepublic Premium) Google Sheets, which is part of Google Workspace, also allows you to adjust many layout, scaling and formatting options for your print area. You can choose to print everything in your workbook, your current sheet or a selected group 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. ![]() 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. A guide to setting the print area in Google Sheets ![]()
0 Comments
Leave a Reply. |