This setting has no impact on the content of the sheet or document. The two available options are landscape (horizontal) and portrait (vertical). ![]() Page orientation can be used to modify the print layout or the direction in which the sheet is positioned. If none meets your desired need, you can use the Custom size option to set your preferred paper size. ![]() When you click on the Paper size dropdown, you will find different paper size options you can select. The Paper size option enables you to select the desired size of paper for printing, with the option to input custom height and width measurements. Some of these options include paper size, page orientation, scale, margins, formatting, and headers and footers. Google Sheets Print settings provide various options to adjust how items are displayed on the printed copy. Click APPLY when you’re done.Īfter this, you can click on the NEXT option to go to the printer selection menu so you can print the entire workbook. Select the sheets you want to print in the Selection option.Open the print setting window using the keyboard shortcut Ctrl + P.Follow these steps to set the print area for the entire workbook in Sheets. If your spreadsheet contains multiple sheets and you wish to print the entire workbook, it is possible to set the print area to encompass the entire workbook. Set Print Area to Print Entire Workbook in Google Sheet You simply need to set the print option to Current sheet in the Print settings page to print the entire sheet. The process for printing an entire sheet is the same as printing select cells. ![]() Set Print Area to Print Everything on a Sheet in Google Sheets This command will take you to the page where you will select your desired printer after which you will click on the Print button to print out the selected cells. In the Print settings window, click on the Current sheet dropdown in the Print section and click on Selected cells (B2:E20).Īs soon as you select this option, the print preview will display only the selected range.Ĭlick on the NEXT button at the top right-hand corner of the screen.You can do this in the File menu but using the Ctrl + P shortcut saves time. Assuming we want to print only the records in the first 20 rows, here’s how we’ll do it. This is a sample Sales data containing revenue information for different products sold over a period. Set Print Area to Print Selected Cells in Google Sheets In this article, we’ll explore how to set up your print area in Google Sheets to ensure your documents are formatted properly so they can look professional. However, printing from Google Sheets is still a straightforward process. ![]() This subtle difference can confuse Excel users. Unlike Excel’s permanent print area, Google Sheets allows you to reconfigure the print area each time you print. If you’re transitioning from Excel to Google Sheets, it’s important to note that the print area settings are slightly different. This is important because, without proper configuration, printed documents may appear poorly formatted, resulting in a waste of resources. However, it’s important to configure the print area correctly before hitting the print button. Whether you want to print a selected range, a specific sheet, or the entire spreadsheet, Google Sheets provides several printing options. Printing from Google Sheets can be a convenient way to share information and present data.
0 Comments
Leave a Reply. |