Arrow left
Back to product guides
Google Sheets Tips

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.

How to add borders in Google Sheets

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.

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711