The above steps would print the entire content of the worksheet in one single page. In the Print window that opens, select the printer and click on the Print button.In the Print setting page that opens up, click on the Scale option.Click on the Print icon in the toolbar (you can also use the keyboard shortcut Control + P).Select the dataset that you want to print.Suppose you have a dataset as shown below and you want to print this entire dataset on one page in Google Sheets.īy default, Google Sheets will print the first 9 columns (till Store 8) in one sheet and the rest two columns will be printed in the next sheet.īelow are the steps to fit the entire content in one single page and print everything on one page: So let’s get started! How to Print on One Page in Google Sheets (Fit to Page) In this short tutorial, I will show you how to change the print setting so that you can print on one page in Google Sheets by fitting more content on each page. While you may want this in some cases, often you can also print on one page and save some paper.īy default, Google Sheets has a specific area that can be printed on one page, but you can change this by forcing it to print more on a single sheet. If you often print your work in Google Sheets, I am sure you have faced the issue of some rows or columns spilling to the next sheet (leading to an extra print copy).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |