Excel Hack

Shortcut key for rupee symbol in Excel

If you want to insert the Indian currency symbol, the rupee sign, into an Excel spreadsheet, there are two ways to do so. You used to type RS to represent the currency symbol, but now that a new symbol for the Indian currency called the rupee has been introduced, you need to use the rupee symbol to represent the Indian currency symbol. Remembering the shortcut key to insert the rupee symbol in Excel is very helpful when you want to insert the Indian currency symbol.

Rupee symbol shortcut

Display the Format Cells dialog box

Windows
Ctrl + 1
Access Key: Alt + H + F + M

Mac
command + 1 or control + 1

Display the Symbol dialog box

Windows
Access Key: Alt + N + Z + S + U

Mac
None

How to apply the rupee symbol

This is a shortcut key to bring up the Format Cells dialog box and apply the rupee symbol for values.

Total Time: 2 minutes

Select cells with entered values

Select cells with entered values

Select the cells to which you want to apply the rupee symbol.

Select a currency

Select a currency

Press Ctrl + 1 to display the Format Cells dialog box. Press Alt + C to select a category. Press (Down Arrow key) twice to select a Currency.

Select a rupee symbol

Select a rupee symbol

Press Alt + S to select the symbol. Press PgDn several times to scroll through the pages and select the rupee symbol.

Rupee symbols applied

Rupee symbols applied

Press Enter to apply the rupee sign to the value.

How to insert a rupee symbol in the Symbol dialog box

Select a cell

Select the cell in which the value you wish to insert the rupee symbol is entered.

mouse cursor at the top

Press F2 to activate cell edit mode. Press Shift + (Left Arrow key) to bring the cursor to the beginning of the value.

Change the font

Press Alt + N + Z + S + U to display the Symbol dialog box.

Press Alt + F to select a font. Press PgDn several times to scroll and select the font you are currently using.

Press Alt + C and type 20B9

Press Alt + C to select character code and enter 20B9 in the input field.

Press Alt + I to insert rupee symbol

Now that the rupee symbol is selected, press Alt + I to insert it.

Rupee symbol inserted

After inserting the symbol, click Close.

The rupee symbol has been inserted. Note, however, that this rupee symbol is treated as a string.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments