What Is Border In Google Sheets?
Borders in Google sheets, as the name suggests, is a method to represent data in a better way using borders. Just like Microsoft Excel, we can use border in Google sheets to highlight and present our data effectively.
Using borders in Google sheets is easily and simple. We can simply select the cells which we want to highlight or present with border and can also customize the border line and color with the help of the border option. For example, consider the below table showing values in Google sheets.
Now, let us add border to the data in Google sheets. To begin with, select the cell range and click on Border option and choose All border. We will be able to see the border for the selected cell range in Google sheets, as shown in the below image.
In this article, let us learn how to add, customize and remove border in Google sheets with detailed examples.
Key Takeaways
- Border in Google sheets helps users present the data effectively with proper organization.
- It is useful not only to organize but to show a differentiation between the data.
- There are 10 different border styles in Google sheets.
- To add borders, simply select the cell, cell range or the sheet and click on Borders option in the menu.
- Similarly, to remove the borders in Google sheets, we need to click on the Clear Border option under the Borders option in the Menu.
How To Create And Add Borders In Google Sheets?
We can create and add borders in Google sheets for the whole sheet or a particular cell or cell range with the help of the following steps.
Create Borders In The Whole Sheet
The steps to insert or add borders in Google sheets (in the whole sheet) are:
Step 1: To begin with, open Google sheets. Open a blank spreadsheet.
Step 2: Next, press Ctrl + A. Select the whole sheet.
Step 3: Then, click on the Borders option in the Menu. It is as shown below.
Step 4: In the list of options available under Borders, select any border option to add in the sheet.
We will be able to see the border in whole sheet.
Likewise, we can add border.
Create Borders In A Particular Cell Range
The steps to insert or add borders in Google sheets (in a particular cell range) are:
Step 1: To begin with, enter the data we want to include in the sheet. Next, we need to select the cell range.
Step 2: Next, click on the Borders option in the Menu.
Step 3: In the list of options available under Borders, select any border option to add in the sheet.
We will be able to see the border only in the particular cell range.
Likewise, we can add border in Google sheets.
Types Of Borders Available In Google Sheets
We can customize and create any type of border. But, there are 10 types of borders available in Google sheets.
They are:
- All Borders
- Inner Borders
- Horizontal Borders
- Vertical Borders
- Outer Borders
- Left Border
- Top Border
- Right Border
- Bottom Border
- Clear Borders
Based on the data and the requirements, we can use any border type with different colors and border style.
Examples
Let us learn how to add, customize and remove border with the following detailed examples.
Basic Example – Add Borders In Google Sheets
For example, consider the below table showing name and age in columns A and B, respectively.
Now, let us learn how to add borders in Google sheets with the help of the following steps.
The steps to insert or add borders in Google sheets (in a particular cell range) are:
Step 1: To begin with, enter the data we want to include in the sheet. Next, we need to select the cell range.
Step 2: Next, click on the Borders option in the Menu.
Step 3: In the list of options available under Borders, select any border option to add in the sheet. In this example, let us select All Borders.
We will be able to see the border only in the cell range A1:B2, as shown in the below image.
Likewise, we can add border.
Example #1 – Customize The Border In Google Sheets
For better understanding, let us use the same example we used in basic example.
Consider the below table showing name and age in columns A and B with borders, respectively.
Now, let us learn how to customize borders in Google sheets with the help of the following steps.
The steps to customize or personalize borders in Google sheets (for the already created borders in Google sheets) are:
Step 1: To begin with, we need to select the data range with borders in the spreadsheet. In this example, the data is available in the cell range A1:B2.
Step 2: Next, click on the Borders option in the Menu. Here, select Border Color option.
Step 3: We will be able to see the color palette in Google sheets.
Step 4: Now, we need to choose a desired color. In this example, let us choose green color.
Step 5: Select the border ‘All Border’ style once again.
We will be able to see the border color in the cell range.
Step 6: Similarly, we can also change the border style. To change the border style, simply click on the border style option and click on the borders available in the list, as shown in the below image.
Step 6: Let us select the thick border style.
So, the final look appears as shown in the below image.
Likewise, we can customize border in Google sheets.
Example #2 – Remove Borders In Google Sheets
Now, assume that we need to remove the borders in the sheet. For better understanding, let us use the same example we used in Example #1.
Consider the below table showing name and age in columns A and B with customized border, respectively.
Now, let us learn how to remove borders in Google sheets with the help of the following steps.
The steps to remove borders in Google sheets (in the already added cell range or sheet with borders) are:
Step 1: To begin with, we need to select the data range with borders in the spreadsheet. In this example, the data is available in the cell range A1:B2.
Step 2: Next, click on the Borders option in the Menu. Here, select the option before Border style option, available in the second row. This option is called Clear Border.
Step 3: As soon as we click on the clear border, we will be able to remove the border in Google sheets.
We will be able to remove the border in Google sheets, as shown in the below image.
Likewise, we can remove border in Google sheets.
Example #3 – Change Borders In Google Sheets
Now, we learned how to add, customize and remove borders in Google sheets. Now, let us learn how to change the border in Google sheets using the same example we used in Example #2.
Consider the below table showing name and age in columns A and B, respectively.
Now, let us learn how to change borders in Google sheets with the help of the following steps.
Step 1: To begin with, we need to select the data range with borders in the spreadsheet. In this example, the data is available in the cell range A1:B2.
Step 2: Next, click on the Borders option in the Menu. Here, select the Right border option available in the second row.
We will be able to see the border in the right side, as shown in the below image.
Likewise, we can change border.
Important Things To Note
- Border in Google sheets is an option used to present data with borders.
- Similar to Excel, we can choose the border width, color, border style in Google sheets.
- Users can change the color of the border in Google sheets accordingly.
Frequently Asked Questions (FAQs)
For example, consider the below table showing name and age in columns A and B, respectively.
Now, let us learn how to add borders in Google sheets with the help of the following steps.
The steps to insert or add borders in Google sheets (in the particular cell range) are:
1: To begin with, open Google sheets and open a blank spreadsheet. In this example, select the cell range A1:A3.
2: Next, click on the Borders option in the Menu.
3: In the list of options available under Borders, select any border option to add in the sheet.
We will be able to see the border in the cell range, as shown in the below image.
Likewise, we can add border.
We can change colors in border using the Border color option available in the Borders option in the menu. Simply choose the desired color and select the border type to see the border color change in Google sheets.
Yes. Similar to copying the data and finding the result using AutoFill option, we can also copy the border style and color in Google sheets using AutoFill option.
Download Template
This article must help understand the Border In Google Sheets examples. You can download the template here to use it instantly.
Recommended Articles
Guide to What Is Border In Google Sheets. We learn how to create and add it and its different types in Google Sheets with step-wise examples.
Leave a Reply