How to Insert Indian Rupee Symbol in Microsoft Excel

Microsoft Excel is a powerful tool for financial and business calculations. However, inputting the Indian Rupee symbol (#8377;) can sometimes be tricky. This guide will explore five methods to insert the Indian Rupee symbol into your Excel sheets with ease.

Method 1: Using Keyboard Shortcut

Steps: Place your cursor in the cell where you want to insert the symbol. Hold down the Alt key and type 8377 on the numeric keypad (not the numbers at the top of the keyboard). Release the Alt key, and the Indian Rupee symbol should appear.

Method 2: Using Character Map

This method works best if your keyboard does not have a numeric keypad.

Steps: Open the Character Map application on your computer. Search for it in the Start menu. In the Character Map, check the box for Show Symbol. Select the INR symbol and click Select. Navigate back to Excel and paste the symbol using Ctrl V.

Method 3: Insert Symbol

This method is more detailed and allows for customization.

Steps: Select the cell where you want to insert the symbol. Go to the Insert tab on the Ribbon. Click on Symbol on the far right. In the Symbol dialog box, select the font you are using, e.g., Arial Unicode MS. Scroll through the list or select 20B9 (the Unicode value for the Indian Rupee symbol) and then click Insert.

Method 4: Formatting Cells

This method is useful when you want to format an entire range of cells with the Indian Rupee symbol.

Steps: Select the cells that you want to format. Right-click on the selected cells and choose Format Cells. In the Format Cells dialog, go to the Number tab. Select Currency or Accounting from the list.

Method 5: Copy and Paste

For frequent use, you can copy the Indian Rupee symbol from any web page or document where it appears, and paste it directly into your Excel sheet.

Steps: Copy the Indian Rupee symbol from any web page or document. Paste it into your Excel sheet using Ctrl V.

Tips and Tricks for Frequent Use

If you frequently need to use the Rupee symbol, consider creating an AutoCorrect entry:

Steps: Go to File > Options > Proofing > AutoCorrect options. In the AutoCorrect dialog box, enter rupee in the Replace field and the Indian Rupee symbol in the With field. Click Add and then OK. Now, you can use rupee to insert the Indian Rupee symbol in your Excel sheets.

Conclusion

Inserting the Indian Rupee symbol in Microsoft Excel has never been easier, thanks to these five methods. Whether you prefer using a keyboard shortcut, the Character Map, or the Insert Symbol dialog, you can now seamlessly include this currency symbol in your financial calculations and reports.