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.
Hide the Gridlines in Google Sheets
Below are the steps to hide gridlines from the entire worksheet in Google Sheets:
- Activate the worksheet in which you want to hide the gridlines
- Click the View option in the menu
- Click the Gridlines options. This will uncheck this option and remove gridlines from the entire worksheet.
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.
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 option 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.
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.
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