1
Ctrl + Shift + 1Apply number format with comma separator
The go-to shortcut for making numeric data readable at a glance.
Number FormatNumberDate
Switch Number Formats Instantly with Ctrl+Shift+1 Through 6
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
You don't need to memorize all six. Starting with the four most common is enough.
2
Ctrl + Shift + 3Apply date format
Also useful for confirming whether a cell is actually recognized as a date by Excel.
3
Ctrl + Shift + 4Apply currency format
Quickly standardize monetary columns.
4
Ctrl + Shift + 5Apply percentage format
Makes 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 | Number Format |
Ctrl + Shift + 3 | Date Format |
Ctrl + Shift + 4 | Currency Format |
Ctrl + Shift + 5 | Percentage Format |
Ctrl + 1 | Format Cells Dialog |
Frequently Asked Questions
Q. What are Ctrl+Shift+2 and Ctrl+Shift+6 for?
A. Time format and scientific notation, respectively. Less frequently needed, but useful in the right context.
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 alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →