How to Apply Bottom Double Border in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will present 3 ideal methods of applying Bottom Double Border in Excel. We will also discuss the process of creating a custom border style in Excel to get rid of the repetitive steps of adding borders to multiple ranges.

The Bottom Double Border formatting option is often applied to enhance the appearance and readability of a dataset. It is used while highlighting totals, creating clear boundaries for grouping data, emphasizing important information, separating sections, etc.

Overview of Bottom Double Border in Excel


Apply Bottom Double Border in Excel: 3 Easy Ways

Here, we have sales and profit values for each month of the year, and we calculated the total sales and profits. We want to separate the row of totals from other rows by using a Bottom Double Border.

Sample Dataset to Present Bottom Double Border in Excel


1. Using Bottom Double Border Command from Font Toolbar

Select the range B16:D16 (the row before the total’s row) >> click on the dropdown icon of the Borders option >> select the Bottom Double Border option from the dropdown menu.

Applying Bottom Double Border Command from Font Toolbar in Excel

Note: If you want to apply any Line Color or Line Style other than defaults, then choose the desired Line Color and/or Line Style from the Draw Borders options first, and then select borders.

The range now looks like the following.

Output After Applying Bottom Double Border Command in Excel

Read More: How to Apply All Borders in Excel


2. Apply Bottom Double Border Through Format Cells Dialog Box

Select the range B16:D16 and click on the Format Cells option from the right-click menu. You can also click on the Format Cells dialog box launcher icon from the Font, Number, or Alignment toolbar.

Selecting Format Cells Feature from Right-Click Menu

In the Format Cells dialog box, go to the Border tab >> select the Double Border style >> choose any Color if you require >> select the Bottom Border option >> click the OK button.

Applying Bottom Double Border in the Format Cells Dialog Box in Excel

The selected range has a Double Bottom Border like the following.

Output After Formatting Cells

Read More: How to Apply Top and Bottom Border in Excel


3. Use Keyboard Shortcut to Apply Bottom Double Border

Like various other tasks, we also have a keyboard shortcut for applying the Bottom Double Border in Excel. Select the range B16:D16 and use the keys Alt + H + B + B one by one serially.

Using Keyboard Shortcut to Apply Bottom Double Border in Excel

The output after applying the keyboard shortcut is given below.

Output After Applying Keyboard Shortcut to Add Bottom Double Border in Excel

Note: The keyboard shortcuts for border options do not have any control over Line Color and Thickness. You have to use the Format Cell dialog box or Font toolbar options instead.

Read More: How to Add Cell Borders Inside and Outside in Excel


How to Create a Custom Border Style in Excel

Applying borders to multiple cells or ranges through the Font toolbar or Format Cells dialog box is a time-consuming task and requires the repetition of several steps. On the other hand, keyboard shortcuts can’t control the Line Color or Thickness of borders. Therefore, the requirement for custom border styles.

Select a range >> go to the Home tab >> click on the dropdown icon of the Cell Styles option >> click on the New Cell Style option from the dropdown menu.

Selecting New Cell Style Option to Create Custom Border Style

In the Style dialog box, set a Style Name and click on the Format button.

Naming the New Cell Style

In the Format Cells dialog box, go to the Border tab >> select the Double Border style >> chose any suitable Color from the dropdown menu >> select the Bottom Border option >> click the OK button.

Selecting Border Options for the Custom Border Style

Afterward, uncheck the checkbox of the Number option (as it is set to General and our dataset contains Accounting type data) and click the OK button.

Saving the New Custom Cell Style

Now, select the range B16:D16 >> click on the dropdown icon of the Cell Styles option >> select the newly created custom cell style.

Applying the New Cell Style

The custom border style will be applied to the selected range like the following.

Output After Custom Bottom Double Border Applied in Excel

Read More: How to Add Thick Box Border in Excel


Things to Remember

  • If you remove or modify the custom cell style, then the formatting of all the cells where that custom cell style was applied will also get removed or modified.
  • You can also modify the Number format, text Alignment, Font style, Fill color, and Protection options of a cell along with the Border while creating a custom cell style.

Frequently Asked Questions

  • What is the purpose of using a bottom double border in Excel?

Answer: Bottom Double Borders in Excel can visually emphasize a cell or a range of cells, making them stand out from the rest of the data. We commonly use it to indicate totals, headers, or important information.

  • How to Remove a Double Bottom Border in Excel?

Answer: To remove a Double Bottom Border from a range of cells, select the range >> click on the Borders dropdown icon >> select the No Border command from the dropdown menu. We can also use the keyboard shortcut Ctrl + Shift + _ to remove all borders from the selected range.

  • Is the Double Underline Feature the same as Double Bottom Border in Excel?

Answer: In Excel, we apply the Double Underline feature to the content of a cell. On the other hand, we apply the Double Bottom Border to the cell itself, not its content. However, both these features can highlight cell content. Therefore, the Double Underline feature can work as an alternative to the Double Bottom Border. To apply the Double Underline feature to any cell content, select the cell >> click on the dropdown icon of the Underline option >> select the Double Underline command from the dropdown menu.


Download Practice Workbook

You may download the following workbook and practice yourself.


Conclusion

This concludes our article on the Bottom Double Border in Excel.  We discussed several methods of applying it along with creating custom border styles and removing borders. We hope that the demonstrated methods were helpful in enhancing the appearance and readability of your dataset. Let us know your feedback on the article. Visit our website ExcelDemy.com for more articles related to Excel.


Related Articles

Seemanto Saha
Seemanto Saha

Greetings, I'm Seemanto Saha, a Technical Writer and Content Creator at ExcelDemy. My academic journey led me through the corridors of Bangladesh University of Engineering and Technology, where I earned my degree in Industrial and Production Engineering. My passion lies in tackling analytical challenges and crafting engaging content. My goal is to harness my research and analytical prowess to deliver superior content experiences for all.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo