In this article, we will learn how to add symbols and signs in Excel.
Excel is all about formulas and calculations. So it’s easy for the user to have some shortcut for some symbols. Here are a couple of tips to insert symbols in excel 2016.
We need to write division (÷) sign instead of forward slash(/). We often use this symbol in column headings and explanation notes such as Achieve revenue ÷ Target revenue. Since Excel uses the forward slash (/) as the division operator in calculating formulas, we can use the division symbol only in the text.
To enter the division symbol, use Alt +0 2 4 7 (from the numeric keypad of the keyboard).
|NOTE: You must use the numeric keypad and not the numbers on the top row of your keyboard.|
To add any other symbol, follow the steps as shown below:
In the Symbol window, find the symbol, and then double click it or click the Insert button to insert it into the selected cell.
Division symbol is inserted to the selected cell as shown below
Shortcut keys are easy instead of selecting multiple options. Hope you learned how to use the shortcut key for adding Division symbol and how to insert other symbols. Excel let’s you perform these shortcuts and functions in Excel 2013 and 2010. Read more content on Excel here. Please write your unresolved query and we will help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.