Excel Shortcut Keys for Symbols on Windows and Mac

In Excel for Microsoft 365 on Windows, you can enter many symbols with an Alt code on the numeric keypad—for example, hold Alt and type 0176 to insert °—or use Insert > Symbol to find a character. On a Mac, use the Character Viewer; Windows Alt codes do not work the same way there.

Which symbol shortcut should you use?

The quickest method depends on whether you know the symbol’s code, how often you need it, and which version of Excel you are using. For a familiar character such as a degree sign, a Windows Alt code is fast. For an uncommon mathematical, currency, or language character, the Symbol dialog or your operating system’s character picker is easier to search. If you need a symbol repeatedly in a report, you can also copy it from a reliable source or use number formatting when the symbol is only a display label.

Known Windows code: Hold Alt, enter the digits using the numeric keypad, then release Alt.
Unknown or less common character: Choose Insert > Symbol and browse or search the available characters.
Mac: Press Control+Command+Space to open Character Viewer, then insert the selected character.
One-off entry in a browser: Copy and paste the character, or use the operating system’s symbol picker.

These methods insert a character into the cell; they do not create a special Excel command or change the cell’s underlying value rules. That distinction matters when you later sort, calculate, or format the data.

Windows Alt codes for common symbols

To use an Alt code in desktop Excel for Windows, select a cell or click where you want the character while editing a cell, hold down Alt, type the code on the numeric keypad, and release Alt. Many familiar Windows codes use a leading zero. The number row above the letters is not a substitute for the numeric keypad, and laptop layouts may require a separate embedded keypad or another device-specific method.

Alt+0176: degree sign, °
Alt+0177: plus-minus sign, ±
Alt+0169: copyright sign, ©
Alt+0174: registered sign, ®
Alt+0165: yen sign, ¥
Alt+0128: euro sign, €
Alt+0215: multiplication sign, ×
Alt+0247: division sign, ÷
Alt+0150: en dash, –
Alt+0151: em dash, —

These are Windows character-entry codes, not Excel-only shortcuts. Results can depend on the Windows input setup, keyboard, and font. In particular, Alt-code conventions can involve legacy character encodings, so do not assume that every Unicode character has a convenient Alt code. If a code does not produce the expected character, use Insert > Symbol instead of trying random numbers.

Insert a symbol from Excel’s Symbol dialog

In the Windows desktop app, click the cell, open the Insert tab, and choose Symbol in the Symbols group. In the dialog, choose a font and, where available, a subset; select the character and click Insert. You can insert more than one character before closing the dialog. The character code field can help locate a character when you know its code, but check the displayed character before inserting it because the available set depends on the chosen font and encoding.

The dialog is useful for Greek letters, currency signs, arrows, mathematical operators, and accented characters that are awkward to type. Try a font with broad character coverage if a selected symbol appears as an empty box or a different glyph. After insertion, the cell usually uses the character’s font like other text, so changing the font can affect how it displays.

Excel keyboard access keys and ribbon labels can vary with the interface language and software updates. Rather than relying on an assumed sequence of letter keys, use the visible Insert tab and Symbol command. If you use the dialog often, Excel’s Recently Used Symbols area can make repeat insertion quicker.

Windows and Mac shortcuts are different

Windows Alt codes rely on Windows keyboard input behavior and a numeric keypad; they are not a portable Excel shortcut. On a Mac, press Control+Command+Space to open Character Viewer in apps that support it, search for a character, and insert it. Depending on macOS settings and the app, the viewer may appear as a compact panel or a larger character window. You can also use macOS text substitutions or copy and paste a character when that is more convenient.

Excel for Mac has its own menus and keyboard conventions. Do not substitute Option-number combinations for Windows Alt codes: those combinations can produce different characters depending on the keyboard layout. For a particular symbol, Character Viewer is the more dependable approach. If you are following instructions written for Windows, check the platform before treating a shortcut as universal.

