How to Remove Borders in Google Sheets

Borders in a spreadsheet provide an easy visual clue about where different pieces of data are separated. It makes it easier to read the information as individual units and can help to eliminate some of the confusion that arises when you are looking at a large table of data.

But occasionally, you might be using Google Sheets for something where any existing cell borders are a distraction, such as if you have previously merged a group of those cells.

Fortunately, you are able to remove cell borders in Google Sheets in a similar way to how those borders were first added.

How to Delete Borders from Cells in Google Sheets

The steps in this article assume that you currently have a Google Sheets spreadsheet that contains some cell borders and that you would like to remove those borders.

Note that borders are different than gridlines. If you follow these steps and the borders that you want to remove are still present, then you may actually need to remove gridlines instead.

Step 1: Sign into Google Drive at and open the file containing the borders that you want to remove.

Step 2: Select the cells containing the borders that you wish to remove.

select cells with borders to remove

Step 3: Click the Borders button in the toolbar above the spreadsheet.

open border menu in google sheets

Step 4: Select the No Borders option to remove the existing cell borders.

how to remove borders in google sheets

Now that you know how to remove borders in Google Sheets, you can remove this formatting option from appearing around your cells if you no longer want it there.

As mentioned earlier, what you might actually want to remove are the gridlines. You can read this article to learn how to remove gridlines in Google Sheets if you would prefer not to have any separating lines on your sheet.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy