Border in Excel

What are the Borders in Excel?

Border in excel are outlined to data tables or specific range of cells in excel, borders are used to separate the data in borders from the rest of the text, it is a good way of representation of data and it helps the user to easily look for a specific data, borders are available in home tab in the fonts section.

Explained

The border can be added to a single cell or multiple cells. Borders are of different styles & can be used as per the requirement.

Borders help to present the set of data in a more presentable format in excelFormat In ExcelFormatting is a useful feature in Excel that allows you to change the appearance of the data in a worksheet. Formatting can be done in a variety of ways. For example, we can use the styles and format tab on the home tab to change the font of a cell or a table.read more.

Borders can be used for tabular format data or headlines or to emphasize a specific set of data or can be used to distinguish different sections.

  • It can be used to define or divide the sections of a worksheet.
  • It can be used to emphasize specific data.
  • It can also be used to make the data more understandable & presentable.

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Border in Excel (wallstreetmojo.com)

How to Create and Add Borders in Excel? (with Examples)

We can create and add the borders to the specific set of data.

Example #1

We have data of marks of a student for three subjects of an annual examination. In this data, we will have to add the borders to make it more presentable

  1. Now, select the data to which you want to add borders.


    border in excel example 1.2

  2. Now,In the Font group on the Home tab, click the down arrow next to the Borders button, and you will see the drop-down list of borders as shown in the figure below.


    border in excel example 1.3

  3. Now, you have different borders styles; select the OUTSIDE BORDERS option for your data.


    border in excel example 1.4

  4. Now, find the result by using OUTSIDE BORDERS to the data.


    border in excel example 1.5

Now let us learn with some more examples.

Example #2

We have data of marks of a student for three subjects of an annual examination. In this data, we will have to add the borders to make it more presentable.

  • Data of marks of 5 students for three subjects in an annual examination are shown below:
border in excel example 1.1
  • Now, select the data to which you want to add borders.
border in excel example 1.2
  • Now, In the Font group on the Home tab, click the down arrow next to the Borders button, and you will see the drop-down list of borders as shown in the figure below.
border in excel example 1.3
  • Now you have different borders styles, select the THICK OUTSIDE BORDERS option for your data.
border in excel example 2.1
  • Now, find the result by using THICK OUTSIDE BORDERS to the data as follows.
border in excel example 2.2

Example #3

We have data of marks of a student for three subjects of an annual examination. In this data, we will have to add the borders to make it more presentable

  • Data of marks of 5 students for three subjects in an annual examination are shown below:
border in excel example 1.1
  • Now, select the data to which you want to add borders.
border in excel example 3.1
  • Now, In the Font group on the Home tab, click the down arrow next to the Borders button, and you will see the drop-down list of borders as shown in the figure below. Select ALL BORDERS options for the data.
border in excel example 3.2
  • Now, find the result by using ALL BORDERS to the data.
border in excel example 3.3

Example #4

We have data of marks of a student for three subjects of an annual examination. In this data, we will have to add the borders to make it more presentable.

  • Data of marks of 5 students for three subjects in an annual examination are shown below:
Student data
  • Now, select the data to which you want to add borders.
select data
  • Now, In the Font group on the Home tab, click the down arrow next to the Borders button, and you will see the drop-down list of borders as shown in the figure below. Select ALL BORDERS options for your data.
select option example 3.2
  • Now, find the result by using ALL BORDERS to the data.
all borders example 3.3
  • We can change the thickness of the border as per the requirement, as shown in the figure below; for this, select the data for which you want to change the thickness of the border.
border in excel example 4.1
  • Now go to the border drop-down list & click on LINE STYLE.
select line style example 4.2
  • Now, you will get a list of styles of the line & use the style as per the requirements. Use the second last line style for your data.
line style example 4.3
  • Find the result below.
line style result example 4.4

Things to Remember While Creating Borders in Excel

  1. Need to select cells where the border is to be added.
  2. Border differentiates the data separately.
  3. We can change border styles by border icon in Font Tab.

Recommended Articles

This has been a guide to Borders in Excel. Here we discuss how to create/add cell borders in excel using different options along with examples. You may also look at these useful functions in excel –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *