The plus-minus sign ± is a Windows-1252 character, so it has a real Alt code that works across Office: Alt+0177. Word also takes the Alt+X code 00B1, and Mac keyboards have it on Option + Shift + =. In Excel the interesting part is showing ± next to a number without breaking your formulas.
Quick answer
| Where | Fastest method |
|---|---|
| Word or Excel (Windows, numpad) | Alt+0177 |
| Word (Windows, no numpad) | type 00B1, press Alt + X |
| Word or Excel (Mac) | Option + Shift + = |
| Excel formula | =UNICHAR(177) |
| Excel number with ± in front | custom format “±“0.00 |
| Word equation | type \pm then a space |
| Anywhere | copy ± from the top of this page |
± in Word
Alt+0177 (Windows)
- Turn on Num Lock.
- Hold Alt and type 0177 on the numeric keypad.
- Release Alt. ± appears.
The leading zero matters: it picks the Windows-1252 table. Alt+241 (no zero, from the older CP437 table) also gives ± in most Windows apps. The number row above the letters does not work for either.
Alt+X (Windows)
Type 00B1 and press Alt + X. If the code follows a digit, as in 500B1, Word reads too many characters: type a space first, or select just 00B1 before pressing Alt+X. This works in Word and Outlook only.
Mac
Press Option + Shift + =. That works in Word, Excel and every other Mac app on the US keyboard layout. On other layouts, use the Character Viewer (Control + Command + Space, search “plus”).
Insert Symbol
- Windows: Insert → Symbol → More Symbols. Mac: Insert → Symbol → Advanced Symbol.
- Leave the font on (normal text). On Windows, type
00B1in Character code. - Click Insert.
Once used, ± sits in the Symbol drop-down for one-click reuse.
An AutoCorrect entry
Word has no built-in text shortcut for ±, but you can add one:
- Insert ± once and select it.
- Windows: File → Options → Proofing → AutoCorrect Options. Mac: Word → Preferences → AutoCorrect.
- Type
+-in Replace (± is already in With because you selected it) and click Add.
Now +- followed by a space becomes ±. Pick a different trigger if you type +- for other reasons.
In an equation
Inside an equation (Alt + = on Windows, or Insert → Equation), type \pm and a space for ±, or \mp for the minus-plus sign ∓.
± in Excel
Typing it in a cell
Alt+0177 works in a cell on Windows, and Option + Shift + = on a Mac. Alt+X does not work in Excel. For a formula, =UNICHAR(177) returns ±.
Show ± and keep the number
If you type ±2.5 into a cell, Excel stores text and the value drops out of sums and charts. A custom number format adds the sign for display only:
- Select the cells.
- Press Ctrl + 1 (Cmd + 1 on Mac) and choose Number → Custom.
- In Type, enter
"±"0.00and click OK.
The cell shows ±2.50 and still holds 2.5. Change 0.00 to 0.0 or 0 for fewer decimals, or use "± "0.00" mm" for a tolerance with units.
Mean ± deviation in one cell
To build a label such as 12.4 ± 0.8 from two cells:
=TEXT(B2,"0.0")&" ± "&TEXT(C2,"0.0")
The result is text, which is fine for a report table. Keep B2 and C2 as numbers for any calculation.
Error bars in charts
A chart’s ± range is not a character: select the chart and use Chart Design → Add Chart Element → Error Bars to show it graphically.
Troubleshooting
- Alt+0177 types nothing. Num Lock is off, or you used the number row. Use Alt+X in Word, or Option + Shift + = on a Mac.
- Excel will not add up the ± cells. They are text. Remove the ± from the cell contents and apply the custom number format instead.
- Alt+X turned my number into another character. The digits before the code were read as part of it. Select only
00B1and press Alt+X again.
For ± outside Office (phones, Google Docs, HTML), see how to type the plus-minus sign. The plus-minus symbol page has every code. For other characters in Word, see how to insert symbols in Word.
Frequently asked questions
What is the Alt code for ± in Word and Excel? +
Alt+0177. Turn on Num Lock, hold Alt, type 0177 on the numeric keypad and release Alt. It works in Word, Excel, PowerPoint and Outlook on Windows.
How do I type ± in Word without a numpad? +
Type 00B1 and press Alt + X. Word replaces the code with ±. On a Mac with the US keyboard layout, press Option + Shift + =.
How do I show ± in front of a number in Excel? +
Use a custom number format: Ctrl + 1 → Number → Custom, and enter "±"0.00. The cell shows ±2.50 but still holds 2.5, so formulas keep working.
How do I write mean ± standard deviation in an Excel cell? +
Join the two values as text: =TEXT(B2,"0.0")&" ± "&TEXT(C2,"0.0"). The result is text for display, so keep the original numbers in their own cells for calculations.