How to Add Thick Box Border in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset

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.

📌 Steps:

  • 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.

Using Format Cell Dialog Box to Add Thick Outside Border in Excel

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.

Format Cell dialog box

  • 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.

📌 Steps:

  • 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.

Utilizing Borders Button to Add Thick Bottom Border in Excel

  • 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.

📌 Steps:

  • Firstly, go to the Home tab and select Cell Styles.
  • Under the Cell Styles select New Cell Style.

Employing Custom Border Style to Add Top and Thick Bottom Border in excel

  • 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.

Style Dialog box

  • 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.

Adding customize thick box border in excel

  • 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.

📌 Steps:

  • Thus, for applying an outside thick border press ALT + H + B + T. It will create a  border just like the image below.

Applying Keyboard Shortcut to thick box border in excel

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


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Conclusion

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo