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:
Select the range or cell you want to add borders to
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
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
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
If you want to remove a border from a cell or range, simply follow these steps:
Select the cell or range you want to remove borders from
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
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.