How to Add Borders in Google Sheets

As someone who relies on Google Sheets to keep my life organized, adding borders to my sheets is a game-changer. Not only does it make my spreadsheets look more polished and professional, but it also makes it easier to navigate and read data. Here's how to add borders in Google Sheets in just a few easy steps:

Step 1: Select the Cells You Want to Add Borders to

The first step is to select the cells you want to add borders to. You can select a single cell, multiple cells, or an entire column or row. Simply click and drag your mouse over the cells you want to include.

Step 2: Click on the Borders Icon in the Toolbar

Next, click on the Borders icon in the toolbar. It looks like a square with four lines around it. When you click on it, a dropdown menu will appear with options for adding borders to your cells.

Step 3: Choose Your Border Style and Color

From the dropdown menu, you can choose which border style and color you want to apply to your cells. You can select a solid line, dashed line, or dotted line, as well as change the color of the border. If you want to remove a border, simply click on the "None" option.

Step 4: Apply Your Borders

Once you've selected your border style and color, click on the edge of the cells where you want to apply the border. You can add borders to the top, bottom, left, or right edge of your cells by clicking on the corresponding icon in the dropdown menu. You can also add borders to all edges of your cells by clicking on the "All borders" option.

Step 5: Customize Your Borders Further (Optional)

If you want to customize your borders further, you can do so by clicking on the "Borders" option at the bottom of the dropdown menu. This will bring up the "Borders" dialog box, where you can choose which edges you want to apply the border to and adjust the thickness of the border.


Adding borders in Google Sheets is a simple and effective way to make your spreadsheets stand out. By following these steps, you can customize the look of your sheets and make them easier to read and navigate. So go ahead and give it a try - your inner spreadsheet nerd will thank you!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.