Excel Border Shortcuts – Outline, Top, Bottom, Left, Right

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 30, 2023

This tutorial shows shortcuts to add and remove borders in Excel.

Shortcuts to Add or Remove Borders

Borders can be used to emphasize cell contents and make your spreadsheet more visually appealing.

Shortcut to Add or Remove Borders

There are many different border options, as seen in the Borders drop down on the Home tab of the Ribbon.

Navigation

Outside Borders Shortcut

To apply borders to the outside of a selected range:

  1. Highlight area where you want to add a border.
  2. Use the shortcut:
    PC Shortcut: Ctrl+Shift+&
    Mac Shortcut: ++0

Outside Borders

Clear Borders Shortcut

To clear all borders in a selected range:

  1. Highlight the area where you want to remove all borders.
  2. Use the shortcut:
    PC Shortcut:Ctrl+Shift+_
    Mac Shortcut:++_

Clear Borders

All Borders Shortcut

To add all borders to a range:

  1. Highlight the range where you want to apply all borders.
  2. Use the shortcut:
    Alt+H>B>A

All Borders

Other Borders Shortcuts

To add a top, bottom, left, or right border, instead of A (for All), use T for Top, B for Bottom, L for Left, or R for Right.

AI Formula Generator

Try for Free