How To Remove Borders In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to remove borders in google sheets.

If you’ve ever worked on a Google Sheet file that’s been around a while, you know that sometimes formatting can build up in a file. Often remnants of past formatting remain in the spreadsheet long after it’s useful, making it hard to continue working in the file. If this happens to a spreadsheet you’re working on, don’t worry, it’s quick and easy to remove borders in Google Sheets. Read on to learn how.

Removing Borders

If you want to remove only cell borders and maintain all other formatting, follow these steps:

Step 1

Select the cells you want to remove the borders from

Step 2

Click on the Borders icon in the toolbar and choose the Clear Borders icon, which is a grid with all dotted lines

Step 3

All borders on any cell in the selection will be removed


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to remove borders in google sheets. Want more? Check out all the Google Sheets Tutorials.