Excel - Format Borders

---

---

Borders, which act as a boundary for the valuable dataset, a rectangular box, are covered by the selected cell range. The main essential factors and crucial information written in Microsoft Excel should be enclosed by borders to improve its visibility and readability. You may format borders by changing its outline, thickness, style, border color etc. Different clusters of data defined in the specified range of cells are also outlined by the borders.

All Borders Format in Excel

You can switch to the Home tab and expand the Borders button, which lists the stack of borders.

Various Categories of Borders are listed below −

• Bottom Border
• Top Border
• Left Border
• Right Border
• No Border
• All Borders
• Outside Borders
• Thick Outside Borders
• Top and Bottom Border
• Top and Thick Bottom Border
• Top and Double Bottom Border

Draw Borders

As you can see in the above screenshot, the Draw Borders comprises a few options, such as "Draw Border", "Draw Border Grid", "Erase Border", "Line Color", and "Line Style". You can choose any option to add/remove the border and apply its styling around the dataset.

Lets suppose you select the "Draw Border" option, then cursor is turned into the pencil, and you can place the pencil to set the boundary around the cells wherever in the worksheet like this −

In this screenshot, the border is added to the cell range C4:D4 through the "Draw Border" option.

Excel Border Styles

• Thick Line
• Solid Line
• Dotted Line
• Medium Line
• Dashed Line
• Double Line

Lets say you wish to apply the "Double Line" border style in the Excel worksheet, you can select the range A2:A7 and expand the "Borders" button and select the "Line Style" and choose the "Double Line" style from the drop-down list.

After that, the cursor is turned into the pen and stretch the pen from the cell A1 and drop it to the A7 cell.

Similarly, you can add other border styles into the Microsoft Excel worksheet.

Apply all Borders Format in Excel

Various Steps are Written Below −

Select the range of cells C4:D11 in the Microsoft Excel Sheet 2.

Use the Keyboard shortcut "Alt+H+B+A" or expand the Borders button and select the "ALL Borders" option from the drop-down menu under the Font group.

The boundary around the selected cell range is applied once you select the "ALL Borders" option.

Format Cell Borders in Excel

You can format the cell borders by changing its default border style like, border line, outline and border color which is taken either from the Standard color or the Theme Color in the Color section of the border tab. By default, the border color is black.

Step 1 − Assume the sample dataset comprises two column titled Name and Designation and select the range C4:C11 cells.

Step 2 − You may press "Ctrl + 1" to open the "Format Cells" dialog box, navigate to the Border tab, select the thick line under Style: section, select the "Outline" option under the Presets section, expand the color option, select the green color from the Standard Colors, and finally hit the OK button.

Colored Bordered gives you vibrant boundary of the cells enhancing visibility where you can also set the different border colors for the independent cells also. Therefore, the green color border is added around the targeted cell range in Microsoft Excel.

Remove the Borders in Microsoft Excel

You can use the Keyboard shortcuts to "ctrl+ shift + _" to remove the border from the dataset. Alternatively, various steps to be taken place to erase the border in the specified dataset.

Step 1 − Select the range C4:D11 and click the Borders button under the Font group. After that, select the "No Border" option from the drop-down menu.

Step 2 − Therefore, the border around the selected range of cells has been erased.

On the other hand, to delete the individual borders, you can also expand "Borders Button" under the Font group in the Home tab and select the "Erase Border" option resided in the Draw Borders section.