How to Show and Hide/Remove Gridlines in Google Sheets

How to Show and Hide Gridlines in Google Sheets 15

In this digital era, we are using advanced technologies to save time and make work easy. In this article, we will learn how to show and hide gridlines in google sheets. Google Sheets is also a very useful application with mind-blowing features. It is a web-based application that allows users to make, update, and edit spreadsheets and share data online. In educational institutions, offices, banks, etc., you can find its applications almost everywhere.

Now moving towards our subject which is revolving around Gridlines in Google Sheets. Google Sheets has gridlines around cells. These gridlines allow you to see and read the data. But sometimes you might not like these grid lines. Depending upon your requirements maybe you only want gridlines in the specific range or data you’re working with and want to hide gridlines everywhere else.

In this article, we are going to explain to you How to show and hide Gridlines in Google Sheets very easily as well as in case you want to print the spreadsheet with or without those gridlines. Removing gridlines in Google Sheets is not difficult. But it’s a little different from how you do it in MS Excel. So it’s understandable if you are new to Google Sheets.

What are Gridlines in Google Sheets?

Gridlines are actually what make your data look good, organized, and easy to read. In Google Sheets, these are horizontal and vertical gray boundary lines that separate one cell from another in a spreadsheet. By default, Google Sheets displays gridlines when you edit a spreadsheet. If you select a cell (or multiple cells), it will be surrounded by a blue border.

Note: Gridlines are different from cell borders, which you can add manually to highlight cells. So do not get confused between them. Hiding gridlines in Google Sheets will not affect any additional cell borders or formatting you have applied to cells in the spreadsheet.

Below you can see how Google Sheets look along with the gridlines in it around the cells.

How to Show and Hide Gridlines in Google Sheets 1

Use Cases of Gridlines in Google Sheets

Gridlines make your spreadsheet clean and easy to understand then you might wonder why we need to remove them. I hope the explanation below would be useful to make you understand the need of removing gridlines in Google Sheets.

Gridlines can be particularly confusing in some situations, especially if you have a lot of images in your spreadsheet. They are only good for table work, but that doesn’t mean the entire spreadsheet has to be a huge table of individual cells. Even with Google Sheets, you can remove gridlines or apply them selectively to your advantage

A detailed explanation has been given below from where you can easily learn step by step the procedure of removing gridlines in Google Sheets. So let’s get started!

See also  How to Use VLOOKUP in Google Sheets (User Guide)

How to Show and Hide/Remove Gridlines in Google Sheets

What kind of customization do we want, we want to remove gridlines from the entire sheet or only the specific area on which we are working, both conditions may be applied, but now it’s up to you what you need. We will discuss both conditions in deep detail.

How to Hide / Remove gridlines for the Entire Spreadsheet

If you want to remove Gridlines from entire sheets follow these essential steps below:

Step 1

As we know there are multiple sheets in Google Sheets so, firstly activate your spreadsheet in Google Sheets where you want to remove and hide the gridlines.

How to Show and Hide Gridlines in Google Sheets 2

Step 2

At the top of your google spreadsheet, you will see the main menu bar. Find and click on the “View” tab.

How to Show and Hide Gridlines in Google Sheets 3

Step 3

A dialogue box will appear in front of you like this

How to Show and Hide Gridlines in Google Sheets 4

Step 4

Go to the option “Show”, another dialogue box will open where you will see the option “Gridlines

How to Show and Hide Gridlines in Google Sheets 5

Step 5

Uncheck this option by simply clicking on it and this will remove the gridlines

How to Show and Hide Gridlines in Google Sheets 6

Step 6

How to Show and Hide Gridlines in Google Sheets 7

You are done now Gridlines have been removed as you may see,

How to Show gridlines for the Entire Spreadsheet

The Gridlines option works like a toggle in the View tab. This means that if you need to restore the gridlines, you have to go back to the steps like,

Step 1

Similarly, first, go into the View tab from the menu and go into the option Show

How to Show and Hide Gridlines in Google Sheets 8

Step 2

Now check the icon of Gridlines

How to Show and Hide Gridlines in Google Sheets 9

Step 3

Here are your Gridlines

How to Show and Hide Gridlines in Google Sheets 10

See also  Conditional Formatting based on Another Cell in Google Sheets

How to Hide gridlines for a Specific Range

