How To Print Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

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.

Step 1

When you’re ready to print your spreadsheet, open the File menu and choose Print to access the Print Settings screen

Step 2

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

Step 3

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

Step 4

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

Step 5

Once you’re happy with the page breaks, click the Confirm Breaks button in the upper-right

Step 6

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

Step 7

When you’re happy with the print preview, click the Next button in the upper-right to proceed with printing the spreadsheet

Step 8

Your browser’s print dialog will open. Proceed with printing the spreadsheet as usual for your browser