Arrow left
Back to product 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.

How to show gridlines in Google Sheets

  1. Go to the “View” tab above the toolbar.
  2. Move on to “Show”.
  3. Put your cursor on “Gridlines” and check it.
How to show gridlines in Google Sheets

How to delete gridlines in Google Sheets

  1. Go to the “View” tab above the toolbar.
  2. Move on to “Show”.
  3. 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 work sheet. 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.

Other formulas and tips related to cell formatting

If you don’t get the correct answer to your question in this article or have other questions related to cell formatting, you may find the answers in the following articles.

How to Round Numbers in Google Sheets - round numbers with formulas

How to Add Borders in Google Sheets - add various types of cell borders

How to Color Cells in Google Sheets - fill in cells with color

How to Merge Cells in Google Sheets - combine cells

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

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

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711