Rupee symbol dervied official recognisation in the year 2010. Windows 7 onwards it is supported in all versions. It was introduced in unicode as separate sybmol ₹. Unfortunately dedicated key like $ for ₹ symbol is not available in Keyboard. So, various methods to insert it in Excel are discussed in this article.

1. Open MS-Word
2. Write 20B9
3. Press Alt + X
4. Given text will convert to rupee symbol
5. Copy and Paste it in Excel

1. Write =UNICHAR(8377) in any cell
2. Copy and Paste-special the value wherever required

Excel-BI add-in supports one-click inserting of Rupee symbol. More details of this add-in can be found in below link
https://erpcloudanalysis.in/excel-bi/rupee-symbol