Practice · Formatting

0
15 shortcuts

Excel Practice: Formatting

Master every shortcut in the "Formatting" category through quizzes

Progress 0 / 15

Practice Formatting Excel Shortcuts

Formatting shortcuts make your spreadsheets professional in seconds. These 15 shortcuts cover text formatting (bold, italic, underline), number formatting (currency, percentage, date), cell alignment, borders, and the Format Cells dialog.

Instead of hunting through the ribbon for number formats or font options, press a key combination and it's done instantly. Ctrl+B for Bold, Ctrl+1 for Format Cells, Ctrl+Shift+$ for currency — these small efficiencies compound over thousands of formatting operations.

Excel Practice Format

This category practice mode shows you a keyboard shortcut and asks you to identify the correct action from 4 choices. You'll work through all 15 shortcuts in the Formatting category in random order. Correct answers are tracked, so you can see which shortcuts you've mastered and which need more practice.

Your progress is saved automatically. Come back anytime to review or retry. Once you're confident, test your speed in the Speed Challenge or try the Real Scenarios to apply these shortcuts in context.

Excel Formatting Practice FAQ

How many shortcuts are in the Formatting category?
There are 15 shortcuts in this category. Each one is tested individually, and your progress is saved so you can pick up where you left off.
Do these shortcuts work on both Windows and Mac?
Yes. Every shortcut in our database has both Windows and Mac key combinations. The practice exercises currently show the Windows keys, but you can find the full list with both platforms on our Cheat Sheet page.
What's the best order to practice categories?
We recommend: Basics first (highest daily impact), then Navigation & Selection (essential for large spreadsheets), then Formatting, Formulas & Functions, Data Processing, and finally Advanced Techniques. But feel free to jump to whichever category is most relevant to your current work.