What Is Print in Google Sheets?
Print in Google Sheets is a feature that allows you to print your spreadsheet or save it as a PDF document. You can use the print option in the spreadsheet either by clicking on “File” in the menu and selecting “Print” or by using the shortcut Ctrl + P. If you need to access the print options, click on the required option in the “Print Settings,” which appears after you click on Print.
Print Settings: Here, you can adjust several options, including Paper size, page orientation, Scale, Margins, and Custom Page Breaks. This feature is helpful in creating physical copies of all your information.
Key Takeaways
- Print in Google Sheets refers to printing out a hard copy of your spreadsheet. This process has many steps to adjust the way your printout looks by formatting your sheet for print.
- To print a workbook or a sheet, go to File -> Print and make the necessary settings in the Print Settings.
- Some of the features you can adjust in printing in Google Sheets include:
- Page orientation (portrait or landscape).
- Margins (normal, narrow, or wide).
- Gridlines, headers and footers
- Selection of print area.
- For an online digital copy, you can save your sheet as a Print in google sheets PDF without printing it out in a paper.
How to set the print area in Google Sheets?
Before printing a sheet, you should consider several options. One is to set up the Google Sheets print area. Let us look at two ways to do this.
Using Layout
Step 1: Let’s try setting the print area in Google Sheets. This process isn’t complicated. First, select the cells you want to print.
Step 2: Next, click on the printer icon on the Google Sheets toolbar.
Step 3: You can make formatting changes in the print preview window. In Google Sheets, layout refers to how you format your pages, which includes the print area.
Print area: You can customize the layout and format of your print area. You may print the entire Workbook, the current spreadsheet, or a particular range.
Using cell selection
Let us look at how to print a specific range.
Step 1:Select the cells you want to print and press Ctrl + P.
Step 2: You can customize the print settings, such as formatting, orientation, header/footer, margins, and page breaks. Click on Next to choose the printer, and then click ‘Print’ or ‘Save.’
As shown below, you can select whether to print the current sheet, the whole workbook, or the cells you have selected.
You can select whether to print the current worksheet, the entire workbook, or the cells you have selected.
You can change the page margin, scale, page breaks, and other formatting by Clicking “Next.”
4. Printer Options
You can select a physical printer or choose to ‘Save as PDF.’
How to print header rows for each Google Sheets page?
If your sheet has header rows and you want to print them on every page, follow these steps.
When you freeze header rows, your Google Sheet stays organized, especially when you work with a large amount of data across several sheets.
The following steps will allow you to print header rows for each Google Sheets page.
Step 1: Open the Google Sheets file that you want to print.
Step 2: Freeze Header Rows by selecting the row you want to use as headers. Click on View in the top menu and move over Freeze. Then select 1 or 2 rows, depending on your headers.
Step 3: Set Print Options by clicking on File in the top menu and selecting Print. Here, click Headers & footers
Step 4: Select Repeat frozen rows, click Next and go to Print.
The header will be printed for all the sheets.
How to change print margins in Google Sheets?
Margins define the boundary of the printed sheet and improve the overall look of the printout. To change print margins in Google Sheets, you can perform the following steps.
Step 1: Open the spreadsheet in Google Sheets. As done before, go to File and select Print. In the Print Settings, under Margins, click Normal.
Step 2: Choose a margin type – To customize the margins, click Custom numbers.
Now, enter the new margin numbers. You can use the arrows to increase or decrease the margins. Before finalization, you can preview your changes by checking the Print preview box.
In Google Sheets, the default margins for the top and bottom are 0.75 inches. You can choose your own margins based on your requirements.
How to set Custom Page Breaks for Printing in Google Sheets?
Now, let us look at how to set custom page breaks for printing in Google Sheets.
Step 1: Open the spreadsheet in Google Sheets. As done before, go to File and select Print.
Step 2: Click Set custom page breaks
Step 3: Now, drag the blue lines to indicate where you want the page to break. Click Confirm breaks
Click Confirm breaks
You can organize your data with horizontal and vertical breaks across multiple pages. To remove a page break, you must point to the line and click Remove.
How to use Named Ranges as Print Areas?
Step 1: Create a Named Range of the area you want to print. For this, go to Data – Named Ranges.
Step 2: Choose a name. Click Done.
Step 3: To select the range for printing, you can select the name as shown below from a pulldown.
Step 4: In the Print pane which opens on the right, you’ll need to choose Print Selected Cells.
This is a very valuable method if you print different ranges at different times.
Important Things to Note
- You can include gridlines and row/column headings if required by checking these options in the Print settings.
- After changing any settings, always remember to check the Print Preview feature to see how your document will look when you print it.
- If printing multiple sheets, choose whether to print all sheets or specific ones.
- You can keep the default setting — Current sheet — or you can print an entire workbook by selecting Workbook in the Print dropdown menu.
Frequently Asked Questions (FAQs)
There are various ways you can print Google Sheets.
The first option is to go to File – Print and make necessary settings in the Print Settings pane.
The second option is to press Ctrl + P in Windows to open the Print Settings pane.
Another option is to click the “Print” icon in the toolbar.
• Print a specific range of cells: You can select the range you want to print and name it. In the print settings, choose “Selected cells.”
• Page orientation: The orientation option is in the Print Settings pane. You can select “Portrait” or “Landscape.”
• Gridlines: You can include gridlines by choosing the option in print settings.
• Adjust margins: You can choose from predefined margin sizes (Normal, Narrow, or Wide) or customize the margins according to your requirements.
You can also choose to include comments and notes if needed.
In the print settings, you can add headers and footers for titles, page numbers, etc. You can also print the required headers for every page by going to View in the top menu and selecting Freeze. Then, depending on your headers, select 1 or 2 rows.
In the Print settings, choose “Repeat Frozen Rows.”
Recommended Articles
Guide to What Is Print in Google Sheets. We learn the different ways of printing a worksheet by setting the print area and formatting. You can learn more from the following articles.
Leave a Reply