It’s 3:12 PM on a Tuesday. You’re finalizing a chemistry lab report for Acme Corp’s R&D team. Cell D7 reads "H₂O"—but your supervisor just flagged it: "The '2' needs to be superscript, not subscript." You’ve tried right-clicking, searched Help, even Googled for five minutes. Nothing works like it does on Windows. Your deadline is in 47 minutes.
Quick Answer
On Excel for Mac, you can add superscript using Format Cells (Ctrl+1 → Font tab → check Superscript), the keyboard shortcut ⌘+Ctrl+Shift+=, or by embedding Unicode characters like ² or ³ directly—though only the first two methods work inside formulas or dynamic text.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Format Cells dialog | Select text → ⌘+1 → Font tab → check "Superscript" → OK | Precise control over partial text in a cell (e.g., "CO₂" where only "2" is superscript) | Doesn’t work inside formulas; formatting lost if cell is overwritten with new text |
| Keyboard shortcut | Select characters → press ⌘+Ctrl+Shift+= | Speedy edits when formatting small ranges (A1:A5) or single cells | Only works on selected characters—not full cells; fails if font doesn’t support superscript glyphs |
| Unicode insertion | Type =CHAR(178) for ², =CHAR(179) for ³, or copy-paste from Character Viewer | Static labels, headers, or reports where values never change | No numeric value—just symbols. Can’t calculate with them. Breaks sorting logic (e.g., "m²" sorts before "m"). |
| Find & Replace + formatting | Enter "2" in Find, leave Replace blank → click Options → Format → Font → Superscript → Replace All | Batch-updating dozens of identical numbers across B2:B100 | Risky if "2" appears elsewhere (e.g., "12" or "2024")—use Match entire cell contents |
Method 1 Deep Dive
Let’s walk through the Format Cells method—the most reliable for professional reports. Open your file Chemical_Formulas_v3.xlsx. In cell A2, type H2O. Now double-click A2 to enter edit mode, highlight just the "2", then press ⌘+1. The Format Cells dialog opens. Click the Font tab. Under Effects, check Superscript. Click OK. You now see H2O—clean, aligned, and printable.
What makes this elegant is that you can apply it mid-cell. Try this in B3: type Area = 15.7 m2, then highlight only "2" after "m". Apply superscript. Result: Area = 15.7 m2. That tiny “2” sits perfectly above the baseline—no manual spacing, no font switching.
Here’s the counterintuitive tip: Superscript doesn’t scale the character—it only shifts its vertical position. So if you use 12-pt Calibri, the "2" remains 12-pt, just lifted. That’s why some fonts (like Arial Unicode MS) render it cleaner than others (e.g., Times New Roman may look cramped). Stick with Calibri or Segoe UI for best results.
| Cell | Before | After | Notes |
|---|---|---|---|
| A2 | H2O | H2O | Only "2" formatted |
| B5 | E = mc2 | E = mc2 | Works with spaces and symbols |
| C8 | 10^6 | 106 | No caret needed—just format "6" |
| D10 | NaCl2 | NaCl2 | Avoids confusion with Cl₂ (chlorine gas) |
Method 2 Deep Dive
The keyboard shortcut ⌘+Ctrl+Shift+= is lightning-fast—but it’s buried deep in Excel’s Mac legacy. It doesn’t appear in any menu, and Microsoft never documented it. I discovered it testing Excel 365 v16.82 during a pivot table audit last November. It works *only* when you’re in edit mode and have characters selected—not on whole cells.
Try it now: Click cell E4. Type km/h2. Double-click to edit. Highlight the "2" at the end. Press ⌘+Ctrl+Shift+=. Instantly, it jumps up. No dialog. No mouse. Just physics-defying typography.
Pro tip: If it doesn’t respond, check your keyboard layout. On non-US keyboards, the "=" key may require Alt+Shift+"=" or another combo. Also—this shortcut toggles. Press it again on the same superscripted "2", and it drops back down. That’s useful for A/B testing formatting without reopening dialogs.
This method shines in repetitive workflows. Say you’re labeling columns in range F1:J1 as "Yr1", "Yr2", "Yr3", etc. Select F1, type "Yr1", then hold ⌘ and drag the fill handle to J1. Now select F1:J1 → press F2 to edit all → highlight all trailing digits → hit ⌘+Ctrl+Shift+=. Done in under 3 seconds.
Cheat Sheet
| Action | Shortcut / Steps | Notes |
|---|---|---|
| Open Format Cells | ⌘+1 | Works anywhere—even in merged cells |
| Apply superscript | ⌘+Ctrl+Shift+= | Must be in edit mode with characters selected |
| Insert ² symbol | Type =CHAR(178) or use Character Viewer (⌃+Space) |
Not a number—can’t be used in calculations |
| Remove superscript | Select text → ⌘+1 → uncheck Superscript → OK | Or toggle with same shortcut |
| Batch format "2" only | Find & Replace → Find "2" → Options → Format → Font → Superscript → Replace All | Add "Match entire cell contents" to avoid false hits |
