While working with dense data and complicated structures in Excel worksheets, it sometimes becomes difficult to read. To avoid these consequences, you can add a border. Inserting a border throughout a dataset can help us differentiate between parts and focus on specific data. Moreover, it makes the worksheet more representative. A border is a line that surrounds a cell or a group of cells. To make your border more attractive and to highlight it, you can also thicken your border. Excel provides us with features to add thick box borders. In this article, we will demonstrate to you some simple and easy methods to add a Thick Box Border in Excel. So, let’s get started.
What Is Border Thickness in Excel?
In Microsoft Excel, there is a thin line border that is set as a default. To make this line more prominent, you may need to thicken the borderline. So, border thickness means inserting a deep line and removing the default borderline. There are several ways to make the borderline thick. We have tried to cover almost all of them. We think you will be able to change your border thickness after reading this article.
Thick Box Border in Excel: 4 Quick Ways
In Excel, there are several ways to add a thick box border. In all cases, the output remains the same as we want to add a thick box border. We have discussed 4 methods to add a thick box border. To do this, we create a dataset of Students’ Department-wise Marks.
Not to mention, we have used the Microsoft 365 version. You can use any other version at your convenience.
1. Using Format Cell Dialog Box to Add Thick Outside Borders
You can use the Format Cell dialog box to add thick borders. All the borders can be customized from there. In our example, we thicken the outside borders of our dataset. You can thicken any other border to your preference. Follow the below steps to do that.
- Firstly, select the entire data range where you want to put the borders.
- Secondly, go to the Home tab >> Select the Font Settings arrow from the Font group.
Note: You can use the CTRL + SHIFT + F to open the Font Settings.
- A dialog box of Format Cells with pop out.
- Then, select Border >> choose the thick line >> pick the Outside Border Outline.
- Lastly, check whether the outline is ok or not and then hit OK.
- Consequently, your outside cell borders will be created just like the snapshot below.
Read More: How to Insert Border in Excel
2. Utilizing Borders Button to Add Thick Bottom Border
We can use the built-in borders button under the Home tab to add a thick border to our dataset. There are various types of borders in the Border drop-down menu, among them, we use the Thick Bottom Border in our dataset. Follow the simple steps to do that.
- Initially, select the cell where you want to put the border.
- Secondly, go to the Home tab >> select the Border drop-down menu >> choose Thick Bottom Border.
- Finally, you will get the desired output.
Read More: How to Apply All Borders in Excel
3. Employing Custom Border Style to Add Top and Thick Bottom Border
You can customize the border to your preference by the Cell Styles command. Initially, you must create a custom border style and then apply it to your worksheet. This process is pretty handy as you can customize it with color and other features. We have demonstrated to you the steps for better visualization.
- Firstly, go to the Home tab and select Cell Styles.
- Under the Cell Styles select New Cell Style.
- Afterward, a dialog wizard named Style will appear from there, create a name in the Style name box as we have created our Top and Bottom Thick Border, and then, click on Format.
- Another Format Cells dialog box will appear. From the Border option, select the Thick Border >> Pick a Color to customize the border >> Choose the top and bottom border individually, and press OK.
- Again, the Style box will appear. Now, click OK.
- To apply this format, select the entire data range and go to the Home tab >> Cell Styles >> then click on the Top and Bottom Thick Border under the Custom section.
- Eventually, you will get all the top and bottom borders just like the image below.
Read More: How to Change Border Color in Excel
4. Applying Keyboard Shortcut
Using the keyboard shortcut, you can thicken the border of your dataset. Among all the methods, it is easy and time-saving. Though it saves you time, you cannot use all the border options. Also, you cannot customize it.
- Thus, for applying an outside thick border press ALT + H + B + T. It will create a border just like the image below.
Similarly, you can use ALT + H + B + H for the thick bottom border. Besides, press ALT + H + B + C to add the top and thick bottom borders.
Read More: How to Apply Top and Bottom Border in Excel
We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
That’s all about today’s session. These are some easy methods to add a thick box border in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Thanks for your patience in reading this article.