If you want to hide gridlines in Google Sheets, you need to open the View menu and select Show and then ensure the Gridlines option is unticked. Hiding gridlines only affects the current sheet.
That’s it! Simple right?
Here’s a screenshot of where you can find the option.
Why would you want to turn gridlines off? I can’t think of a practical example at the moment other than that you might have taken to making pixel art pictures in sheets. If that’s the case, then gridlines are going to spoil the view.
The thing is, gridlines are useful when you’re working. It’s sometimes hard to locate exactly where you want to click with them turned off. Especially if you’re trying to make pictures (like the ones above).
How to hide gridlines for printing only
If you need gridlines to show whilst you work on the sheet, but disappear when you are printing, then there is a specific option for this on the print screen. When you are ready to print, go the File menu and click Print or use the keyboard shortcut Ctrl+p (Windows, ChromeOS) or ⌘ + p (Mac).
When the print settings screen opens, on the right-hand side, towards the bottom, you will see a Formatting menu. Click the small downward arrow to expand these options. Then ensure that Show grid lines is not ticked and your printed file will not have gridlines.
Can you show gridlines on only part of a Google Sheet?
No. There isn’t an inbuilt feature of Google Sheets to allow this, however you can simulate it by using cell borders.
To use cell borders to simulate gridlines you need to open the borders menu from the toolbar and then open the color options and select light grey 1. Leave the border line thickness at the default (the top one in the list).
Finally, select the region of cells you want to simulate gridlines on, open the borders menu and select All borders – . When this is done you’ll get the effect we have in our example below where rows 2 and 3 have light grey 1 borders. I can hardly tell the difference.
There may be a more exact color match, but for speed, and ease of use, light grey 1 is a default and easily selectable color.