How to Insert a Degree Symbol in Excel: 7 Methods That Work Every Time

Learning how to insert a degree symbol in Excel is one of those small skills that pays off every time you work with temperature readings, geographic coordinates, angles, or scientific measurements. The degree symbol (°) is not on a standard QWERTY keyboard, so users often resort to copy-pasting from Google or substituting with the letter o. Excel actually offers at least seven reliable methods to insert this character, ranging from a one-second keyboard shortcut to dynamic formulas that generate the symbol automatically inside calculated cells.

This guide walks through every method that works in Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and Excel for the Web. Whether you are typing a weather log at 72°F, recording GPS coordinates at 40°N latitude, documenting a 45° pipe bend in an engineering spreadsheet, or formatting a chart axis with rotational data, you will find the right approach below. We will also cover how to format numbers so that the degree symbol appears automatically without you ever typing it, which is by far the most powerful trick for repeated data entry.

The most common reason people search for this skill is frustration. They type 90 and want it to display as 90°, but Excel either treats the symbol as text and breaks their formulas, or they cannot find the right Unicode character at all. The good news is that once you understand the difference between inserting the symbol as a literal character versus formatting a number to display the symbol, your workflow becomes dramatically faster. We will explain that distinction in detail because it matters for sorting, filtering, and using functions like vlookup excel users rely on for lookups.

Excel treats the degree symbol as Unicode character 176 (decimal) or U+00B0 (hex). Knowing that single fact unlocks several methods at once: the CHAR(176) formula, the Alt+0176 keyboard shortcut on Windows, and the Symbol dialog box where you can search by Unicode code point. On a Mac the shortcut is Option+Shift+8. We will demonstrate each technique with screenshots-worthy step-by-step instructions, plus the edge cases that trip up most beginners.

Beyond the basics, this article shows you how to build the degree symbol into custom number formats, so a cell containing the raw number 32 displays as 32°F without changing the underlying value. That means your SUM, AVERAGE, and conditional formatting rules continue to work perfectly. This is the technique used by meteorologists, surveyors, machinists, and HVAC technicians who handle hundreds of temperature or angle values per day in their workbooks.

We will also cover how to insert degree symbols inside chart titles, axis labels, header rows, and merged cells. Each of these contexts has slight quirks worth knowing. By the end of this guide, you will have a quick-reference toolkit you can apply in any Excel scenario without breaking your stride or interrupting your spreadsheet workflow. Bookmark this page, because the methods below scale from a single cell to a thousand-row dataset with equal ease.

Finally, we will compare each method's pros and cons, share a checklist of best practices, and answer the ten most frequently asked questions readers send us about Excel symbols. If you are preparing for an Excel certification or interview, the techniques here also appear regularly on assessments — so it is worth practicing them rather than relying on muscle memory for one approach alone.

The fastest way to insert a degree symbol in Excel on Windows is the Alt code: hold the Alt key, type 0176 on the numeric keypad (the leading zero matters), then release Alt. The ° symbol appears at your cursor. This works in cells, the formula bar, chart titles, text boxes, and shapes. The catch is that you must use the dedicated numeric keypad on the right side of your keyboard, not the number row above the letters. Laptop users without a numpad can enable Num Lock on the embedded function keys or use Fn+Alt+0176 depending on the manufacturer.

On macOS the shortcut is even simpler: Option+Shift+8. Three keys, no numeric keypad required, and it works identically in Excel for Mac, Word, Pages, Numbers, and most text fields throughout the operating system. macOS also offers a system-wide character picker via Control+Command+Space if you forget the shortcut, where you can search for "degree" and double-click to insert. Both methods place the symbol at the current cursor position without altering surrounding text or cell content.

If you are using Excel for the Web inside a browser, the Alt code does not work because the browser intercepts it. Instead, use Insert > Symbol from the ribbon, or paste from your operating system's character picker. Chromebooks have their own shortcut: Ctrl+Shift+U, then type 00b0, then press Enter or Space. This Unicode input method works in any Chrome OS text field including Google Sheets, which behaves similarly to Excel for many shortcuts but has its own quirks worth learning separately.

For repeated use, the smartest investment is AutoCorrect. Open File > Options > Proofing > AutoCorrect Options. In the Replace box type a unique sequence such as (deg) or //o, and in the With box paste a degree symbol you generated using any other method. Click Add and OK. From that point forward, whenever you type your trigger sequence in any Excel cell, the symbol appears automatically. This is by far the fastest method for users entering dozens or hundreds of degree values per day, such as meteorologists or surveyors.

Power users often combine the degree symbol with the CHAR function for dynamic labels. The formula =A2&CHAR(176)&"F" takes the number in A2 and appends °F, returning something like 72°F. Because the result is text, you cannot do arithmetic on it directly, but it is perfect for chart labels, report headers, and concatenated summary cells. If you need to format many cells with how to merge cells in excel layouts that display unit labels alongside numeric values, CHAR(176) gives you full programmatic control.

