Type Rupee Symbol in Excel 2010

Ever since intriduction 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 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 goto 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 rupee symbol.
Hope this help on inserting rupee symbol in excel. If you have any difficulties, please share in the comment section.

Note:
  • If you are not able to find English (India) under symbol, then you need to install thay 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.

 

Meet the Author

Hi, I am Aniruddha, an avid blogger since 2008 who likes writing about new gadgets, smartphones and excel. You can find them at www.tech2touch.com. You can also follow me on Twitter @tech2touch or my Facebook page tech2touch. You can subscribe to my YouTube channel tech2touch. Enjoy reading and watching!!!

1 comment… add one
  • Dr. Rasheed Jun 19, 2013, 10:17 am

    But I do not see English India among the drop downs. Office version is 2010. My OS is Windows 8 installed with English India. Can I correct this ?
    [email protected]

Leave a Comment

Shares