In this article we will show how to remove gridlines in Google Sheets, as well as how to show them and how to get rid of them from only specific cells.
How to Get Rid of Gridlines in Google Sheets
1. Go to View in the File Menu at the top of the page
This will be at the top of the workbook. Pressing View will bring up a dropdown of view options.
2. Select Show and uncheck Gridlines
By default, gridlines will have a check mark beside it, simply click Gridlines to uncheck it.
3. Gridlines have now been removed from your Google Sheet
It will only leave the borders on your cells and its other contents/formatting. As we can see in our example below, all lines apart from the borders of our table in B2 to D11 are no longer there.
Tip: To bring the gridlines back, simply return to View>Show and recheck Gridlines.
How to Remove Gridlines from Certain Cells
Unfortunately, Google Sheets does not yet have the capacity to remove gridlines from specific cells only.
However if we want our workbook printouts to look like we only have gridlines on specific cells, follow these instructions:
1. Remove your gridlines by going to View>Show and unchecking Gridlines
Don’t worry if all lines disappear from your workbook, we will be putting new ones back.
2. Select the areas you want to have gridlines on.
Simply drag along your dataset to select. To add a new isolated selection, hold COMMAND on Mac or CTRL on Windows before selecting your required cells.
3. Click the Border Icon in the Format Menu and add All Borders.
This will add a border to our selected area around each individual cell like gridlines would.
Tip: You can use gray as your border color instead of black to make the lines look more subtle.
4. Now only selected cells will have gridlines around them.
As you can see in our example, only cells between B2:C14 and E2:F6 have gridlines. You can print this worksheet and only these lines will appear on your printout.
Other Google Sheets Formatting Articles
-Print Gridlines in Google Sheets
-How to Strikethrough in Google Sheets
-How to Underline in Google Sheets
-How to Hyperlink in Google Sheets
-How to Add Bullet Points in Google Sheets
-How to Indent in Google Sheets
-Google Sheets Dark Mode
-Add Line Break in Google Sheets
-Word Count in Google Sheets
-Color Every Other Row in Google Sheets