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.
This will be at the top of the workbook. Pressing View will bring up a dropdown of view options.
By default, gridlines will have a check mark beside it, simply click Gridlines to uncheck it.
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.
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:
Don’t worry if all lines disappear from your workbook, we will be putting new ones back.
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.
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.
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.
-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
-Add Line Break in Google Sheets
-Color Every Other Row in Google Sheets
We hope this article has helped you and given you a better understanding of how to remove gridlines in Google Sheets. You might also like our articles on how to enable dark mode for Google Sheets and how to fill down in Google Sheets.
To optimize your workflow, we recommend reading our guide on how to send an email from Google Sheets based on a cell value and trying our software for dental appointment reminders.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
