LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Tips

How to Show Gridlines in Google Sheets

You will learn how to show and delete gridlines in Google Sheets in this article.

What are gridlines in Google Sheets?

Gridlines in Google Sheets are the horizontal and vertical lines that separate the cells in a worksheet. These lines form a grid pattern that helps to organize the data in the sheet and make it easier to read and navigate.

By default, gridlines are displayed in Google Sheets, and they are used as a visual guide to help you align your data and format your worksheet. 

A picture showing gridlines in Google Sheets

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

When are gridlines beneficial in Google Sheets?

Gridlines in Google Sheets can be beneficial in several ways:

  • Readability: Gridlines make it easier to read and interpret data in a sheet.

  • Alignment: Gridlines can help you align your data and format your sheet.

  • Navigation: Gridlines can also help you navigate a sheet more easily. 

  • Printing: When you print a sheet, gridlines can help to maintain the formatting and layout of the data. 

However, sometimes gridlines are annoying as they make the cell formatting, especially borders. Thus, you need to turn on and off gridlines depending on the content and situation.

How to show gridlines in Google Sheets

  • Go to the “View” tab above the toolbar.

  • Move on to “Show”.

  • Put your cursor on “Gridlines” and check it.

How to show gridlines in Google Sheets

Sheets tutorials availalble now in our free certificate program!
Learn basic and intermediate functions with digestible videos and instructions.
Enroll in LiveFlow Academy

How to delete gridlines in Google Sheets

  • Go to the “View” tab above the toolbar.

  • Move on to “Show”.

  • Put your cursor on “Gridlines” and uncheck it.

How to delete gridlines in Google Sheets

We strongly recommend that you delete the gridlines first when you create a new sheet. This is because the gridlines sometimes make it difficult to draw borders correctly.

Imagine you want to draw borders in a color similar to that of the gridline or thin black borders with gridlines on. It’s likely hard to tell if there are borders or not on a certain range of cells then!

How do I make grid lines bold in Google Sheets?

Unfortunately, unlike Excel, you can’t change the gridlines’ default style in Google Sheets. However, you can still change the borders’ color on your worksheet. If you are curious, go to this page and learn how to do it: How to Add Borders in Google Sheets

How do I make the grid lines darker in Google Sheets?

Same as the default style of the gridlines, there is no way to change the default color of the gridlines. You can use border functions instead.

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.