Gridlines are lines that separate the cells and columns throughout the worksheet. They are seen around the cells in a worksheet. Sometimes, when working with data on the worksheet, you may want to seclude a part of the worksheet, by hiding other guidelines to emphasize the separated part of the data.
In this tutorial, we will discuss and learn how to remove, add and show gridlines in Google Sheets and also how to hide gridlines when you want to print the data.
How To Hide Gridlines in the Worksheet in Google Sheets.
Using the worksheet below, we want to hide the gridlines of some students’ grade reports.
![1 How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/1How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 1: Select the cell range of data you want to hide the gridlines. If you want to hide all gridlines in the entire sheet, click on the grey box on the top left corner of the worksheet.
![2How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/2How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 2: Navigate to the toolbar and click on View.
![3How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/3How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 3: In the drop-down menu displayed, search and select Show.
![4How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/4How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 4: Other options are displayed, select Gridlines.
![5How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/5How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
This would hide the gridlines of the selected cell range or the entire worksheet.
![6How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/6How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Note that this method acts as a toggle switch. If you want to add or show the gridlines, you follow the steps above too.
How To Hide Gridlines in Google Sheets when Printed.
In case you want to print out your worksheet with the gridlines and not have the grid lines printed in the final result, Google sheets has a way of achieving this and it is done in these quick and easy steps.
Step 1: Select the cell range or the entire worksheet you want to be printed.
Step 2: Navigate the File option on the toolbar.
![7How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/7How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 3: From the drop-down menu displayed, search and select Print. Alternatively, you can use the shortcut key on the keyboard, Ctrl key + P.
![8How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/8How-To-Hide-And-Show-Gridlines-In-Google-Sheets-701x1024.jpg)
Step 4: The Print settings tab is opened. Click on the Formatting options.
![9How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/9How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 5: Untick the “Show Gridlines“.
![10How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/10How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 6: Click on Next.
![11How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/11How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
The printed worksheet has its gridlines hidden or removed.
![12How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/12How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
How To Show Gridlines in Google Sheets.
For instance, you want to show some gridlines in a particular area in your worksheet and hide it in the remaining areas. It can be done in the following steps.
Step 1: Select the cell range of data you want to show the gridlines. If you want to show all gridlines in the entire sheet, click on the grey box on the top left corner of the worksheet.
![13How To Hide And Show Gridlines In Google Sheets 1](https://abidakon.com/wp-content/uploads/2022/05/13How-To-Hide-And-Show-Gridlines-In-Google-Sheets-1.jpg)
Step 2: Navigate to the toolbar and click on the Border Style icon.
![14How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/14How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
Step 3: Select and apply the border of the cell range where you want the gridlines added.
![15How To Hide And Show Gridlines In Google Sheets](https://abidakon.com/wp-content/uploads/2022/05/15How-To-Hide-And-Show-Gridlines-In-Google-Sheets.jpg)
The border-style is added to the hidden cells. This would show the gridlines of the selected cell range or the entire worksheet.
Final Thoughts.
This is an important tool for highlighting and separating important parts of the data set for better viewing and analysis. Now you know How To Hide And Show Gridlines In Google Sheets. I hope you found this review helpful. Thanks for reading.