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. 

‍

‍

‍

‍

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 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.

‍

‍

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.

‍