How To Add Borders In Google Sheets

In this tutorial, you will learn how to add borders in Google Sheets.

How To Add Borders In Google Sheets

Cell borders are useful for a number of purposes in Google Sheets.

They can help distinguish between data sets, emphasize particular regions of a spreadsheet, guide the user to input fields, or simply make a spreadsheet look more professional.

Whatever your reason for using cell borders, Google sheets has a number of different cell border options that make it easy to add the borders you want to your data.

Adding Cell Borders in Google Sheets

You can add borders to an individual cell or to a range of any size.

Adding borders to an entire range allows you to quickly create borders around a table or region in your spreadsheet, while adding borders to individual cells lets you emphasize individual cells or fine tune the exact look you want.

To add borders to a range or cell, follow these steps:

Step 1

Select the range or cell you want to add borders to

Step 2

In the toolbar, click on the borders icon and a small menu will open with icons for the different border options.

Hover over each to see a tooltip description for each option then choose the type of border you want to add to the cell or range

Step 3

To change the border color, click on the pencil icon in the upper right corner of the borders menu and choose a color from the color picker that appears

Step 4

To change the border style, click on the icon in the lower right corner of the borders menu and choose a border style from the menu that appears

Removing Borders

If you want to remove a border from a cell or range, simply follow these steps:

Step 1

Select the cell or range you want to remove borders from

Step 2

Click on the borders icon to open the borders menu, then select the Clear Borders option next to the border style menu icon

Any borders will disappear from the selected cell/range

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

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

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.