Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
Excel does not apply any border to the cell on its own, but there are multiple types of border options available to apply to the specific cells, range, or spreadsheet by users manually or using keyboard shortcuts.
In this tutorial, we have explained some keyboard shortcuts to apply borders in Excel.
Shortcut Keys to Apply Border in Excel
The most commonly used border option is “All Borders” which applies border to all the sides of the cell.
Alt → H → B → A
Steps to Apply Border Using Keyboard Shortcut
- First, select the cell, range of cells, or the complete data in the spreadsheet using “Ctrl +A” to select the cells, where you want to apply borders.
- After that, press Alt → H → B → A in sequence and you will get the borders applied to all the sides of each selected cell.
Shortcut Keys to Apply Some Different Types of Borders
The shortcut keys combination to apply all the types of borders are the same except for the last key of the combination which changes based on the border type which you want to apply.
- Apply borders to the bottom of the cells: Alt → H → B → O
- Apply borders to the top of the cells: Alt → H → B → P
- Apply borders to the left of the cells: Alt → H → B → L
- Apply borders to the right of the cells: Alt → H → B → R
- Apply borders only outside of the selected range: Alt → H → B → S
- Apply thick borders only outside of the selected range: Alt → H → B → T
- Apply double borders to the bottom of the cells: Alt → H → B → B
- Apply double thick borders to the bottom of the cells: Alt → H → B → H
To find and apply more border options Press Alt → H → B → M and you will get the “Format Cells” dialog box opened with more border options to choose from.