How to Add Borders in Google Sheets

Would you like to make your table more visible and beautiful? It’s not difficult to do at all.

‍

How do you make a border in Google Sheets?

Here is the answer to how to add cell borders in Google Sheets. Please refer to the screenshot below while reading.

1. Open your Google Sheets.
2. (After you input your content), select a range you would like to draw a border.
3. Click the “Borders” icon in the toolbar.
4. If you want to change border color and/or style, please click the border color icon and/or the border style icon in the detailed menu.
5. Choose a pattern of a border you would like to apply to the selected range.

‍

For your better understanding, let’s see the example of a design change, turning the upper table to the lower table, a more beautiful table with borders in the above picture.

1. Select cell D2 and choose “Outer Border”.
2. Select B6 to H6, and choose “Top Border” and “Bottom border”.
3. Finally, select cell B4 to H4, change the border style to a bold one first, and then choose “Bottom border”.

Don’t you think that the table looks more beautiful and easier to follow?

Don’t like the border you applied? Just clean them up with the “Undo” function in the top left corner.

When you can’t use the “Undo” function (for example, when you make a lot of changes after you added borders), you can choose the “Clear border” pattern and apply it to a selected range.

‍

How do I make white borders in Google Sheets?

1. Select cells you want to add white borders.
2. Go to the toolbar, click the “Borders” icon.
3. Click the “Border color” icon (top right icon among the options), choose white from the list of colors.
4. Select one of the border patterns from the list and click it.

‍

How do you make thick borders in Google Sheets?

1. Select cells you want to add thick borders.
2. Go to the toolbar, click the “Borders” icon.
3. Go to the toolbar, click the “Border style” icon (bottom right icon among the options), choose the third line from the top.
4. Select one of the border patterns from the list and click it.

‍

Other formulas and tips related to cell formatting

If you don’t get the correct answer to your question in this article or have other questions related to cell formatting, you may find the answers in the following articles.

How to Round Numbers in Google Sheets - round numbers with formulas

How to Show Gridlines in Google Sheets - show/delete gridlines

How to Color Cells in Google Sheets - fill in cells with color

How to Merge Cells in Google Sheets - combine cells

‍

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

‍

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.