Gridline happens to be the most fundamental feature of any Spreadsheet application. While, they are very essential in data visualization, sometimes we are better off without them. Hiding gridline is very simple task and very handy at times.
In this tutorial we will discuss about different methods to show or hide gridlines. Also, how can we show/hide gridlines while printing spreadsheets.
So, lets begin.
Table of Contents
Remove(or Show) all Gridlines using the Menu Option
As always, lets open a sample spreadsheet.
![Sample Data in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-24.png)
Under Menu Bar, goto View -> Gridlines and click.
![View Option in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/2.png)
Since, we unselected Gridlines, you will observe that all the gridlines are removed.
![Remove Gridlines in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-26.png)
In a similar manner, you can also Show gridlines by following the same approach. Like below:-
![Show Gridlines in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/gif1-4.gif)
Note: This change is sheet specific. Other Sheets(like Sheet2 below) will still continue to have gridlines. To remove gridlines from Sheet2, same operation will have to be repeated.
![Sample Sheet in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-28.png)
Action on Specific Gridlines
Above mentioned approach would end up impacting all the rows and columns. However, in case you want to hide or show a specific group of cells then we will take a different approach.
Hide Specific Gridlines
There’s no direct way to “Hide Specific Gridlines” in Google Sheet. We’ll improvise to get our job done here.
Select the group of cells where you want to hide the gridlines and goto Border icon in the quick access toolbar.
![Cell Selection in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-29.png)
Firstly, select the color as White.
![Boarder Settings in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-30-1024x357.png)
Now, Select the first option to enable “All Borders”
![Boarder Settings in Google sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-32-1024x401.png)
Final result. In effect, we didnt hide gridlines but simply added a border which was “white”.
![While Boarders in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-33.png)
Show Specific Gridlines
Once, again no direct way to do this either. This time, we hide all the gridlines first. Then we add borders to the group of cells where we need to show gridlines.
Below illustration should help.
![](http://sheetsinfo.com/wp-content/uploads/2021/06/gif2-4.gif)
Show Gridlines while Printing
As a default setting, Gridlines do not appear while printing. But we can change that.
Step 1: Goto File-> Print and Click.
![Print Option in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/image-34.png)
Step 2: Under the Print Settings, in the lower Right Hand Corner , click the check-box of gridlines.
![Print Settings in Google Sheet](http://sheetsinfo.com/wp-content/uploads/2021/06/gif3-3.gif)
That’s it on this topic. If you face any issues in implementing the above methods then leave a comment down below. Keep browsing SheetsInfo for more such useful information 🙂