What are the Borders in Excel?

Explained

We can add the border to a single cell or multiple cells. Borders are of different styles and can be used as per the requirement.

Borders help present the data set in a more presentable format in Excel Format 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.

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

  • We can use it to define or divide the sections of a worksheet.We can use it to emphasize specific data.We can also make the data more understandable and presentable.

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

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

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

Example #1

Now, let us learn with some more examples.

  • Now, we must select the data we want to add to the borders. In the font group on the “Home” tab, click the down arrow next to the “Borders” button. You may see the drop-down list of borders, as shown in the figure below. We have different borders styles. Therefore, we may select the “OUTSIDE BORDERS” option for our data. We may find the result by using “OUTSIDE BORDERS” in the data.

Example #2

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

  • Data of marks of 5 students for three subjects in an annual examination is shown below.

  • Now, we must select the data we want to add to the borders.

  • Now, in the “Font” group on the “Home” tab, we need to click the down arrow next to the “Borders” button. As shown in the figure below, we may see the drop-down list of borders.

  • Now that we have different border styles, we must select the “THICK OUTSIDE BORDERS” option for data.

  • As a result, we may find the result by using “THICK OUTSIDE BORDERS” to the data shown below.

Example #3

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

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

  • Now, in the “Font” group on the “Home” tab, we may need to click the down arrow next to the “Borders” button. And we may see the drop-down list of borders as shown in the figure below. Then, select the “ALL BORDERS” options for the data.

  • As a result, we may find the result by using “ALL BORDERS” to the data.

Example #4

We have data on the marks of a student for three subjects of an annual examination. We need to add the borders in this data to make it more presentable.

  • Now, we must select the data we want to add borders.

  • Now, in the “Font” group on the “Home” tab. Then, we need to click the down arrow next to the “Borders” button. As shown in the figure below, we may see the drop-down list of borders. Now, select the “ALL BORDERS” options for our data.

  • We may now find the result using “ALL BORDERS” in the data.

  • As shown in the figure below, we can change the border’s thickness per the requirement. Select the data you want to change the border’s thickness for this.

  • We need to go to the border drop-down list and click “LINE STYLE.”

  • Now, we get a list of line styles and use the style as per the requirements. We will use the second last line style for our data.

  • We may get the result as shown below.

Things to Remember While Creating Borders in Excel

  • We select cells where the border needs to be added.The borders differentiate the data separately.We can change border styles by the “Borders” icon in the “Font” tab.

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

  • Borders in VBA ExcelVBA Select CellShortcut for Excel Format PainterFormat Number in VBAMarksheet in Excel