How-To

How to Hide Gridlines in Google Docs Spreadsheets

How to Hide Gridlines in Google Docs Spreadsheets - Featured

Google Sheets allows you to hide gridlines in your spreadsheets, so you can fully customize how they look. Here’s how.

I have a love/hate relationship with gridlines in spreadsheets. Yes, they make it easy to see the organization of your cells, but they can also make the tables look cluttered. This is especially true when you print the spreadsheet or want to present it in a PDF to someone else. Fortunately, most modern spreadsheet applications allow you to hide those gridlines. This is true of Microsoft Excel, and it’s also possible in Google Sheets. Let me walk you through how to hide the gridlines in your Google Sheets spreadsheet.

How to Hide Gridlines in Google Sheets

By default, your spreadsheet in Google Sheets has gridlines visible, as below.

Google Sheets Gridlines Visible

Hiding them is easy, though. In your Google Sheets spreadsheet, click View > Show > Gridlines. Make sure the Gridlines option is no longer checked.

Hide Gridlines in Google Sheets

You’ll see the gridlines disappear, leaving you complete control to set borders to display exactly how you want them to appear. This will apply on screen as well as when you print your spreadsheet.

Gridlines Hidden in Google Sheets

Adding Borders to Your Spreadsheet Cells in Google Sheets

You may still want borders around some of your cells, and Google Sheets makes that easy to do.

  1. Highlight the cells you want to create borders for.
    Highlight cells to create borders
  2. Click theĀ Borders icon in the toolbar.
    Cell Borders Menu in Google Sheets
  3. Various buttons allow you to turn on all borders or just certain ones. You can also configure the type of border, border width, and the color of the border.
    Borders Options in Google Sheets
  4. You may also want to set conditional formatting or alternating fill colors. Both options can be found in theĀ Format menu.
    Conditional Formatting and Alternate Colors

As you can see, hiding the gridlines in Google Sheets and using cell borders instead allows more customization of your spreadsheet. You aren’t limited to the lines between all cells, and can instead set up your sheet to look exactly how you want.

Article originally published February 23, 2011. Completely rewritten May 6, 2024.

4 Comments

4 Comments

  1. Rod Tompkins

    September 23, 2012 at 10:50 am

    Wow, this is really simple fix, but really helpful. I would have poked around quite awhile before finding this. My issue was not with printing, however, but with gridlines showing on Google spreadsheets published as embedded html or pdf on my website. Your fix worked for this with one issue: The spreadsheet still displayed with one gridline down the left side of the A column. I fixed this by inserting a blank column in my spreadsheet to the left of my first column and then changing my published range (from A1:C47 to B1:D47) and it now shows the spreadsheet without any gridlines.

    Thanks again for your very-well written and illustrated tutorial!

    Rod

    • Rod Tompkins

      September 23, 2012 at 10:56 am

      BTW, my fix works for embedded html (iframes), but the PDF still shows gridlines. I’ll have to work on that one some more.

  2. Taylor Silenzio

    February 15, 2013 at 7:44 am

    Thank you! I was missing the ability to hide them when printing. Also stinkbugs do stick when you crush them, try it..

  3. Noobz

    April 29, 2021 at 5:08 pm

    Great thank.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

To Top