In this tutorial, you will learn how to print google sheets.
There are a few ways printing a spreadsheet is a little different from printing a word processing document. For one thing, You may have many separate sheets in your spreadsheet file and want to print all or only some of them. It’s also harder to figure out page breaks and pagination in a spreadsheet, since spreadsheet files can grow side to side as well as up and down. Fortunately, Google Sheets provides a print settings window that can help you print your spreadsheet the way you want it. This guide will walk you through the most important features.
When you’re ready to print your spreadsheet, open the File menu and choose Print to access the Print Settings screen
The Print Settings Window will appear, displaying the spreadsheet print preview and a settings sidebar. At the top of the sidebar is a dropdown to specify what portion of the spreadsheet to print. You can choose to print the entire workbook including all tabs, only the current tab, or you can even limit the print range to the currently selected cells only
Below that, specify the paper size, page orientation, and scale to print at. Note that it’s a good idea to look at the print preview in the middle of the screen while you adjust these settings to see how the document looks
If you need to adjust the default page breaks, click the blue SET CUSTOM PAGE BREAKS text. A new view will appear with dotted lines to show the position of page breaks. Drag and drop the page breaks to adjust them as needed
Once you’re happy with the page breaks, click the Confirm Breaks button in the upper-right
You can also adjust the formatting, such as whether to display gridlines and comments under the formatting section, or add headers and footers in the Headers & Footers Section
When you’re happy with the print preview, click the Next button in the upper-right to proceed with printing the spreadsheet
Your browser’s print dialog will open. Proceed with printing the spreadsheet as usual for your browser