How to Add Rupee Symbol in Google Sheets – Simple Formatting Guide

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.

Want to show prices or amounts in Indian currency in your spreadsheet? Google Sheets makes it easy to display the rupee symbol (₹) either by formatting the cells or simply pasting it in.

Here are a couple of quick ways to do it:

Method 1: Format as Currency

1. Select the Cells
   Highlight the cells that contain the numbers you want to format.

2. Open the Format Menu
   Go to Format > Number > Custom currency.

3. Choose Indian Rupee
   Search for “Indian Rupee” in the list and pick your preferred display style (like ₹1,000).

4. Apply the Format
   Click Apply, and your selected cells will now show the rupee symbol automatically.

Method 2: Copy and Paste the Symbol

1. Copy the Symbol (₹)
   Just copy this: ₹

2. Paste It into Your Sheet
   You can paste it directly into a cell, or combine it with a formula (e.g., ="₹"&A1).

Bonus Tip: Show Amounts in Lakhs or Crores

If you're working with large numbers and prefer Indian number formatting (like lakhs and crores), you can:

• Use custom number formats to format 1,00,000 as 1L or 1,00,00,000 as 1Cr.

• Still include the ₹ symbol by customizing the number format to something like:
  ₹#,##,##0 for lakh/crore style grouping.

Step-by-Step Guide: How To Add Rupee Symbol In Google Sheets

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.

4. How to screen record on mac? 
   To screen record on a Mac, you can use Trupeer AI. It allows you to capture the entire screen and provides AI capabilities such as adding AI avatars, add voiceover, add zoom in and out in the video. With trupeer’s AI video translation feature, you can translate the video into 30+ languages. 

5. How to add an AI avatar to screen recording?
   To add an AI avatar to a screen recording, you'll need to use an AI screen recording tool. Trupeer AI is an AI screen recording tool, which helps you create videos with multiple avatars, also helps you in creating your own avatar for the video.

6. How to screen record on windows?
   To screen record on Windows, you can use the built-in Game Bar (Windows + G) or advanced AI tool like Trupeer AI for more advanced features such as AI avatars, voiceover, translation etc.

7. How to add voiceover to video?
   To add voiceover to videos, download trupeer ai chrome extension. Once signed up, upload your video with voice, choose the desired voiceover from trupeer and export your edited video. 

8. How do I Zoom in on a screen recording?
   To zoom in during a screen recording, use the zoom effects in Trupeer AI which allows you to zoom in and out at specific moments, enhancing the visual impact of your video content.