Excel's Symbol dialog is the slowest but most discoverable method. Go to Insert > Symbol, change the Font dropdown to (normal text), set Subset to Latin-1 Supplement, and scroll until you see °. You can also type 00B0 into the Character code box at the bottom (with From: Unicode hex selected) to jump directly to it. Click Insert and Close. Excel remembers recently used symbols at the bottom of the dialog, so the second time you need it the symbol is one click away.

One subtle gotcha: when you paste a degree symbol from a website, sometimes you get the masculine ordinal indicator (º, U+00BA) instead of the true degree sign (°, U+00B0). They look nearly identical on most fonts but sort differently and may break lookups. Always verify by checking the Unicode code point — UNICODE("°") should return 176. If it returns 186, you have the wrong character and should replace it using Find and Replace across your workbook before continuing with downstream analysis.

Custom number formatting is where Excel power users separate themselves from casual users. Instead of typing 72°F as text into every cell — which breaks every numeric formula downstream — you store the number 72 and tell Excel to display it as 72°F. Press Ctrl+1 to open Format Cells, choose Custom from the Category list, and enter 0"°F" in the Type box. Click OK. The cell now shows 72°F but the underlying value is still 72, ready for SUM, AVERAGE, MAX, or any other calculation.

The quotation marks around °F are critical because they tell Excel to treat that portion as a literal text suffix rather than a format token. You can use any text inside the quotes: 0"°C", 0.0"°", or even #,##0.00"° Celsius". The leading 0 or # controls how the number portion displays. Use 0 to force at least one digit, 0.0 to force one decimal, and #,##0 to add thousands separators for large angle measurements like compass bearings in surveying datasets.

For directional readings such as GPS coordinates, you can build elaborate formats like 0"° N";0"° S";0"° " which displays positive numbers as 40° N and negative numbers as 40° S automatically. The format string has up to four sections separated by semicolons: positive; negative; zero; text. This conditional display is incredibly powerful for compass headings, temperature differentials, latitude and longitude pairs, and any data where the sign of the number conveys directional meaning to the reader.

If you need to apply the same format to hundreds of cells, select the entire column header before opening Format Cells. The format then applies to every existing and future entry in that column. This is exactly the same principle behind how to freeze a row in excel — apply once, benefit forever. You can also save your custom format as a cell style via Home > Cell Styles > New Cell Style, making it reusable across multiple workbooks with a single click in the style gallery.

One scenario where text insertion beats custom formatting is when different cells in the same column need different units. For a weather log mixing °F readings and wind speed in mph, you cannot apply a single format to the whole column. In that case, type the values as text using CHAR(176): ="72"&CHAR(176)&"F". Or split into two columns — one numeric column with format 0"°F" and another for wind speed. Splitting is almost always cleaner and easier to maintain over time.

Conditional formatting also plays beautifully with custom number formats. You can highlight temperatures above 90°F in red while keeping the ° symbol visible, because Excel evaluates the underlying number, not the displayed text. Go to Home > Conditional Formatting > Highlight Cell Rules > Greater Than, enter 90, and choose a fill color. The cosmetic ° suffix has zero impact on the rule. This is the single biggest reason to prefer formatting over text — every downstream Excel feature continues to behave normally.

Finally, custom number formats survive copy-paste within Excel as long as you paste cells (not values). Paste Special > Values only pastes the raw number and discards the format, so the ° disappears. Paste Special > Formats only copies the format without the data. Knowing these paste options helps you migrate formatted data between workbooks without losing the visual polish you carefully set up in the source spreadsheet.

Let's walk through the real-world use cases where inserting a degree symbol matters most. Meteorology and weather logging is the obvious one: a station recording hourly temperatures uses a column formatted as 0"°F" so AVERAGE and MAX work correctly across thousands of rows. Pair this with how to add filter in excel functionality and you can quickly isolate readings above a threshold. The same principle applies to HVAC technicians logging supply and return air temperatures across hundreds of zones in commercial buildings.

Engineering and machining workflows depend on accurate angle notation. A CAD operator preparing a tolerance sheet might list 45°, 30°, and 60° bends, where the degree symbol is essential for clarity. Using CHAR(176) inside formulas lets the engineer combine numeric tolerance values with the symbol dynamically. This avoids transcription errors and keeps the source numbers available for downstream calculations like trigonometric conversions using SIN, COS, and TAN, which all expect radians, not degrees — so RADIANS(A2) becomes a critical companion function.

