What it does
Loops through common cell styles (default is Normal->Input->Comma->Bad->Good->20% – Accent1) for all selected cells, based on the cell style of the top-left selected cell.

Up to five cell styles can be customized using the Cell Style 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 cell styles, this is is an easy way to toggle through and apply them.

Why to use it
It’s easier than 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 / Colors
• Difficult: 1/5
• Usage/frequency: 3/5
• Automation factor: 2/5 (estimated 3 seconds saved each time used)
• Type: Shortcut
• Date added: 10/11/2018
• Tags: Cell style, toggle, format

Related Macros
Cell Style Picker
Assign Macro Defaults

Other Articles
None

None

Prerequisites
Select the cell or cells for which you want to apply a cell style.  The cells do not have to be contiguous.

Instructions
With your intended cells selected, run the Toggle Cell Style macro.  It will loop through your five pre-defined cell styles and back to cell style.  That’s it!

To change the five default cell styles, there are two options:

1. Use the Cell Style Picker.
   1. Set a cell style to the style you want to use as a favorite/toggle.  Run the Cell Style Picker macro.
   2. In the text box, enter X, then a space, then DEFAULT# where # is the corresponding picker # (1 through 5).  Example: Enter “X DEFAULT1” to apply the active cell’s style to option #1 and you would just enter 1 in the picker to set that style, or use the Toggle Cell Style macro for that as the first toggle value.
2. Use the Assign Macro Defaults macro.
   1. Run the Assign Macro Defaults macro.  It will take a few seconds to export all default values to a new sheet in the active workbook.
   2. Search for “Toggle Cell Style” in the newly created sheet.  Follow the instructions in the cell comments to set one or more default cell styles.
   3. Run the Assign Macro Defaults macro again to process the changes.