Yes, you can type squared (²) in Excel. But if you’re copying it from Google or pasting from Word, you’re slowing yourself down and risking formatting corruption.
The Problem
You’re building a sales dashboard. Column D shows "Area (m²)", but your colleague typed "Area (m2)" in D1, "Area m2" in D2, and "Area (sq m)" in D3. Later, someone filters by "m2" and misses rows with "sq m". Worse — when you paste that header into Power BI, the inconsistent labels break your data model.
Here’s what your raw header row actually looks like right now:
| Cell | Content | Issue |
|---|---|---|
| D1 | Area (m2) | No superscript — looks unprofessional |
| D2 | Surface (cm2) | Inconsistent unit, plain '2' |
| D3 | Floor Space (sq ft) | Non-standard; can’t be parsed numerically |
| D4 | Volume (m3) | Cubic, not squared — wrong exponent |
| D5 | Area (m²) | ✅ Correct — but only one cell |
The Solution
Do this — not three different things. Pick one method and stick with it across your workbook.
- Type m2 in the cell (e.g., A1).
- Select just the 2 — click and drag over it, or press Shift + → once after typing.
- Press Ctrl + 1 to open Format Cells.
- Go to the Font tab (Alt+O+F), check Superscript, then click OK.
That’s it. No copy-paste. No Unicode memorization. No Add-Ins.
Here’s how your cleaned-up header looks after applying it consistently:
| Cell | Content (Formatted) | Notes |
|---|---|---|
| D1 | Area (m²) | Superscript applied to '2' only |
| D2 | Surface (cm²) | Same steps — works for any unit |
| D3 | Roof Area (ft²) | Even with spaces — select only the '2' |
| D4 | Wall Area (m²) | Consistent capitalization & spacing |
| D5 | Plot Size (ha) | Not squared — left as-is (see next section) |
Going Further
You don’t always need to format manually. For repeated use, build a quick reference:
- Type Alt+0178 on the numeric keypad (not top row numbers) to insert ² directly — works in any cell, even during editing.
- In formulas, use
CONCATENATE("m",CHAR(178))or"m"&CHAR(178)— e.g.,=B2&CHAR(178)in C2 where B2 contains "m". - For chart axis titles: double-click the title → select the '2' → Ctrl+1 → Font → Superscript. Don’t try to edit it in the formula bar — it won’t apply.
Surprising tip: If you type m2 and then immediately press Enter, Excel will *not* auto-superscript it — but if you type m2, press F2 to edit, highlight the 2, and hit Ctrl+1, it applies instantly. That F2 step is the key most people skip.
When NOT to Use This
Squared symbols belong in labels — not in data cells meant for calculation.
If column E holds actual area values like 124.5, 89.2, 217.8, do not type 124.5 m² in E2. That makes the cell text, not numeric. You’ll break SUM(), AVERAGE(), and pivot tables.
Instead: keep numbers clean in E2:E1000, and put units separately — like "m²" in E1 (formatted), or better yet, in a dedicated header row or a footnote cell like Z1.
Also avoid superscript in: cell comments (they ignore formatting), data validation dropdowns (superscript chars may render tiny or cut off), and exported CSV files (the ² becomes or ?).
And never apply superscript to an entire cell full of numbers — e.g., 12.5² is ambiguous. Is it “12.5 squared” (156.25) or “12.5 with a superscript 2”? Use formulas for math: =12.5^2.
Keyboard Shortcuts
Memorize these — they save seconds every time. Practice them now in a blank sheet.
| Action | Shortcut | Notes |
|---|---|---|
| Open Format Cells | Ctrl + 1 | Works anywhere — cell, chart element, shape |
| Insert ² symbol | Alt + 0178 | Num Lock ON; use keypad only |
| Edit cell content | F2 | Required before selecting part of text to format |
| Select next character | Shift + → | Use after F2 to highlight the '2' |
| Apply superscript | Alt + O + F + S | Alt+O opens Home tab, F jumps to Font group, S selects Superscript |
