So you can use the below formula to get the degree symbol in a cell in Google Sheets: =CHAR(176)īelow are the steps to use this formula to get the degree symbol in Google Sheets: Google Sheets has a CHAR function that can be used to quickly get a symbol by giving its ASCII code.Īnd in case of a degree symbol, that code is 176. Double click on the specific cell where you want to insert it.īelow is the degree symbol that you can copy and paste in a Google Sheets cell: ° Insert Degree Symbol Using the CHAR Formula.Copy the degree symbol already available in your Google sheet or simply copy it from a web page on the internet.
Perhaps the easiest way to insert a degree symbol in a Google spreadsheet is by copying and pasting it. You can simply copy the symbol and paste it in a specific cell(s). Pro Tip: Once you have used this keyboard shortcut to insert a degree symbol in the Google spreadsheet, you don’t have to repeat the steps every time you need to add the symbol. If you don’t have a numeric keypad, press the Num Lock key on the keyboard to enable it and then use this keyboard shortcut. Important: Please note that the keyboard shortcut will only work if you have 10 keys in the numeric keypad on your keyboard.
0 kommentar(er)