Excel for the web runs in a browser and does not provide the same full desktop Symbol dialog in every interface. When the command is unavailable, use the operating system’s picker or paste the character into a cell. A workbook can display a symbol inserted on another platform, but the result still depends on the selected font and whether the character is supported.

Symbols, numbers, and cell formatting

A symbol typed directly beside digits often makes the cell text rather than a numeric value. For example, entering 25° as text is convenient for a label, but Excel may not treat that cell as the number 25 in calculations. If you need to calculate with the measurement, keep the value numeric and display the unit through a custom number format.

For example, enter 25 as the value, open Format Cells, choose Number > Custom, and use 0"°" as the custom format. The cell displays 25° while its stored value remains 25. A format such as 0" °C" displays a space and °C after a number. The quotation marks in these format codes tell Excel to display the enclosed characters literally; they are not part of the displayed result.

Use a real currency number format for monetary values rather than typing a currency symbol into every number. Formatting preserves the numeric value and makes consistent display easier, although a currency sign by itself does not convert one currency into another. For headings, notes, or a copyright notice, inserting the symbol as text is usually appropriate.

Choosing a method for repeated use

For a symbol used once, the Symbol dialog, Character Viewer, or copy and paste is usually sufficient. If you enter the same symbol frequently, consider how the workbook will be shared and maintained:

Use an Alt code when you are on Windows, know the code, and have a usable numeric keypad.
Use the Symbol dialog when you need to inspect characters, browse a category, or choose a less familiar glyph.
Use Character Viewer on Mac, or your operating system’s picker when a desktop or web version lacks the needed dialog.
Use a custom number format when the symbol is a unit or label attached to a numeric value and calculations must continue to work.
Use a lookup table or controlled copy-and-paste list when a team needs consistent symbols across many entries.

When sharing a workbook, prefer common characters and widely available fonts. A symbol may be stored correctly but render differently on another computer if its font is missing or does not include that glyph. If a symbol carries meaning in a data column, consider adding a clear text label or documentation so the workbook remains understandable to readers who see a fallback character.

Common problems and fixes

If an Alt code produces nothing, first check that you are holding Alt while typing the digits on the numeric keypad, then release Alt after the last digit. Check Num Lock and the laptop’s keypad instructions. Some keyboards require a separate numeric keypad; the number row above the letters generally will not perform the same Alt-code entry.

If the wrong character appears, make sure you used the intended code, including any leading zero, and try the Symbol dialog. If the character appears as a box, select a font that supports it. If it looks like a different symbol, check the font and the workbook’s platform before assuming the character was entered incorrectly.

If a number stops calculating after you add a symbol, the entry may have become text. Remove the typed symbol and apply an appropriate custom number format instead. If you only need to display the symbol in a heading or note, text is fine; the issue matters when the cell must behave as a number in formulas, sorting, or charting.

Frequently Asked Questions

What is the shortcut for the degree symbol in Excel?
On Windows, hold Alt and type 0176 on the numeric keypad to enter °. On Mac, open Character Viewer with Control+Command+Space and search for degree.

Can I type a symbol using the number keys above the letters?
For Windows Alt codes, use the numeric keypad rather than the ordinary number row. Some laptops have an embedded keypad activated by a function key, but the exact method depends on the keyboard.

Does Excel have a shortcut to open the Symbol dialog?
The reliable route in desktop Excel for Windows is Insert > Symbol. Ribbon access-key sequences may vary by language or version, so use the visible command if a remembered key sequence does not match your installation.

How do I insert a symbol in Excel for Mac?
Press Control+Command+Space to open Character Viewer, search for the symbol, and select it. Windows Alt codes are not generally interchangeable with Mac keyboard shortcuts.

Why does Excel treat my number with a symbol as text?
Typing a symbol directly into the same cell can make the entry text. Keep the value numeric and use a custom number format to display a unit, such as a degree sign, when you still need to calculate with it.

Will a symbol display the same on every computer?
Usually, common symbols display consistently, but appearance can vary with fonts, operating systems, and character support. For shared workbooks, use a widely available font and check the file on the systems your readers use.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.