How to add rupee symbol in Google Sheets

This document provides a detailed process on how to add the rupee symbol (₹) to your Google Sheets. By following these steps, you can easily format your sheets to display amounts in Indian currency.

Step 1

Learn how to insert the rupee symbol in Google Sheets to represent Indian currency effectively.

Begin by selecting the cell or the column where you want the rupee symbol to appear.

Step 2

Navigate to the Format option from the drop-down menu.

Step 3

Proceed to select the Number option.

Step 4

From the Number menu, choose Custom Currency.

Step 5

Within the Custom Currency section, locate Indian Rupee.

Step 6

Select Indian Rupee to apply it to your selected cells.

Pro tips for adding the rupee symbol in Google Sheets

1. Use the currency format: Select the cells where you want the rupee symbol, click on Format in the menu, then choose Number > Currency. Google Sheets will automatically display the rupee symbol if you are in India.

2. Insert symbol directly: Click on the cell where you want the rupee symbol, then go to Insert > Special characters. In the search box, type "rupee" to find ₹ and insert it.

3. Use the keyboard shortcut: On Windows, press Alt + 8360 to insert the rupee symbol ₹. On a Mac, press Option + 3.

Common pitfalls and how to avoid them for adding rupee symbol in Google Sheets

1. Incorrect formatting: Sometimes the rupee symbol doesn't appear correctly due to wrong formatting. Fix: Ensure the cell is formatted as currency or insert the symbol manually.

2. Missing symbol in non-Indian locales: The rupee symbol may not appear by default in certain locale settings. Fix: Change the locale to India under File > Spreadsheet settings > Locale.

3. Non-visible symbol on certain devices: Some devices may not support the rupee symbol. Fix: Consider using ₹ directly or the currency code “INR” if the symbol doesn’t display.

Common FAQs for adding rupee symbol in Google Sheets

1. How do I get the rupee symbol without changing the locale? You can insert it manually using the Insert > Special characters option.

2. Can I use the rupee symbol in a formula? Yes, just use the symbol or currency formatting in the formula for consistency.

3. Does the rupee symbol work in all currencies? The rupee symbol (₹) will only display correctly when your locale is set to India.

Thank you for using this guide for adding the rupee symbol in Google Sheets