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.
Step 3: Click the Borders button in the toolbar above the spreadsheet.
Step 4: Select the No Borders option to remove the existing cell borders.
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
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.