What it does
Loops through your favorite border formats (default is none->bottom regular->top medium, bottom double->outside thick->all regular->horizontal dashed) for all selected cells, based on the border style of the top-left selected cell.

Up to five border formats can be customized using the Border Picker macro or the Assign Macro Defaults macro.

When to use it
Any time you want to format one or more cells using one of your five favorite/pre-selected border formats, this is an easy way to toggle through and apply them.

Why to use it
It’s easier and quicker than using the mouse, especially when you leverage keyboard shortcuts – it’s like six shortcuts in one.

Default shortcut
None

Other Details

• Category: Formatting / Polishing
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 3/5 (estimated 5 seconds saved each time used)
• Type: Shortcut
• Date added: 4/7/2018
• Tags: formats, borders, toggle

Related Macros
Border Picker
Add Border Sum

Other Articles
None

Border Picker – Example File