Excel Formatting Shortcuts: Bold, Number Formats, and Cells Dialog
Format spreadsheets faster with Ctrl+B, Ctrl+1, percentage and currency shortcuts, and other keys that replace endless ribbon clicks.
Formatting makes data readable for stakeholders. Doing it through the ribbon works, yet formatting shortcuts keep your hands on the keyboard while you polish headers, numbers, and emphasis.
Font style keys
Ctrl + B— BoldCtrl + I— ItalicCtrl + U— UnderlineCtrl + 5— Strikethrough
Use bold for headers and key totals. Italic works for notes. Strikethrough helps mark obsolete items in working lists without deleting them yet.
Format Cells: the power dialog
Ctrl + 1 opens Format Cells — number formats, alignment, font, border, fill, and protection in one place. Learn to reach it without thinking. From there you can set custom formats, wrap text, and apply consistent borders.
A useful habit: select the range first with keyboard selection shortcuts, then press Ctrl + 1. Selection plus formatting as one flow is faster than click-drag-click through menus.
Number format shortcuts
Ctrl + Shift + $— Currency formatCtrl + Shift + %— Percentage formatCtrl + Shift + !— Number with thousand separators and two decimalsCtrl + Shift + ~— General format
Financial and KPI sheets lean heavily on currency and percent formats. Applying them from the keyboard keeps review sessions moving when you are checking dozens of columns.
Formatting workflow example
Suppose you receive a raw export:
- Select the header row with
Shift + Space, then bold withCtrl + B. - Select the amount column and press
Ctrl + Shift + $. - Select the margin column and press
Ctrl + Shift + %. - Select the full table and open
Ctrl + 1to add a light border if needed.
Practice this sequence in Formatting practice until it feels like one motion. Pair it with our cheat sheet for any format you use less often.
Clean formatting communicates professionalism. Keyboard formatting keeps that polish from slowing you down.
Practice what you learned
Open a free interactive mode and turn these shortcuts into muscle memory.