Apply Border (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

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.

AltHBA

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.
    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.
    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 for the last key of the combination which changes based on the border type which you want to apply.

  1. Apply borders to the bottom of the cells: AltHBO
  2. Apply borders to the top of the cells: Alt → H → B → P
  3. Apply borders to the left of the cells: Alt → H → B → L
  4. Apply borders to the right of the cells: Alt → H → B → R
  5. Apply borders only outside of the selected range: Alt → H → B → S
  6. Apply thick borders only outside of the selected range: Alt → H → B → T
  7. Apply double borders to the bottom of the cells: Alt → H → B → B
  8. Apply double thick borders to the bottom of the cells: Alt → H → B → H
multiple-border-types

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.

more-border-options
Last Updated: January 10, 2024