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.
In this Excel tutorial, you will learn to apply Bottom Double Border. Also, the process of creating a custom border style in Excel to get rid of the repetitive steps of adding borders to multiple ranges.
In the following image, the Bottom Double Border is applied in the row before the Total’s row using the built-in Border option from the Font tab.
2 Ways to Apply Bottom Double Border in Excel
You will learn to apply Top and Bottom Border in 2 different ways: using the built-in Border option, Format Cells dialog box.
Using Built-in Border Option
To apply Bottom Double Border from built-in Border option:
- Select the range.
Here, select the row before the Total’s row (range B16:D16). - Go to Home tab > Font group > Border drop-down > Bottom Double Border.
Tip: 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 cell range now contains Bottom Double Border like the image below:
Note: You can apply Bottom Double Border using the shortcut: Select the range and use the keys Alt + H + B + B one by one serially. 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 Insert Border in Excel
Using Format Cells Dialog Box
When you use the built-in Border option to add Bottom Double Border, it will only apply borders to the bottom side of the last cell in a range. You can apply the Bottom Double Border to all the cells in a range using the Format Cells dialog box.
Follow the steps below to apply the Bottom Double Border using the Format Cells dialog box:
- Select the range.
Here, select the range B12:D17. - Right click on your mouse and click on the Format Cells option.
Or, you can also click on the Format Cells dialog box launcher icon from the Font, Number, or Alignment toolbar. - In the Format Cells dialog box:
- Go to the Border tab.
- Select the Double Border style.
- Choose any color from Color group.
- Select the middle and bottom border in the Border group.
- Click the OK button.
The selected range has a Double Bottom Border like the following image.
Note: You can use the keyboard shortcut Ctrl+1 to open the Format Cells dialog box.
Read More: How to Apply All Borders in Excel
How to Create a Custom Bottom Double 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. Follow the steps below to create a custom border style:
- Go to the Home tab > Cell Styles option > New Cell Style from dropdown.
- In the Style dialog box, set a Style Name and click on the Format button.
- In the Format Cells dialog box:
- Go to the Border tab.
- Select the Double Border style.
- Choose any suitable Color from the dropdown menu.
- Select the Bottom Border option.
- Click the OKÂ button.
- Uncheck the Number checkbox as it is set to General and our dataset contains Accounting type data and click OK.
- Now select the range.
Here, select the row range B16:D16. - Click on the Cell Styles drop-down and select the newly created custom cell style.
The custom border style will be applied to the selected range like the following.
Read More: How to Add Thick Box Border in Excel
Frequently Asked Questions
What is the purpose of using a bottom double border in Excel?
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?
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 the Double Bottom Border in Excel?
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. Both these features can highlight cell content. 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
In this article, we have applied Bottom Double Border using built-in Border option, and Format Cells dialog box. In addition to that, you will find how to apply customized bottom Double Border in Excel. Please let us know in the comments section below if you have any queries or recommendations.
Related Articles
- How to Add or Remove Dotted Border in Excel
- How to Add Cell Borders Inside and Outside in Excel
- How to Remove Borders in Excel
- How to Apply Top and Bottom Border in Excel
<< Go Back to Cell Borders in Excel | Excel Cell Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!