Written by Ivana Google Workplace / Sheets
To hide the gridlines in Google Sheets:
To remove the gridlines in Google Sheets when printing a file:
While working on a dataset in Google Sheets, you may want to remove the gridlines to create a cleaner look.
The gridlines are, by default, applied to Google Sheets. They are the grey lines that separate the cells and make the data look organized.
But, sometimes, you may need to hide the gridlines in Google Sheets in a certain range of cells to make them stand out in your dataset.
In this quick tutorial, we’ll show you how to remove the gridlines in Google Sheets and how to show gridlines if you want to bring them back.
Gridlines are different from the borders that you add to cells to make them more visible. If you remove the grid in Google Sheet, it won’t remove any added borders or formatting you’ve applied to your cells.
That being said, these are the steps to hide the gridlines in Google Sheets:
Now, you’ll notice that the gridlines in the Google Sheets file are gone.
If you want to bring the gridlines back, just go to View > Show and select the ‘Gridlines’ option.
Check out also how to unhide rows in Google Sheets.
If you want to show the gridlines in a specific range of cells, first remove the gridlines with the steps above. Then follow the steps below to add a border to a selected range of cells.
You can also make your worksheet more visually appealing by coloring every other row in Google Sheets.
When you print a Google Sheets document, you’ll notice that the worksheet comes out with gridlines.
If you don’t want the worksheet to be printed with the gridlines, but you want to keep them in the online document, you can remove the gridlines from the printed version only.
This is how to remove the gridlines when printing a Google Sheets document. However, if you’ve applied borders to a range of cells, you can’t remove them from the Print settings screen. If you don’t want the borders to be printed on the sheet, you need to do it in the worksheet in the Borders tab.
If you want to learn more Google Sheets tips, read our guide on how to group rows and columns In Google Sheets.