On the printer settings, click on the ‘Page size’ drop-down list and choose the size. Changing Page SizeĪfter you selected the Print option in your document, it will take you to Print settings. Setting Print Area in Google Sheets by Customizing Page LayoutĪnother way you can set the print area in a Google spreadsheet is by adjusting the page size, scale, and margins. This will print the entire workbook with multiple worksheets. To change that, click on the ‘Print’ drop-down list and select ‘Workbook’. In the ‘Print settings’ page, the default setting is set to print the current sheet. ![]() To set the print area for the whole workbook, open the workbook and click ‘Print’ from the menu. This will print the entire current worksheet. You just need to adjust the layout options if needed and make sure all data shows up correctly in the print preview. The print area will be automatically set to the current sheet when you click the Print option from the menu. You don’t need to set to print area for the current sheet, it is the default setting to printing the spreadsheet. Setting Print Area for Current Sheet or Workbook in Google Sheets Your selected cells will be printed on one or more pages. Then, click ‘Next’ to choose the printer options and print. When you change this, you will notice the preview changing to the selected cells. ![]() On the right side, click on the ‘Print’ drop-down and choose ‘Selected cells’. The Print settings page will open up, with the preview of the printing sheet and printing options. Then, click the ‘print icon’ at the toolbar or select the ‘Print’ option under the File menu. But it should continuous range of cells, if you select non-continuous ranges of cells, only the last selected range will be printed. Here’s how:įirst, open the spreadsheet you want to print and select the range of cells, it can be column(s) or row(s). But if you only want to print a specific range of cells, you will need to set the print area for selected cells. When you print in Google Sheets, all the cells with data are printed. So, by setting the Print Area to selected cells, you can only print a specific range of cells, like the column of Name. And you only want to print the names on that list. Suppose you have a contact list in a Google spreadsheet, it has columns of Name, address, and mobile numbers. Setting Print Area for Selected Cells In Google Sheets In this article, we will show you how to set Print Area in Google Sheets. ![]() Google Sheets is very flexible, it lets users choose between printing everything in the workbook, the current sheet, or selected cells. ![]() Printing a Google spreadsheet is way different than printing Excel sheets. Excel lets you configure other layout options including the print area as a permanent setting before printing the sheet, whereas Google sheets want you to adjust the layout options each time you print otherwise it will print in the default options. If you configure the print area wrong in the printing options, it will result in unnecessary information, wasted papers and ink, and badly located page breaks.Ī print area defines how much of your sheet (one or more cell ranges) will be printed when you don’t want to print the entire spreadsheet. When it comes time to print a spreadsheet, setting the print area is an essential part of the process for getting the necessary information on paper.
0 Comments
Leave a Reply. |