How to Apply Bottom Double Border in Excel (2 Ways)

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.

Overview Image of How to Apply Bottom Double Border in Excel

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:

  1. Select the range.
    Here, select the row before the Total’s row (range B16:D16).
  2. Go to Home tab > Font group > Border drop-down > Bottom Double Border.Applying Built-in Border Option

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:

Output of Applying Bottom Double Border Using Built-in Border

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:

  1. Select the range.
    Here, select the range B12:D17.
  2. 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.Using Format Cells Dialog Box to Apply Bottom Double Border
  3. 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.

    Applying Options in Format Cells Box

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

Output of Applying Format Cells

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:

  1. Go to the Home tab > Cell Styles option > New Cell Style from dropdown.Selecting Option from Cell Styles Dropdown
  2. In the Style dialog box, set a Style Name and click on the Format button.Giving Name to the New Style
  3. 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.

    Choosing Option for New Style

  4. Uncheck the Number checkbox as it is set to General and our dataset contains Accounting type data and click OK.Unchecking Specific Selection
  5. Now select the range.
    Here, select the row range B16:D16.
  6. Click on the Cell Styles drop-down and select the newly created custom cell style.Selecting Cells to Apply Border

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

Final Output of Applying New Style

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.


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

<< Go Back to Cell Borders in Excel | Excel Cell FormatLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Seemanto Saha
Seemanto Saha

Seemanto Saha graduated in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. He has been with ExcelDemy for a year, where he wrote 40+ articles and reviewed 50+ articles. He has also worked on the ExcelDemy Forum and solved 50+ user problems. Currently, he is working as a team leader for ExcelDemy. His role is to guide his team to write reader-friendly content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF