How to Add Borders in Google Sheets


Separating cells in a spreadsheet is often a crucial element of making sure that your data is easy to read. Without borders the data inside different cells can quickly seem to run together, making it difficult to comprehend what you are looking at.

One way to improve this problem involves the use of the Borders tool in Google Sheets. This allows you to select a group of cells and define a border around them. You are able to choose from a few different border types, and you can even specify the color and style of the border. Continue below to see how to add borders in Google Sheets.

 

How to Put Borders Around Cells in Google Sheets

The steps in this article will have you selecting a cell, or group of cells, then choosing to put a border around those cells. This is beneficial if you want to highlight that a group of cells belong together, or when you want to include distinct lines between cells when printing.

Step 1: Sign into your Google Drive at https://drive.google.com/drive/my-drive and double-click the file to which you want to add borders.

 

Step 2: Select the cell, or cells, to which you wish to add borders.

select cells for borders in google sheets

 

 

Step 3: Click the Borders button in the toolbar above the spreadsheet, then choose the desired border format that you want to use.

how to add borders in google sheets

 

 

Step 4: Adjust the color and style of your border by clicking the Borders button above the sheet again, then clicking either the Border color or Border style button to specify how you want the border to look.

put borders around cells in google sheets

 

 

While using borders in Google Sheets can improve the readability of your data, there is another way that you can accomplish this. Find out how to print gridlines in Google Sheets so that all of the cells in your spreadsheet will have lines around them when you go to print your data.

solveyourtech.com newsletter
vintage t rex t-shirt

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