Apply Border (Keyboard Shortcut)

HomeExcel Keyboard ShortcutsApply Border (Keyboard Shortcut)

Excel does not apply any border to the cell by 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.

Keyboard Shortcut to Apply Border in the Excel

The most commonly used border option is “All Borders” which applies border to all the sides of the cell and the shortcut to apply this border is as mentioned below:

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.
    2-select-the-range
  • After that, press Alt → H → B → A in sequence and you will get the borders applied to all the sides of each selected cell.
    3-border-applied-to-the-cells

Shortcut Keys to Apply Some Different Types of Borders

The shortcut keys combination to apply all the types of borders are the same except 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.

← Back to Main Page (PDF Cheat Sheet – Keyboard Shortcuts for Excel)