How to Remove Borders in Google Sheets

Last updated on May 21st, 2023 at 12:24 am

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 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.

See also

Join Our Free Newsletter

Featured guides and deals

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

Newest Guides