When tracking weather temperatures, geographic GPS coordinates, or technical laboratory measurements in Google Sheets, displaying the degree symbol (°) alongside numerical values is crucial for professional clarity. However, standard computer keyboards lack a dedicated degree key, leaving many users wondering how to insert the symbol quickly without copying and pasting it from search engines.
Google Sheets provides multiple clean methods to insert and display the degree symbol, ranging from dynamic spreadsheet formulas to non-destructive custom number formatting that preserves mathematical calculability. Here is how to insert a degree symbol in Google Sheets.
Method 1: Inserting the Degree Symbol Using the CHAR Function
The most reliable formulaic method to output a degree symbol in Google Sheets is using the native CHAR function with Unicode character code 176.
- Click into an empty cell where you want to output the symbol.
- Type the following formula:
=CHAR(176) - Press Enter. Google Sheets will evaluate the code and display
°.
To combine a numerical temperature cell with the degree symbol and unit letter (for instance, turning cell A2 containing 24 into 24°C), use the ampersand concatenation operator:
=A2 & CHAR(176) & "C"
Method 2: Using Operating System Keyboard Shortcuts
If you prefer to type the degree symbol directly into cells or formulas while editing text:
- On Windows: Double-click the cell, place your blinking cursor where you want the symbol, hold down the Alt key, type
0176on the numeric keypad, and release Alt. Alternatively, pressWin + .(full stop) to summon the Windows Emoji and Symbol picker, navigate to Symbols, and click°. - On Mac: Double-click the cell, hold down Option + Shift + 8 to type the degree symbol (or press Option + K for a smaller ring).
- On Chromebook: Press
Ctrl + Shift + U, type00b0, and press Enter.
Method 3: Preserving Math Calculability with Custom Number Formatting
A common pitfall of typing °C directly into a cell is that Google Sheets treats the entry as text, preventing you from calculating averages, sums, or maximums across the column. You can resolve this by applying a Custom Number Format, which visibly displays the degree symbol while keeping the underlying cell purely numeric.
- Highlight the temperature numbers in your sheet.
- Click on Format in the top menu bar, hover over Number, and select Custom number format at the bottom of the list.
- In the format input box, type the following pattern:
0"°C"(or0.0"°C"if you record one decimal place) - Click Apply.
Every number in your selected range will immediately display the degree symbol and Celsius indicator, yet formulas like =AVERAGE(A2:A50) will continue to calculate perfectly without returning a #VALUE! error.