Google Sheets files will display the gridlines on your screen by default when you create a new spreadsheet. Use these steps to remove lines in Google Sheets.
- Sign into Google Drive and open your file.
- Click the View tab at the top of the window.
- Select the Gridlines option to remove the check mark.
Our guide continues below with additional information and pictures for these steps.
Spreadsheet applications like Google Sheets use gridlines to show the physical boundaries of the cells in your sheet.
These gridlines are often preferred, and one of the more common searches concerning Microsoft Excel is how to print with those gridlines.
Google Sheets displays gridlines by default, and actually prints with them by default, too.
But if your spreadsheet’s layout is improved by removing the gridlines, then you may be wondering how to get rid of them.
Our guide below will show you how to remove lines in Google Sheets.
How to Hide Lines in a Google Spreadsheet
The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will work in other desktop browsers, too.
Step 1: Sign into your Google Drive and open your Sheets file.
Step 2: Click the View tab at the top of the window.
Step 3: Select the Gridlines option to remove the check mark to the left of it. The gridlines in your spreadsheet should now be gone. If you go to print this sheet you will note that the gridlines are removed from the printable version as well.
If you still see lines after removing the gridlines, then it’s probably being caused by cell borders that were previously added.
You can remove cell borders by selecting all of the cells that contain the borders, then clicking the Borders button in the toolbar and selecting the Clear borders option.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets
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.