1
Ctrl + Shift + 1Apply number format with comma separatorThe go-to shortcut for making numeric data readable at a glance.
Number FormatNumberDate
Switch Common Number Formats Instantly with Ctrl+Shift+1, 3, 4, and 5
The look of a report often comes down to consistent number formatting. Hunting through the ribbon for each format is slow — locking in the key ones as shortcuts makes the difference.
Shortcuts you will master in this article
Ctrl + Shift + 1 / Ctrl + Shift + 3 / Ctrl + Shift + 4 / Ctrl + Shift + 5
Inconsistent Formatting Hurts Credibility, Not Just Aesthetics
A column mixing 1,000 and 1000, or dates toggling between 2026/4/1 and April 1 — formatting inconsistencies undermine the overall impression of a document.
Knowing the number format shortcuts means you can standardize before submission in seconds.
The Most Useful Number Format Shortcuts
Start with the four formatting shortcuts that appear most often in everyday reports.
2
Ctrl + Shift + 3Apply date formatAlso useful for confirming whether a cell is actually recognized as a date by Excel.
3
Ctrl + Shift + 4Apply currency formatQuickly standardize monetary columns.
4
Ctrl + Shift + 5Apply percentage formatMakes ratio columns report-ready instantly.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Tips for Using Format Shortcuts
Decide on your target formats before formatting — knowing what you want makes the shortcuts faster to apply.
Verify both the appearance and the underlying data type, not just the visual result.
If you need to fine-tune decimal places or custom display rules, follow up with Ctrl+1.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + Shift + 1 | Apply Comma Style |
Ctrl + Shift + 3 | Apply Date Format |
Ctrl + Shift + 4 | Apply Currency Format |
Ctrl + Shift + 5 | Apply Percentage Format |
Ctrl + 1 | Format Cells Dialog |
Frequently Asked Questions
Q. What are Ctrl+Shift+2 and Ctrl+Shift+6 for?
A. Ctrl+Shift+2 copies only the value from the cell above, while Ctrl+Shift+6 applies an outside border.
Q. Does changing the number format change the underlying value?
A. No. Only the display changes. The actual stored value is preserved.
Q. I applied a date format but it still shows as a number.
A. The cell may contain a text string rather than a real date value. A display format change alone won't fix that — check the underlying data type.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and switch between difficulty, category, and review practice for faster retention.