How Do I Add A Border In Excel

Excel Borders (Table of Contents)

Borders in Excel
How to add Borders in Excel?

Borders in Excel

Borders are the boxes formed past lines in the jail cell in Excel. Past keeping borders, nosotros tin can frame whatever information and provide them with a proper define limit. To distinguish specific values, outline summarized values or separate data in ranges of cells; you can add together a edge around cells.

How to add Borders in Excel?

Calculation borders in Excel is very easy and useful to outline or separate specific data or highlight some values in a worksheet. Normally, we can easily add all top, bottom, left, or right borders for selected cells in Excel. Option for Borders is bachelor in the Home menu, under the font department with the icon of Borders. We can also use shortcuts to apply borders in Excel.

You can download this Borders Excel Template here – Borders Excel Template

Let's understand how to add Borders in Excel.

Example #1

For accessing Borders, become to Dwelling house and select the selection as shown in the below screenshot under the Font section.

Once we click on the pick of Borders shown above, we will have a list of all kind of borders provided by Microsoft in its drop-down choice, equally shown below.

Hither nosotros take categorized Borders into four sections. This would be piece of cake to understand because all sections are different from each other.

The outset section is a basic section with only Bottom, Top, Left, and Correct Borders. Past this, we can only create i side border only for ane cell or multiple cells.

The second section is the full border section, which has No Border, All Borders, Outside Borders, and Thick Box Borders. By this, nosotros tin can create a full edge that can cover a cell and a table equally well. We can also remove the border as well from the selected jail cell or tabular array by clicking on No Border.

The third section is a combination of the bottom borders, Lesser Double Border, Thick Bottom Border, Top and Bottom Border, Peak and Thick Bottom Border, and Top Double Bottom Border.

These types of double borders are majorly used in underlining the headlines or important texts.

The Fourth section has a customized edge section, where we can draw or create a edge as per our need or make changes in the existing border type. We can change the color, thickness of the border also in this department of Borders.

In one case nosotros click on the More than Borders Option at the bottom, we will see a new dialog box named Format Cells, which is a more than avant-garde option for creating Borders. It is shown beneath.

Case #2

We have seen the basic function and use for all kinds of borders and how to create those in the previous example. Now we will see an example where we volition cull and implement different Borders and encounter how those Borders in whatever tabular array or data can be framed.

We have a data table, which has details of Owner, Block, and Flat No. Now we will frame the Borders and see how the information would await similar.

As row 2 is the headline, we volition prefer a double bottom line selected from the tertiary section.

And all cell will be covered with a box of All Borders which can exist selected from the 2d section.

And if nosotros select Thick Border from the second section, so the whole tabular array volition be leap to a perfect box, and selected data will automatically get highlighted. Once nosotros are washed with all the mentioned border type, our table would like this, every bit shown below.

Equally we can see, the consummate data tabular array is getting highlighted and ready to be presented in whatsoever form.

Case #iii

There is some other way to frame borders in excel. This is one of the shortcuts of accessing the functions available in excel. For accessing borders, the shortcut way first selects the information we want to frame with borders and then press ALT + H + B simultaneously to enable the border card in Excel.

ALT + H will enable the Abode menu, B will enable the borders.

Once we do that, we volition get a listing of all kinds of borders available in excel. And this list itself volition have the specific keys mentioned to prepare for any edge as shown and circled in the beneath screenshot.

We can navigate to our required Border type past pressing the Primal highlighted in the above screenshot, or else we can use direction keys to whorl upwardly and downwards to get the desired border frame. Permit'southward use All Borders for this example by pressing ALT+H+B+A simultaneously after selecting the data table. Once we practice that, we will see the selected information is at present framed with all borders. And each cell volition be now having its own border in black lines, equally shown.

Allow'south frame 1 more than border of another type with the same procedure. Select the data first and then press ALT+H+B+T Keys simultaneously. Nosotros will run across that data is framed with Thick Borders, as shown in the below screenshot.

Pros of Print Borders in Excel

Creating the border around the desired data table makes data presentable to anyone.
Border frame in any data set up is quite useful when printing the information or pasting the data in any other file. By this, we make the data look perfectly covered.

Things to Remember

Borders can exist used with the shortcut primal Alt + H + B, which will directly take united states to the Border selection.
Giving a border in whatsoever data table is very important. We must provide the edge afterwards every work so that the information gear up tin can be bound.
E'er brand proper alignment then that one time we frame the data with a border and use information technology in different sources, the column width will be automatically prepare.

Recommended Manufactures

This has been a guide to Borders in Excel. Here we discussed how to add Borders in Excel and use shortcuts for borders in Excel forth with applied examples and a downloadable excel template. You can also go through our other suggested articles –

LEFT Formula in Excel
VBA Borders
Format Cells in Excel
Print Gridlines in Excel