What it does
Uses picker prompt to apply one of your five favorite/custom-defined cell styles and lets you save a favorite cell style based on the active cell’s applied cell style.

When to use it
When you want to apply a cell style to one or more cells easily and quickly.

Why to use it
It’s easier and quicker than using the mouse, and gives you a way to save your five favorite/custom-defined cell styles.

Default shortcut
None

Other Details

• Category: Formatting / Colors
• Difficulty: 2/5
• Usage/frequency: 2/5
• Automation factor: 2/5 (estimated 3 seconds saved each time used)
• Type: Shortcut
• Date added: 10/11/2018
• Tags: styles, formats, picker

Related Macros
Toggle Cell Style

Other Articles
None

None

Prerequisites
Select the cells(s) you want to apply a cell style to (or set a favorite/custom-defined cell style from).

Instructions
With cell(s) selected per the prerequisites above, run the Cell Style Picker macro.  It will present your five favorite/custom-defined cell styles with a label and the cell style code.  Just enter the corresponding number (1, 2, 3, 4, or 5) and click enter to run.  That’s it!.

Like most of the picker macros, you can set the default number to apply so you don’t even have to enter the number – just the Enter key.  Just enter your preferred default number, then click the default checkbox, and that number becomes the new default.  To change the cell style options, follow the instructions below.

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.

None