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.
Step 3: Select the Gridlines option. The gridlines will become visible when you select this option, meaning they will also be printed.
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 the Formatting option at the right side of the window.
Then choose the Show gridlines option.
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.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.