If you are trying to figure out how to turn off gridlines in Google Sheets, the fix is quick and built into the sheet view. You can hide the faint cell lines on screen, and you can also stop them from printing if that is the real problem. The steps are different depending on whether you want a cleaner workspace or a clean printout.
Turn off gridlines in a sheet
The simplest way to remove gridlines in Google Sheets is to change the view setting for the current sheet. This hides the background grid on your screen, which is useful for dashboards, reports, and formatted tables.
- Open the Google Sheet.
- Click the tab for the sheet you want to change.
- At the top, click View.
- Move to Show.
- Click Gridlines to clear the checkmark.
That setting applies to the active sheet, not the entire spreadsheet. If your workbook has several tabs, repeat the same steps on each tab where you want the lines hidden.
Use the toolbar and menu correctly
Many people search for how to get rid of grid lines on Google Sheets and miss the fact that the setting lives under the View menu. There is no separate delete command, because gridlines are not data. They are a display option, so you hide them rather than remove them.
What the setting changes
Turning gridlines off removes the faint gray borders that separate rows and columns in the editor. Your actual cell structure stays the same. Formulas, text, formatting, and borders still work normally.
What it does not change
This does not delete rows, columns, borders, or cell fills. If you still see lines after turning gridlines off, they are probably real borders added to cells, not the default gridline layer.
Stop gridlines from printing
If your question is how to not print gridlines in Google Sheets, use the print settings instead of the on screen view setting. Print gridlines are controlled separately, so a sheet can look clean on screen and still print lines, or the reverse.
- Open the sheet.
- Click File, then Print.
- In the print settings panel, look for Formatting.
- Uncheck Show gridlines.
- Adjust any other print options, then print or save the file.
This is the right fix for reports, invoices, handouts, and worksheets where you want a polished page without the default grid showing up on paper or in the PDF.
Remove borders that look like gridlines
Sometimes people ask how to get rid of gridlines in Google Sheets, but the real issue is cell borders. Borders are heavier than gridlines and can still show after you hide the default grid. If you added borders manually, you need to clear those separately.
- Select the cells, range, row, or column with the visible lines.
- Click the Borders button in the toolbar.
- Choose Clear borders.
If you want a cleaner layout without the full grid, a good approach is to hide gridlines and then add only the borders you need for headings, totals, or boxed sections.
Hide gridlines for a polished layout
Google Sheets hide grid lines is a common request for dashboards, templates, and presentation sheets. The cleanest layout comes from combining hidden gridlines with deliberate formatting, not from leaving the sheet empty and hoping the lines disappear.
Best uses for hidden gridlines
Use hidden gridlines when you are building a report, a client facing tracker, a schedule, or a form style sheet. The absence of the faint background lines makes fills, borders, and typography stand out more clearly.
Formatting that works well after hiding them
Use bold headers, light fill colors, and selective borders to define sections. If you need stronger separation, add a bottom border to header rows and keep the rest of the sheet border free.
Fix common questions and mistakes
Most questions around remove gridlines Google Sheets come from confusing display settings, print settings, and border formatting. Once you know which layer you are changing, the fix is straightforward.
Can you turn off gridlines in Google Sheets?
Yes. Open View, then Show, then clear Gridlines. That hides the sheet grid on screen for the active tab.
How do I remove gridlines in Google Sheets if they keep coming back?
Check whether you are switching sheets or reopening a file with a different tab selected. Gridline visibility is saved per sheet tab, so each tab has its own setting.
How do you remove gridlines in Google Sheets for printing only?
Use File then Print, and turn off Show gridlines in the print formatting options. That does not affect the on screen view.
How to not show gridlines in Google Sheets when sharing a link?
Sharing the file does not change the setting. The recipient sees the gridlines according to the tab’s current view state, and they can also change it on their own device.
Can you remove gridlines in Google Sheets on mobile?
Yes, but the menu path depends on the app version. In the mobile app, open the sheet settings or view options and look for gridline visibility. On desktop, the View menu is the fastest method.
Frequently Asked Questions
How to delete gridlines in Google Sheets?
You do not delete them. Gridlines are a display setting, so you hide them through View then Show then Gridlines.
In Google Sheets, how do you delete grid lines?
Use the same method as above. Clear the gridlines checkmark in the View menu for the sheet you are editing.
Google Sheets how to get rid of gridlines and keep my borders?
Hide gridlines in the View menu, then leave your manual borders in place. The grid disappears, but any borders you added stay visible.
Google Sheets how to remove gridlines from one sheet only?
Open that sheet tab and change the gridline setting there. The setting applies per tab, not to every sheet in the file at once.
How to clear gridlines in Google Sheets before printing a PDF?
Go to File, then Print, and uncheck Show gridlines in the formatting options before saving as PDF.
Related Posts:
Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to Round Numbers in Google Sheets
- How to Add a Header Row in Google Sheets
- How to Change Cell Color With a Formula in Google Sheets
- How to Insert a Checkbox in Google Sheets
- How to Make a Graph in Google Sheets
- How to Subtract in Google Sheets
- How to Insert a Hyperlink in Google Sheets
- How to Insert Multiple Columns in Google Sheets
- How to Convert Google Sheets to PDF
- How to Insert or Remove Page Breaks in Google Sheets
- How to Use COUNTIF in Google Sheets
- How to Resize Cells to Fit Text in Google Sheets
- How to See Edit History in Google Sheets
- How to Delete Multiple Google Sheets at Once
- How to Edit a Pivot Table in Google Sheets
- How to Use VLOOKUP and XLOOKUP in Google Sheets
- How to Export Google Sheets to CSV (and Import One)
- How to Sort by Date in Google Sheets
- How to Change Cell Width in Google Sheets
- How to Sort in Google Sheets (A to Z, by Column)
- How to Alphabetize in Google Sheets
- How to Link Google Sheets to Google Calendar
- How to Add Bullet Points in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Highlight Cells and Rows in Google Sheets
- How to Sort Numbers in Order in Google Sheets
- How to Rename a Column Header in Google Sheets
- How to Insert Multiple Rows in Google Sheets
- Google Sheets Formulas: The Essentials With Examples