Are you looking to make your spreadsheet more visible and appealing? Adding borders in Google Sheets is a simple way to achieve that. In this article, you will learn how to add borders in Google Sheets and enhance the overall look of your data.
What are Borders in Google Sheets?
Borders in Google Sheets are lines that can be added to cells or ranges of cells to create visual separation between them. Borders are a formatting option that can be applied to cells, columns, rows, or a range of cells. There are different types of borders available, and you can change their color and thickness according to your preference.
Why Add Borders in Google Sheets?
There are several reasons why you might want to add borders in Google Sheets:
-
Improved Readability: Borders can help separate different sections of data, making it easier to read and interpret. Additionally, adding borders can give your spreadsheet a more professional and sophisticated look.
-
Highlighting Important Information: You can use borders to draw attention to specific cells or ranges of cells that contain important information.
-
Facilitate Data Entry: Borders can be used to highlight cells where you need to enter data, combined with other Excel features such as font color and cell fill color.
How to Create a Border in Google Sheets
Here’s how you can add cell borders in Google Sheets. Please refer to the screenshot below for guidance.
-
Open your Google Sheets.
-
(After entering your content) Select the range to which you want to add a border.
-
Click on the “Borders” icon in the toolbar.
-
If you want to change the color and/or style of the border, click on the border color icon and/or the border style icon in the detailed menu.
-
Choose a border pattern that you want to apply to the selected range.
For better understanding, let’s see an example of a design change, transforming the top table into a more visually appealing one with borders in the image above.
-
Select cell D2 and choose “Outer Border.”
-
Select the range B6 to H6 and choose “Top Border” and “Bottom Border.”
-
Finally, select the range B4 to H4, change the border style to bold first, and then choose “Bottom Border.”
Don’t you think the table looks more beautiful and easier to follow?
If you don’t like the border you applied, simply remove them with the “Undo” function in the top-left corner.
When you can’t use the “Undo” function (for example, when you make many changes after adding borders), you can choose the “Erase Border” pattern and apply it to a selected range.
How to Create White Borders in Google Sheets?
To add white borders to your desired cells:
-
Select the cells to which you want to add white borders.
-
Go to the toolbar, click on the “Borders” icon.
-
Click on the “Border Color” icon (top-right icon among the options), choose white from the color list.
-
Select one of the border patterns from the list and click on it.
How to Create Thick Borders in Google Sheets?
To add thick borders to your desired cells:
-
Select the cells to which you want to add thick borders.
-
Go to the toolbar, click on the “Borders” icon.
-
Go to the toolbar, click on the “Border Style” icon (bottom-right icon among the options), choose the third line from the top.
-
Select one of the border patterns from the list and click on it.
That’s it! Now you know how to add borders in Google Sheets to make your tables more appealing and easier to read. Feel free to experiment with different border colors and styles to find the one that suits your spreadsheet best.
For more tips and tricks on Google Sheets and other productivity tools, visit Crawlan.com.
