Microsoft Excel comes with lot of features, one of the them is changing currency, you don’t need to add any add-ons or codes, its built-in feature of excel, you can easily change currency format and this option available in all the version of MS Excel like 2007, 2010, 2013 & 2016. Just follow these easy step to know how to auto add Indian Rupee symbol for cells in MS Excel.
1. Select column, row or cell click on “Home” click “General” negative and click on “More Number Formats”
2. In number select “Currency” extend “symbol” drop down menu, go down and select “English (India)” and click on “Ok”
3. Do this to your required cells or select column or rows.
Watch video tutorial… Please like, share & subscribe