Hide(or Show) Gridlines in Google Sheet

  • Reading time:2 mins read
  • Post category:Formatting
  • Post comments:0 Comments

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.

Remove(or Show) all Gridlines using the Menu Option

As always, lets open a sample spreadsheet.

Sample Data in Google Sheet

Under Menu Bar, goto View -> Gridlines and click.

View Option in Google Sheet

Since, we unselected Gridlines, you will observe that all the gridlines are removed.

Remove Gridlines in Google Sheet

In a similar manner, you can also Show gridlines by following the same approach. Like below:-

Show Gridlines in Google Sheet

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

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

Firstly, select the color as White.

Boarder Settings in Google Sheet

Now, Select the first option to enable “All Borders”

Boarder Settings in Google sheet

Final result. In effect, we didnt hide gridlines but simply added a border which was “white”.

While Boarders in Google Sheet

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.

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

Step 2: Under the Print Settings, in the lower Right Hand Corner , click the check-box of gridlines.

Print Settings in Google Sheet

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 🙂

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Liked the content?? Then share the word!!!

Rishav

I love Google Sheets and heavily rely upon it on a day to day basis. SheetsInfo is my attempt to share my learning with all of you. Hope you find the articles easy to read and simple to understand.

Leave a Reply