Meaning if you type pms (in lowercase), Word will not convert it into the Plus or Minus sign unless you type PMS (in uppercase). The Plus or Minus symbol you want to insert is in this category and should appear.Ĭlick on the AutoCorrect button to display the AutoCorrect window. Switch over to wherever you need the symbol, whether in MS Word, Excel, or PowerPoint, and press Ctrl V to paste. This allows you to select and copy several symbols at the same time. Youll see that the symbol appears in the Characters to copy text box. Plus or Minus symbol) will now appear on the Character map. Once you get the symbol into your document, you can always recopy and paste it as and when the need arises.

Press and hold the Alt key and type 241 using the numeric keypad. Use Fn key NumLk keys to turn on Num Lock on laptops without the numeric keypad. Now, using the Mac keyboard, Press Option Shift simultaneously. It is the alt code shortcut which is Alt241 (will be discussed in the next section). Just by pressing two or more keys simultaneously, you can easily insert such symbols into your work.įor instance, pressing Shift 7 keys give you the Ampersand () sign.Įspecially now that you are reading this step-by-step guide. That is to say that there are symbols readily available as second keys on the keyboard. Youll learn all the easy methods including the Plus or Minus Alt code shortcut.Īnd if you are using Windows, simply press down the Alt key and type 241 using the numeric keypad on the right side of your keyboard. Sometimes, we might use it only for a specific category of data, for example: To measure the temperature. Like, if you consider the situation where Cell A1 has the value 55, you can use the formula A1CHAR(176).Īfter you have done this youll clearly obtain the result as 55. Lets Consider an Example for an instance: You wish to discover 55 in a cell.

Another Formula can be used along with the other Text Strings or the Formulas for adding the degree symbol into it.

Degree symbol in excel shortcut keys