Excel Number Formatting Shortcuts

Reaching for the mouse to change a number format breaks your flow when you are building a model. Excel has built-in shortcuts for the most common formats, and learning them saves you thousands of clicks over a project. Here are the ones worth memorizing, plus a single shortcut that handles all of them.

The built-in formatting shortcuts

Excel ships with keyboard shortcuts for the formats analysts use most. Select your cells first, then press the combination.

• Ctrl+Shift+1 applies the comma number format with two decimals, like 1,234.56.
• Ctrl+Shift+4 applies the currency format, like $1,234.56.
• Ctrl+Shift+5 applies the percent format, like 42%.
• Ctrl+Shift+6 applies the scientific (exponential) format.
• Ctrl+Shift+asciitilde (the tilde key) returns cells to the General format.

Apply a format with the keyboard

The flow is the same for every shortcut above.

1. Select the cell or range you want to reformat.
2. Press the shortcut for the format you want, such as Ctrl+Shift+5 for percent.
3. Use the Increase Decimal and Decrease Decimal buttons on the Home tab, or Alt+H,0 and Alt+H,9, to adjust decimal places.
4. Press Ctrl+1 to open the full Format Cells dialog if you need a custom format like #,##0.

The gap in the built-in shortcuts

Each built-in shortcut is a separate key combination, so you have to remember which one is which. Worse, there is no shortcut for the plain comma format with no decimals, the workhorse of financial models, so you usually apply Ctrl+Shift+1 and then press Decrease Decimal twice. Switching a column back and forth while you check numbers means juggling several shortcuts.

Cycle every format with one shortcut in ModelMint

ModelMint Format Cycler puts all of this on a single shortcut. Select a range and press it to step through the common formats: general, comma, currency, and percent. Tap it again to move to the next one until the numbers look right. One key replaces four, and you never have to remember which combination does what.