Ever since the introduction of Rupee symbol, usage is also increased. When we type, we would like to use Rupee symbol rather than Rs. I have already made a tutorial on how to type rupee symbol in keyboard windows. That post is useful if you want to write rupee symbol in MS word or blogging platforms such as blogger, WordPress etc.
However, if you want to use Rupee symbol in Excel 2010, there is a simple way than that. You can easily insert rupee symbol in excel spreadsheet by choosing the currency symbol rupee in the format tab. There is no need to install any update or any change of keyboard layout if you want to use Rupee symbol in excel 2010. Just follow the steps given below.
Steps to Insert Rupee Symbol in Excel Worksheets
Step1: Enter the values as desired.
Step2: Select the cells which you want to insert rupee cell.
Step 3: Right click and go to format cells.
Step 4: Select Currency from the category. In the symbol drop down, scroll down till you see ₹ English (India).
Step 5: Click Ok. Your cells are converted into currency and it shows along with the rupee symbol.
Hope this help on inserting rupee symbol in excel. If you have any difficulties, please share in the comment section.
- If you are not able to find English (India) under the symbol, then you need to install the keyboard layout and make it as default.
- If you want to enter Rupee symbol while entering in the cell, you can use shortcut key Ctrl+Alt+$(4) combination.
- If you want to update many rows, then you need to use the method which I have mentioned above.
- This method of typing Rupee symbol works with Excel 2016 also.