How to Print with Gridlines in Google Sheets

Data that you print in a spreadsheet can be difficult to read, especially when there are a lot of rows and columns. It’s very easy for a reader’s eyes to glaze over when viewing this type of information, as it all starts to run together.

This problem becomes amplified if the data isn’t visibly separated by lines, called gridlines, that identify the boundaries of the cells. If your Google Sheets file is currently printing without these gridlines, then you might be looking for a way to include them. Our guide below will show you two different locations where you can set the gridline printing option.

 

How to Print the Lines on Your Spreadsheet in Google Sheets

The steps in this article were performed in the desktop version of Google Chrome, but will work in other desktop Web browsers like Firefox and Microsoft Edge, too. Note that Google Sheets, unlike Excel, has one setting for the display and printing of gridlines. If you have elected to make the gridlines visible, then they will also print on your worksheet. The steps below will show you how to enable the gridlines option from the View menu. We will also discuss changing the gridline setting from the Print menu as well.

Step 1: Sign into your Google Drive and open the Sheets file for which you want to print the gridlines.

 

Step 2: Click the View tab at the top of the window.

click the google sheets view menu

 

 

Step 3: Select the Gridlines option. The gridlines will become visible when you select this option, meaning they will also be printed.

how to print with gridlines in google sheets

 

 

You should now see the gridlines on your spreadsheet, meaning they will print as well.

 

As mentioned previously, you can also control the gridlines from the Print menu. Simply click the File tab at the top of the window, then choose the Print option.

click file, then click print

 

 

Click the Formatting option at the right side of the window.

google sheets formatting tab

 

 

Then choose the Show gridlines option.

gridline setting on google sheets print menu

 

 

Is your spreadsheet currently printing in portrait or landscape, but you want it to print the other way? Find out how to change printing orientation in Google Sheets if your information would look better in a different printing format.