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
- Open your Sheets file.
- Click View.
- 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.
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.
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 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.
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.
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.