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. 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 https://drive.google.com/drive/my-drive 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

 

 

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.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.