How to Print with Gridlines in Google Sheets

Gridlines are a crucial part of many spreadsheets in applications like Microsoft Excel and Google Sheets. They can make data easier to understand, so you may be wondering how to print with gridlines in Google Sheets if you want those gridlines on your paper.

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 Add Gridlines in Google Sheets

  1. Open your Sheets file.
  2. Click View.
  3. Select Gridlines.

Our article continues below with additional information on adding or printing gridlines in Google Sheets, including pictures of these steps.

How to Print the Lines on Your Spreadsheet in Google Sheets (Guide with Pictures)

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.

How to Show or Hide Gridlines from the Print Menu in Google Sheets

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.

How to Remove Borders in Google Sheets

One issue that you might encounter in Google Sheets involves the different between gridlines and borders.

Occasionally people will use borders in place of gridlines. Borders are “on top” of gridlines, so they can override them in a sense.

Of particular issue are white borders that people use to hide gridlines.

Fortunately you can remove borders by selecting the cells with the borders, then clicking the Border button in the toolbar and choosing the Clear borders option.

Additional Sources