If you want to display gridlines only in a specific range of data and not across the whole spreadsheet, you need to repeat the same procedure as explained above, and after that apply a border to the desired range of cells using the following quick and simple steps:

Step 1

First, remove the gridlines as we did previously

How to Show and Hide Gridlines in Google Sheets 11

Step 2

Select the range of cells in which you want to show the gridlines

How to Show and Hide Gridlines in Google Sheets 12

Step 3

Find the Borders icon in the toolbar

How to Show and Hide Gridlines in Google Sheets 13

Step 4

To apply a border to all the selected cells click on the Borders icon

How to Show and Hide Gridlines in Google Sheets 14

Step 5

In this way, you will find the Gridlines along where you are working or your desired area

How to Show and Hide Gridlines in Google Sheets 15

By following the above-explained steps in both cases you will successfully remove the gridlines in the Google Sheets spreadsheet while editing. You may also remove Gridlines after completion of your document while printing.

See also  How to Merge Cells in Google Sheets (Complete Guide)

How to Hide / Remove Gridlines while Printing

When your Google Sheets spreadsheet has grid lines in it and you are going to print that spreadsheet (or part of that spreadsheet), you will see that it prints the gridlines as well. There is a different procedure to remove gridlines when printing.

If you want to avoid gridlines to be printed, you can disable them by following the steps to print the spreadsheet without gridlines in Google Sheets.

Step 1

Let’s have some sample data

How to Show and Hide Gridlines in Google Sheets 16

Step 2

Now press Ctrl+P, and a new window of print preview a print option will open

How to Show and Hide Gridlines in Google Sheets 17

Here you may see the gridlines in the print preview, if you want to remove these Gridlines then follow ahead some more steps.

Step 3

See at the right bottom of your window you find an option “Formatting” open it

How to Show and Hide Gridlines in Google Sheets 18

Step 4

Now some more options will open in front of you in which you will find option Gridlines unchecked by clicking on it

How to Show and Hide Gridlines in Google Sheets 19

Step 5

As you may see in the picture Gridlines along the data have been removed now

How to Show and Hide Gridlines in Google Sheets 20

This is how you can remove and hide gridlines while printing. Follow these instructions properly so you can print your spreadsheet without printing gridlines. And if you want to print documents with gridlines similarly attempt back to the steps checked the Gridlines option from Formatting while print preview you will find Gridlines along the document.

Tips:  If you have applied a border to a range of cells that you are going to print, you cannot remove it from the print settings screen. If you don’t want to print the border, you have to go back to the spreadsheet and delete it.

I hope both methods are easy to understand and it will help you to get rid of gridlines while editing or printing the spreadsheet in Google Sheets.

Important Notes

  • If there are Gridlines are not showing then check the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing.
  • Remember that when you remove or display gridlines in Google Sheets, it will only apply to the active spreadsheet. If you want this to apply to all worksheets, you must go to each worksheet and manually hide the gridlines by following the above steps.
  • In a specific range of Gridlines or borders, you can change the thickness and color of the border and gridlines by some border customization like border color and border style which can make your document beautiful in look and presentation and separation of data and table by a different color of rows and column.

See also  How to Underline in Google Sheets (3 Methods)

Frequently Asked Questions

Why do we need to Hide Gridlines?

As we know that Google Sheets is a spreadsheet software in which we make tables, bills, reports, etc. for which separation of sales is necessary so that our data may look good, therefor there are lines by default in Google sheets which are called Gridlines. But in some cases, we don’t these lines it depends on the type of data that you are creating in Google Sheet If you doing any work including some graphics then there is Gridlines are unnecessary which makes our data presentation poor so that we need to remove Gridlines which we can easily do by following some steps which we have learned so far.

Conclusion

Google Sheets has countless features in it and there are a lot more things to learn. In this article, we learned how to show and hide gridlines in google sheets. After a detailed study, we have a much better picture of what are Gridlines and How to Show/Remove Gridlines in Google Sheets in different possible situations and scenarios. We also get to know the need and importance of learning this article which explains why and when we need to show or remove gridlines in Google Sheets. If you studied this article you are ready to practically apply the Gridlines concept for your advantage for your data presentation as you need the above-given instructions.

I hope you find this article helpful. To explore more about other useful and exciting features of Google Sheets, keep learning with Office Demy. Thank you!

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general