Insert a Division Symbol in Microsoft Excel

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).

oii

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:

Select the cell where you want to insert the symbol and click Insert > Symbol under Symbols option
rt

In the Symbol window, find the symbol, and then double click it or click the Insert button to insert it into the selected cell.

tyt

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.

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube