Apply Border to Cells in Excel (Shortcut)

Applying borders to a data set in excel could really enhance the readability of your data and also make it look a lot more polished.

In this tutorial, I will give you the keyboard shortcut to apply border to cells in Excel

Table of Contents

Shortcut to Apply Border to Cells in Excel

Below is the keyboard shortcut to apply borders to cells in Excel

ALT + H + B + A

Below are the steps to use the above keyboard shortcut

Select the cell or range of cells on which you want to apply the border
Use the keyboard shortcut ALT + H + B + A (press these keys one after the other)

The above steps would instantly apply a regular black color border to the selected cells

Apart from applying a regular border to all the selected cells, Excel also has many other border styling options that you can choose from.

A lot of people also need to apply a thick border around a specific cell, row, or range of cells.

Below is the keyboard shortcut that you can use to quickly apply a thick border around the selected cells:

ALT + H + B + T

Below are some of the common keyboard shortcuts that you can use to apply different styles of borders to the selected cells:

To apply a top border to selected cells – ALT + H + B + P
To apply a bottom border to selected cells – ALT + H + B + O
To apply a left border to selected cells – ALT + H + B + L
To apply a right border to selected cells – ALT + H + B + R
To apply regular thickness outside border to selected cells – ALT + H + B + S
To apply a bottom double border to selected cells – ALT + H + B + B
To apply a thick bottom border to selected cells – ALT + H + B + H
To apply top and bottom regular thickness border to selected cells – ALT + H + B + D
To apply regular thickness top and thick bottom border to selected cells – ALT + H + B + C
To apply top and double bottom border to selected cells – ALT + H + B + U

And finally, below is the keyboard shortcut to remove all the borders from the selected cells.

ALT + H + B+ N

Apart from the border options that you see in the border drop-down, Excel also provides a lot many other options that you can access by going to the home tab and clicking on the ‘Border’ icon, and then clicking on the ‘More Borders’ option

In the more border options dialog box, you can choose the style of the border, the color of the border, and also apply diagonal borders as well.

When you remove the borders from the selected cells, it would only remove the bottles that were manually applied to those cells. it would not remove the gridlines or the borders applied using conditional formatting
Excel also allows you to manually draw borders as well as erase borders using the options in the border drop-down

Other Excel shortcuts you may also like:

Other Excel Tutorials You May Also Like: