Gridlines are something that makes data look good in Google Sheets.
By default, Gridlines are already applied to all the cells in Google Sheets. But sometimes, you may only want to have these gridlines (or borders) on some specific cells or rows/columns and not everywhere.
In this tutorial, I will show you how to hide gridlines in Google Sheets and how to make them appear while printing.
How to Get Rid of Gridlines in Google Sheets
- Open your spreadsheet
- Go to View > Show from the toolbar
- Uncheck the option Gridlines.
Hide the Gridlines in Google Sheets
Below are the steps to hide gridlines from the entire worksheet in Google Sheets:
- Open the worksheet in which you want to hide the gridlines
- Click the View option in the menu, then click on Show.
- Click the Gridlines options. This will uncheck this option and remove gridlines from the entire worksheet.
The gridlines option in the View tab is a toggle option. This means that if you want the Gridlines to come back again, you need to go back to this option and click on it.
Also, note that when you show or hide gridlines in Google Sheets, it’s only applied to the sheet that is active. If you want this to be applied to all the worksheets, you will have to go to each sheet and hide the gridlines manually.
In case you want to show gridlines only in a specific range and not in the entire worksheet, first remove the gridlines using the steps above, and then apply the border to the selected range of cells using the below steps:
- Select the range of cells where you want to have a gridline
- Click the Borders icon in the toolbar
- Click on the Borders icon to apply a border to all the selected cells.
How to Get Rid of Gridlines from Certain Cells in Google Sheets
Although there’s no direct way to get rid of gridlines from certain cells in Google Sheets, here’s what you can do:
- Select the cells you want to have gridlines.
- Go to the border icon.
- Select the first border.
- Go to View > Show in the toolbar.
- Uncheck the Gridline option.
This will remove cell lines in Google Sheets from the specific cells you did not select.
Related: Insert Page Breaks Google Sheets
Show/Hide Gridlines While Printing
When you have gridlines in the worksheet in Google Sheets, and you print that worksheet (or a part of that worksheet), you’ll notice that it also prints the gridlines.
If you don’t want the gridlines to be printed, you have an option to disable it.
Below are the steps to print a range in Google Sheets while hiding the gridlines:
- Select the range of cells that you want to print
- Click the File option in the menu
- Click the Print option (you can also use the keyboard shortcut – Control + P)
- In the Print settings screen, click on the Formatting drop-down and uncheck the ‘Show Gridlines’ option
- Click Next and Print.
The above steps would hide the gridlines from the selected range of cells. If you want to show the gridlines, make sure this option is checked. You can also set the print area here.
However, in case you have applied a border to the range of cells you want to print, you can’t remove it from the Print screen. If you don’t want the border to be printed, you need to go back to the worksheet and remove it.
If you found this article helpful, you can also check out how to unhide rows in Google Sheets.
You may also like the following Google Sheets tutorials:
- How to Indent Text in Google Sheets
- How to Wrap Text in Google Sheets
- How to Change Row Height in Google Sheets
- How to Hide Columns in Google Sheets
- How to Hide Zero Values in Google Sheets
- How to Insert a Page Break in Google Sheets
- How to Freeze Rows in Google Sheets