Surveyors and GIS professionals routinely handle latitude and longitude formatted as degrees, minutes, seconds. A typical entry like 40°26'46"N combines three special characters: the degree sign, the minute prime ('), and the second double prime ("). Build a helper formula: =INT(A2)&CHAR(176)&INT((A2-INT(A2))*60)&"'"&ROUND(((A2-INT(A2))*60-INT((A2-INT(A2))*60))*60,0)&CHAR(34)&"N" to convert decimal degrees stored in column A into formatted DMS notation suitable for nautical charts or land deeds.

Scientific and academic reports often demand consistent unit notation throughout the document. A chemistry student logging reaction temperatures wants 25°C, not "25 deg C" or "25 Celsius." Setting up AutoCorrect to replace (degc) with °C and (degf) with °F speeds up data entry tenfold. Combined with named ranges and structured tables, this turns a chaotic lab notebook into a publication-ready dataset. Many universities provide Excel templates with these formats pre-applied, but knowing how to build them yourself is far more empowering.

Sports analytics is a less obvious but growing use case. Track and field analysts log javelin throw angles, golf shot trajectories, and skateboard rotation degrees. Esports analysts even log mouse sensitivity in degrees per inch. In all these scenarios, the degree symbol provides instant visual context that bare numbers lack. A chart axis labeled "Launch Angle" with values displayed as 35°, 40°, 45° tells the story far better than 35, 40, 45 without units.

Real estate and property documents occasionally include solar exposure angles, lot orientation bearings, and roof pitches measured in degrees. A property listing template in Excel can include a formatted cell showing "South-facing lot, 12° pitch roof" pulled from raw numeric inputs elsewhere in the sheet. This kind of templated reporting saves agents hours of manual formatting per week and ensures consistency across hundreds of listing sheets without typos or formatting drift.

Finally, journalism and data visualization workflows benefit enormously from clean degree symbols in chart titles, axis labels, and annotation callouts. When a journalist exports a chart from Excel to PowerPoint or to a publishing platform, the degree symbol must render correctly across fonts and operating systems. Sticking to the true Unicode degree sign (U+00B0) rather than substitutes guarantees the symbol survives every export, embed, and screenshot from initial spreadsheet to final published page on print, web, or mobile.

Now let's wrap up with practical tips and final preparation advice for making the degree symbol a frictionless part of your Excel workflow. First, decide once and for all whether you prefer keyboard shortcuts, AutoCorrect, or custom formatting as your default approach. Pick one and commit. Switching back and forth wastes mental energy. For most users handling occasional degree entries, the Alt+0176 shortcut on Windows or Option+Shift+8 on Mac is the right default because it is universal and requires no setup.

For users entering more than ten degree values per day, set up an AutoCorrect entry immediately. The five-minute setup pays for itself within the first week. Pick a trigger that is short but unlikely to appear in normal text — (deg), ddeg, or \d all work well. Avoid common letter combinations that might appear inside real words. Test the trigger in a blank cell to confirm Excel replaces it instantly. Repeat the setup on every computer you use, since AutoCorrect settings are stored per-machine, not per-workbook or per-account.

If you share workbooks with colleagues, document your custom number formats in a README sheet inside the workbook. List the format codes you used and explain why. A simple table with columns Format Code, Example Output, and Purpose makes the file self-documenting. Future collaborators will not accidentally overwrite your carefully crafted 0"°F";0"°F";0"°F";@ format with a generic Number format that strips the symbol from every cell in the column overnight.

Practice the methods using a small sandbox workbook before deploying them in important documents. Create a sheet with ten temperature values, apply each insertion method to a different cell, and verify the results with =UNICODE() to confirm you have the true degree sign. This ten-minute drill cements the muscle memory and helps you catch the º vs ° trap before it ever appears in a client-facing report or a published academic paper.

When troubleshooting issues, the first check is always: is the cell text or number? Use =ISNUMBER(A2) to verify. If it returns FALSE, you accidentally typed the degree as part of the value, making the whole cell text. Either reformat using the custom format approach, or use VALUE() and SUBSTITUTE() to strip the symbol and convert back to number. Another common issue is conditional formatting that no longer triggers — usually caused by mixed text and number entries in the same column from inconsistent insertion methods.

If you use Excel for an Excel certification exam, the MO-200 or MO-201 Microsoft Office Specialist tests sometimes include questions about inserting symbols, custom number formats, and CHAR functions. Practicing the techniques in this article directly maps to exam tasks. Even outside formal certification, fluency with special characters is a hallmark of intermediate-to-advanced Excel users and consistently impresses interviewers during data-related job assessments and technical screening conversations.

Bookmark this guide, share it with teammates, and revisit the custom number format section whenever you start a new spreadsheet project that involves temperatures, angles, coordinates, or any other degree-based measurements. With seven methods at your fingertips, you will never again copy-paste from Google or substitute a lowercase o for the degree symbol. Your spreadsheets will look professional, your formulas will work flawlessly, and your colleagues will quietly wonder how you make everything in Excel look so clean and effortless every single time.