Complete List of Excel Formatting Shortcut Keys
Master Excel formatting shortcuts for Windows including bold, italic, number, date, percent, indent, and decimal keys to work faster.
Microsoft Excel formatting shortcuts are powerful time-saving tools that help users work faster, smarter, and more efficiently. Whether you are a beginner, student, data analyst, accountant, or office professional, mastering Excel keyboard shortcuts for formatting can significantly improve your productivity and reduce dependency on the mouse.
From applying bold and italic styles to quickly formatting numbers, dates, and percentages, Excel provides built-in shortcut keys that streamline your workflow. Learning these Excel formatting shortcuts for Windows not only speeds up your tasks but also enhances accuracy while working with large datasets.
In this guide, you will discover the most essential Excel formatting shortcut keys, explained clearly in a structured table format for quick reference.
| Action | Windows Shortcut |
|---|---|
| Open Format Cells dialog | Ctrl + 1 |
| Bold text | Ctrl + B |
| Italic text | Ctrl + I |
| Undo last action | Ctrl + Z |
| Repeat last action | Ctrl + Y |
| Select all used cells (Press twice for entire sheet) | Ctrl + A |
| Apply Number format | Ctrl + Shift + ! |
| Apply Date format | Ctrl + Shift + # |
| Apply Percent format | Ctrl + Shift + % |
| Increase font size | Alt + H + FG |
| Decrease font size | Alt + H + FK |
| Increase decimal places | Alt + H + 0 |
| Decrease decimal places | Alt + H + 9 |
| Increase indent | Alt + H + 6 |
| Decrease indent | Alt + H + 5 |
Excel formatting shortcuts are more than just convenience tools — they are productivity boosters. By memorizing and regularly using these keyboard shortcuts, you can complete tasks faster, improve efficiency, and develop professional-level Excel skills.
If you want to master Microsoft Excel, start by practicing these formatting shortcut keys daily. Over time, they will become second nature and drastically reduce the time you spend navigating menus.