How to Apply Top and Bottom Border in Excel (3 Efficient Ways)

In this Excel tutorial, we will explain how to apply Top and Bottom border.

In the image below, the cells on the left don’t have borders, but on the right, borders have been added using the Top and Bottom Border option.

Overview Image of How to Apply Top and Bottom Border in Excel


3 Ways to Apply Top and Bottom Border in Excel

Method 1 – Using Top and Bottom Border Option from Borders Command

In the Border drop-down are 3 types of Top and Bottom borders: Top and Bottom Border, Top and Thick Bottom Border, and Top and Double Bottom Border.

Let’s insert the Top and Bottom Border using the built-in Borders option.

Steps:

  • Select the cells where you want to insert borders.
  • Go to Home tab > Font group > Border drop-down > Top and Bottom Border.Applying Top and Bottom Border Option

The cell range now contains Top and Bottom Borders like the image below:

Output of Applying Top and Bottom Border from Built-in Option

You can alternatively select Top and Thick Bottom Border or Top and Double Bottom Border from the Border drop-down, as the following gif demonstrates:

Applying Top and Thick Bottom Border and Top and Double Bottom Border

Note: Apply the Top and Thick Bottom Border using the shortcut Alt+H+B+C, and the Top and Bottom Double Border using the shortcut Alt+H+ B+U.

Read More: How to Insert Border in Excel


Method 2 – Using Format Cells Dialog Box

When you use the built-in Border option to add Top and Bottom Border, it only applies borders to the top side of the first cell and the bottom side of the last cell in a range. You can apply Top and Bottom border to all the cells in the range using the Format Cells dialog box.

Steps:

  • Select the cells.
  • Press Ctrl+1 together to open the Format Cells dialog box.
  • In the Format Cells dialog box:
    • Go to Border.
    • Select top, middle and bottom border in the Border group.
    • Click OK.

    Applying Top and Bottom Border Using Format Cells Dialog Box

This will apply the top and bottom border to all the cells in the range.

Output of Applying Top and Bottom Border Using Format Cells Dialog Box

To add Top and Bottom border quickly, apply the following shortcuts in the Format Cells dialog box:

  • For the Bottom Border, press Alt + B
  • For Top Border, press Alt + T

Read More: How to Apply All Borders in Excel


Method 3 – Using Draw Border Option

You can draw Top and Bottom borders directly on the worksheet instead of selecting cells first and then choosing from a set of built-in options.

Steps:

Go to Home tab > Font group > Border drop-down > Draw Border.Selecting Draw Border Option
Excel switches to the Draw Border mode automatically, and the cursor becomes a pen.

  • Take the pen to the upper side of the cell where you want to apply the border.
  • Click on the mouse to apply borders.
  • When done, press Esc to disable the border pen.

The gif below explains the process.

Applying Top and Bottom Border Using Draw Border

Read More: How to Add Thick Box Border in Excel


How to Apply Customized Top and Bottom Border

If you want to apply a unique Top and Bottom border in Excel, modify the Style and Color in the Format Cells dialog box.

Steps:

  1. Choose the cells where you want to add borders.
  2. Hit the Ctrl+1 keys to open the Format Cells dialog box.
  3. In the Format Cells dialog box:
    • Go to the Border tab.
    • Select your desired Style and Color.
    • Select the Top and Bottom Border and click OK.

    Selecting Color and Style from Format Cells Box

The final output looks like the image below.

Output of Applying Customized Border

Read More: How to Change Border Color in Excel


Download Practice Workbook


Frequently Asked Questions

How to apply the Top and Bottom border with a single command?

Use the shortcut Alt+H+B+D.

How to remove borders from cells in Excel?

Select the cells, open the Format Cells dialog, go to the Border tab, and choose the No Border option.

How to apply top and bottom borders to multiple sheets at once?

Hold down Ctrl (or Shift for adjacent sheets) and click on the desired sheet tabs. Then, apply the borders from the Format Cells dialog box following the steps described above. The changes will be reflected on all selected sheets.

Is it possible to save my custom border settings?

Excel does not provide the option to save custom border settings directly within the border menu. However, you can create a New Cell Style in the Styles group in the Home tab containing your desired settings. This style can be utilized for any future documents you create.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo