How To Apply All Borders 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 divide the data in borders from the rest of the text, information technology is a good way of representation of information and information technology helps the user to easily await for a specific data, borders are available in habitation tab in the fonts section.

Explained

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

Borders assist to present the set of data in a more presentable format in excel Formatting is a useful feature in Excel that allows you to alter the appearance of the data in a worksheet. Formatting tin can be done in a diversity of ways. For example, nosotros tin apply the styles and format tab on the domicile tab to alter the font of a cell or a tabular array. read more .

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

It tin can be used to ascertain 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 link Article Link to be Hyperlinked
For eg:
Source: Border in Excel (wallstreetmojo.com)

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

We tin create and add the borders to the specific ready of data.

Example #one

We have data of marks of a student for three subjects of an annual exam. In this information, we will have to add together the borders to make information technology more than presentable

At present, select the information to which you want to add borders.
Now,In the Font group on the Dwelling house tab, click the down arrow next to the Borders button, and yous will meet the drop-down list of borders as shown in the figure beneath.
Now, you have different borders styles; select the OUTSIDE BORDERS option for your data.
Now, notice the result by using OUTSIDE BORDERS to the data.

Now let usa learn with some more examples.

Example #2

We accept information of marks of a student for 3 subjects of an annual test. 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 beneath:

At present, select the data to which y'all want to add borders.

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

At present y'all have unlike borders styles, select the THICK Outside BORDERS option for your data.

Now, find the result by using THICK Outside BORDERS to the data as follows.

Case #3

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

Information of marks of five students for 3 subjects in an annual test are shown beneath:

Now, select the data to which you desire to add borders.

Now,In the Font group on the Home tab, click the downwards arrow next to the Borders button, and you will see the drop-down list of borders equally shown in the effigy below. Select ALL BORDERS options for the data.

Now, find the issue by using ALL BORDERS to the data.

Example #4

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

Data of marks of 5 students for three subjects in an almanac examination are shown below:

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

At present,In the Font grouping on the Home tab, click the down arrow next to the Borders push, and you will encounter the drib-down list of borders as shown in the figure beneath.Select ALL BORDERS options for your data.

At present, find the event by using ALL BORDERS to the information.

We tin 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 desire to change the thickness of the edge.