how do you do the degree symbol on a mac

You can use the =CHAR(176) to get the degree symbol in a cell in Excel. To do this, you first need to copy it from a degree symbol already available in Excel, or you can copy it from any web page from the internet.īelow is the degree symbol from which you can copy: ° Using the CHAR Formula You can copy and paste the degree symbol in Excel. You can simply copy the already inserted degree symbol and paste it. Once you have typed the degree symbol, you don’t even need to use the keyboard shortcut again and again. If you don’t have a numeric keypad, you need to enable the Num lock first and then use this keyboard shortcut. Note: This keyboard shortcut works only if you have a 10 keys numeric keypad in your keyboard.

Use the keyboard shortcut – ALT + 0176 (you need to hold the ALT key and then press 0176 from the numeric keypad of your keyboard).

Select the cell in which you want to insert the degree symbol.

Let’s get started! Using a Keyboard Shortcutīelow are the steps to type the degree symbol in Excel using a keyboard shortcut: The method you choose would depend on how you are using the degree symbol in your work. In this tutorial, I will show you these easy ways to do it (including a keyboard shortcut).

BONUS: Using VBA to Add Degree Symbol to Numbers.

Want more? Check out all the Google Sheets Tutorials. In this tutorial, I covered how to make a degree symbol on Google Sheets. This splits the string in half and uses the ampersand character to add in the CHAR() function that generates the degree symbolĮxample Spreadsheet: Make a copy of the example spreadsheet Next, click on the location you want to insert the degree symbol and type the following, including the quotation marks at the beginning and end: “& CHAR(176) &”. Do this by double clicking on the cell to edit it, then adding an equals sign at the start of the text to denote the start of a formula and wrapping the text in quotation marks, as in the image below

To use the CHAR function you’ll need to convert the text surrounding the symbol into a string formula. The CHAR() function allows you to insert characters by using their unicode number, in this case the number 176. Hit CTRL + V on Windows or CMD + V on Mac to paste the copied degree symbol at the cursor locationĪnother method for adding the degree symbol is to use the CHAR() function. This will be CTRL + C on Windows or CMD + C on Mac Step 2ĭouble click on the cell you want to add the symbol to to enter edit mode, then click where you want to insert the symbol to move the cursor there

Select the degree symbol and use your computer’s copy keyboard shortcut to copy it. You can either search for it on the internet or copy it from here: °.

The simplest method to insert a degree symbol is to copy and paste it into you spreadsheet following these steps: Step 1Ĭopy a degree symbol.

How do you do the degree symbol on a mac