Excel Cell Borders Shortcuts

Jump to: Basic Cell Borders, Cell Borders via Border Menu, Cell Borders via Ribbon Shortcuts

1. Basic Cell Borders

Ctrl+Shift+7	Apply border on all sides of cell
Ctrl+Shift+-	Remove all borders from selection

2. Cell Borders via Border Menu

Always open Border Menu first. Press Ctrl+1, then Ctrl+Tab to reach the Border Menu if it is not already active. Once Border Menu is selected, pressing Ctrl+1 later will keep focus on border menu.

Ctrl+1, then Ctrl+Tab	Open Border Menu
Alt+HB, them M	Open Border Menu
Alt+T	Toggle Top border (in border menu)
Alt+B	Toggle Bottom border (in border menu)
Alt+R	Toggle Right border (in border menu)
Alt+L	Toggle Left border (in border menu)
Alt+O	Toggle Outline order (in border menu)
Alt+I	Toggle Inside border (in border menu)
Alt+H	Toggle Horizontal interior border (in border menu)
Alt+V	Toggle Vertical interior border (in border menu)
Alt+U	Toggle Upwards diagonal border (in border menu)
Alt+D	Toggle Downwards diagonal border (in border menu)
Alt+N	Remove/ Neutralize all borders (in border menu)

3. Cell Borders via Ribbon Shortcuts

Ribbon Shortcuts for borders are difficult to memorize and counterintuitive. Suggest to use Shortcuts via Border Menu (see above). Ribbon shortcuts do not toggle back, plus its difficult to see immediate result. Letters chosen as shortcut in the ribbon menu make no sense (e.g. T for Thick outside border instead of Top border)

Alt+HB then O	Bottom border
Alt+HB then P	Top border
Alt+HB then L	Left border
Alt+HB then R	Right border
Alt+HB then N	No borders
Alt+HB then A	All borders
Alt+HB then A	Outside borders
Alt+HB then T	Thick outside borders
Alt+HB then B	Bottom double borders
Alt+HB then H	Thick bottom borders
Alt+HB then C	Top and thick bottom border
Alt+HB then U	Top and double bottom border

Created by max on 12/8/2020. Last updated by max on 1/14/2021

Microsoft Excel Shortcuts

Advertising for Consideration:

Ads for Consideration: