How to Add Borders in Google Sheets

Customizing the appearance of your spreadsheet cells can be helpful in making some of your data stand out more. One way to accomplish this is by learning 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 (even merged ones) 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 put borders around your cells in Google Sheets.

How to Add Borders in Google Sheets

  1. Open your spreadsheet.
  2. Select the cells to which you want to add borders.
  3. Click the Borders button, then choose a border type.
  4. Adjust the border properties with the options at the right side of the menu.

Our article continues below with additional information on adding borders in Google Sheets, including pictures for these steps.

How to Put Borders Around Cells in Google Sheets (Guide with Pictures)

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

This article is specifically about adding borders, which are a separate element from the gridlines that are shown on new, blank spreadsheets.

If your gridlines aren’t visible then you can show them by clicking the View tab, then selecting the Gridlines option. This also controls whether or not the gridlines are included if you print the spreadsheet.

Borders will print by default. If you selected white borders and your cell fill color is also white, then it will seem like the gridlines are hidden.

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.

See also

solveyourtech.com newsletter

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