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

 

0 Comments for '[Excel] - Excel Cell Borders Shortcuts'   

 
Email me replies   

Please kindly review and accept Terms of Use and Cookie & Policy Policy