Excel Formatting Shortcuts
Formatting in Excel covers everything from bolding a header row to defining custom number formats for currency or percentages, and because so much of it lives behind ribbon clicks, it's one of the categories where keyboard shortcuts save the most visible time — especially Ctrl+1, which opens the single dialog that handles almost every formatting need at once. Rounding out the formatting toolkit, italic joins bold as a basic character toggle, while text wrapping controls how long cell content displays without needing to widen a column beyond what's practical for a table's overall layout.
| Action | Windows | Mac | Description |
|---|---|---|---|
| Toggle bold | Ctrl+B | Cmd+B | Standard across Office, applies to the selected cells' text. |
| Open Format Cells dialog | Ctrl+1 | Cmd+1 | Opens the full formatting dialog (number format, borders, fill, alignment) in one keystroke instead of hunting through ribbon tabs — arguably the highest-value single shortcut in Excel for anyone doing serious formatting work. |
| Apply currency format | Ctrl+Shift+$ | Cmd+Shift+$ | Quickly formats selected cells as currency with two decimal places, without opening the Format Cells dialog. |
| Apply percentage format | Ctrl+Shift+% | Cmd+Shift+% | Formats the selection as a percentage with no decimal places — note it does not multiply the underlying value, so a cell showing 0.5 becomes 50%, not 0.5%. |
| Add outline border | Ctrl+Shift+& | Cmd+Option+0 | Draws a border around the selected range without opening the border picker, useful when boxing off a summary table quickly. |
| Clear formatting | Alt+H, E, F (no single default key) | no default; assignable | Excel has no single dedicated key for this by default in either OS — most people use the Home ribbon's Clear > Clear Formats, or assign a custom shortcut via Quick Access Toolbar. Worth knowing it's not a built-in gap in your memory; it genuinely isn't bound. |
| Toggle italic | Ctrl+I | Cmd+I | Applies or removes italic formatting on the selected cells' text, standard across every Office application and consistent with the same shortcut in Word and PowerPoint. |
| Toggle text wrapping | Alt+H, W (ribbon access keys) | Format Cells > Alignment > Wrap text | Toggles whether text that's too long for a cell's width wraps onto multiple lines within that cell (increasing row height as needed) rather than overflowing visually into adjacent cells or getting cut off at the cell boundary. |
Ctrl+1 (Cmd+1 on Mac) opens Format Cells, the dialog containing number formats, font, border, fill, alignment, and protection settings all in one place. Experienced Excel users reach for this constantly rather than navigating ribbon tabs, because it's faster to type Ctrl+1 and click through tabs in the dialog than to locate the right ribbon icon for a less common format like a custom accounting number format or a diagonal border.
The quick-format shortcuts — Ctrl+Shift+$ for currency, Ctrl+Shift+% for percentage, Ctrl+Shift+# for date, Ctrl+Shift+@ for time, Ctrl+Shift+! for a generic number format with thousands separator — apply a default version of each format without opening any dialog. They're fast but inflexible: Ctrl+Shift+$ always applies two decimal places and your system's default currency symbol, so if you need a different currency or zero decimals, you'll still need Ctrl+1 afterward to adjust it.
A common point of confusion: applying Ctrl+Shift+% to a cell that already contains a decimal value like 0.5 displays it as 50%, because percentage formatting doesn't change the underlying stored value, only how it's displayed — it assumes the stored number is already the percentage in decimal form. Apply it to a cell containing the literal number 50 (intending fifty percent) and you'll get 5000%, which is a frequent source of spreadsheet errors when someone formats a column after typing the values rather than before.
There is no default keyboard shortcut for Clear Formatting or for Merge & Center in either Windows or Mac Excel — these are two of the few formatting actions that remain mouse/ribbon-only unless you build a macro and bind it to a custom key combination via the Quick Access Toolbar. It's worth knowing this isn't a gap in your shortcut knowledge; Microsoft genuinely never assigned default hotkeys to them.
Borders deserve a specific mention: Ctrl+Shift+& adds an outline border around the selected range on Windows, while the Mac equivalent is Cmd+Option+0. Neither lets you choose border style or thickness — for anything beyond a plain thin outline, you're back to Ctrl+1 and the Border tab.
Ctrl+I applies or removes italic formatting exactly the same way it does in every other Office application, a small but consistent shortcut worth knowing simply because it transfers directly from Word or PowerPoint muscle memory without any adjustment.
Wrap text, while lacking a single default keyboard shortcut, is worth knowing about alongside the other formatting shortcuts here since it solves a common layout problem — long text content in a cell either overflows visually into neighboring cells (if they're empty) or gets visually truncated at the cell boundary (if they're not), neither of which is ideal for readability. Toggling wrap text instead lets that content flow onto multiple lines within its own cell, automatically increasing the row's height to accommodate it, which is the standard fix for a table column containing longer text entries like descriptions or notes alongside shorter numeric columns.
Ctrl+1 opens the Format Cells dialog directly, giving access to number formats, alignment, borders, and fill color all from one tabbed dialog rather than hunting through several separate ribbon buttons individually, which is faster once you know the specific formatting combination you want to apply in one pass.