Format Excel cells on Mac without changing their meaning
Command-1 opens the Format Cells dialog in Excel for Mac. Command-B, Command-I and Command-U apply bold, italic and underline. A display format changes how a value appears; it should not be treated as proof that the underlying data is correct.
Microsoft Excel · Reviewed 2026-11-05 · Review method
Platform, keyboard and verification notes
- Scope
- Microsoft Excel · Microsoft Excel desktop for Mac; Mac section of Microsoft documentation checked 5 November 2026. Not Excel for the web.
- Keyboard and customization
- English documentation and US-style key names. Punctuation and function keys can differ on other layouts.. These are documentation-backed defaults, not a hands-on test. App settings, operating-system shortcuts, extensions and keyboard layout can change what happens. Check focus and the current app menu or shortcut settings when a binding differs.
- Review basis
- Documentation reviewed 2026-11-05 by Codex — source and editorial review; no runtime test. These bindings were not tested in a running app for this guide.
Mac shortcuts for this workflow
| Action | Keys | Context |
|---|---|---|
| Format Cells dialog | Command-1 | Inspect the selected cells and available format settings. Source ↗ |
| Bold | Command-B | Apply emphasis to the selected cells. Source ↗ |
| Italic | Command-I | Use for a deliberate presentation choice. Source ↗ |
| Underline | Command-U | Format the selection without altering its textual meaning. Source ↗ |
| Undo | Command-Z | Reverse an unintended formatting change. Source ↗ |
Start from the value and its unit
Decide whether a column represents money, dates, counts or something else before changing its display. A number format can make a value look plausible without correcting a wrong source or unit. Inspect the formula bar and a few sample cells, particularly when dates or percentages appear unexpectedly.
Use formatting consistently across a meaningful range
Select the intended data or header range before opening the dialog. Applying emphasis to a heading can help reading, while formatting every row differently makes comparison harder. Check whether totals, labels and data cells need different treatment instead of selecting the entire sheet merely because that selection is convenient.
Check the result at ordinary reading size
On a sample sheet, apply a format to a small range and compare it with an unformatted copy. Inspect both the visible value and the stored entry. If the result is confusing, undo before adding more formatting layers. A well-presented sheet should communicate what its values mean, not require the reader to infer meaning solely from decorative emphasis.
Sources and corrections
- Keyboard shortcuts in Excel — Microsoft Support, Mac section — checked 2026-11-05
Found a mismatch? Email pashaseenainc@gmail.com with your app version, macOS version, keyboard layout and the command. Please leave personal document names out.
Keep going
Right there when you need it.
Keep a compact shortcut reference in your Mac’s menu bar.
Explore the native Mac app