Type Rupee Symbol in Excel 2010

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.

Recommended Reading:

Type INR Symbol in Word

Conditional VLOOKUP in EXCEL

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.

Note:
  • 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.

Video guide on how to use Rupee Symbol in EXCEL

5 comments… 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 ?
    drkarasheed@gmail.com

  • Chandan Jun 6, 2018, 6:25 am

    I am using Office 2016 and I have selected Currency English (India) but some Rectangular Box is coming instead of the Rupee Symbol as shown below:
    ₹ 100.00
    ₹ 1,000.00
    ₹ 200.00
    ₹ 2,500.00
    Please advise.

  • Ravi Oct 4, 2018, 1:43 pm

    Any suggestions on how to get comma formatting for lakhs. I would like to use 1lk as:
    ₹1,00,000. Right now I see it as ₹100,000.
    How do I fix this?

    • Hany R. Dec 23, 2018, 11:09 pm

      A) Select all the cells where you want the numbers to then display in Lakhs and Crores (let’s say entire D column).
      B) Right-click and go to ‘Format cells’ (shortcut to go to format cells is Ctrl + 1).
      C) Select ‘Custom’ and in the ‘Type’ box, type this.
      [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0.
      D) Press Ok.
      E) Enjoy

      • Samir Mar 15, 2019, 2:03 am

        The above formula works great – thanks but it does not display the Rupee symbol. How can I have the lakhs and crores format and have the Rupee symbol?

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.