How to Print Gridlines in Google Sheets

Gridlines in a spreadsheet are important for providing visual representation of the boundaries of a cell. It makes it easier to tell which characters belong to which cell.

And while this is important when you are editing a spreadsheet in Google Sheets on your computer, it is just as important when someone is reading the data in the spreadsheet on a printed page.

If you have printed a spreadsheet and found that it doesn’t have those lines, then you are able to change a setting in Google Sheets so that they appear.

This setting will serve the purpose of both adding the gridlines to the spreadsheet that you view on your screen, as well as add them to the printed page.

How to Print the Lines on Your Spreadsheet in Google Sheets

The steps in this article were performed in the Web-browser version of Google Sheets, specifically within the Chrome browser. Completing these steps will result in a spreadsheet that will include the horizontal and vertical lines that separate the individual cells on your spreadsheet.

Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet for which you would like to print the gridlines.

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

how to print cell lines in google sheets

Step 3: Click the Gridlines option.

how to print gridlines in google sheets

There should now be visible gridlines on your spreadsheet. When you go to the print menu by clicking File, then Print, the preview window should display the sheet as it will be printed, including the gridlines separating your cells.

Do you have a multi-page spreadsheet that is tough to read because there aren’t any column headings after the first page? Learn how to repeat the top row of your spreadsheet on every page so that the data in your columns is easier to identify.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy