How to Remove Lines in Google Sheets

Google Sheets files will display the gridlines on your screen by default when you create a new spreadsheet. Use these steps to remove lines in Google Sheets.

  1. Sign into Google Drive and open your file.
  2. Click the View tab at the top of the window.
  3. Select the Gridlines option to remove the check mark.

Our guide continues below with additional information and pictures for these steps.

Spreadsheet applications like Google Sheets use gridlines to show the physical boundaries of the cells in your sheet.

These gridlines are often preferred, and one of the more common searches concerning Microsoft Excel is how to print with those gridlines.

Google Sheets displays gridlines by default, and actually prints with them by default, too.

But if your spreadsheet’s layout is improved by removing the gridlines, then you may be wondering how to get rid of them.

Our guide below will show you how to remove lines in Google Sheets.

How to Hide Lines in a Google Spreadsheet

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will work in other desktop browsers, too.

Step 1: Sign into your Google Drive and open your Sheets file.

Step 2: Click the View tab at the top of the window.

click the View tab

Step 3: Select the Gridlines option to remove the check mark to the left of it. The gridlines in your spreadsheet should now be gone. If you go to print this sheet you will note that the gridlines are removed from the printable version as well.

how to remove lines from Google Sheets

If you still see lines after removing the gridlines, then it’s probably being caused by cell borders that were previously added.

You can remove cell borders by selecting all of the cells that contain the borders, then clicking the Borders button in the toolbar and selecting the Clear borders option.

remove borders in Google Sheets

Additional Reading