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.
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.
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.
The range now looks like the following.
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.
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.
The selected range has a Double Bottom Border like the following.
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.
The output after applying the keyboard shortcut is given below.
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.
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 >> chose any suitable Color from the dropdown menu >> select the Bottom Border option >> click the OK button.
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.
Now, select the range B16:D16 >> click on the dropdown icon of the Cell Styles option >> 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
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
- How to Insert Border in Excel
- How to Add or Remove Dotted Border in Excel
- How to Remove Borders in Excel
- How to Remove Page Border in Excel
- How to Lock Borders in Excel
- [Fixed!] Border Not Showing in Excel
- How to Cancel Moving Border in Excel
- How to Make Graph Paper in Excel
- How to Change Border Color in Excel