6 Ways to Add Currency in Excel or Google Sheets
We all have found ourselves in a situation where we need to add foreign or local currency into an Excel or Google Sheets document. Unfortunately, this often leads to significant time being spent on figuring out the way to add these currency symbols. In this article, we will share multiple ways you can easily use to add currency in Google Sheets or Excel.
Table of Contents
1. Keyboard Shortcuts
One of the easiest ways to add currency in Microsoft Excel orGoogle Sheets is by using keyboard shortcuts. This method can be useful if you’re dealing with only a limited number of currencies, as remembering the keyboard shortcuts can be a somewhat hefty task.
Here’s a list of the most popular currencies, along with their corresponding keyboard shortcuts:
For other currencies, you may need to adjust your computer’s language settings to that country in order to use the keyboard shortcuts.
If you don’t want to go through such a hassle, you can check the below methods.
2. Home Tab (Excel)
If you’re using Microsoft Excel on your device, it’s quite easy to insert any currency in your Excel sheet. Here’s a quick guide on it:
1.Open theExcel fileand select the cell where you want to add a currency.
2.Next, navigate to theHometab and click thedropdown menunext to the$ Sign (Dollar). From there, you can choose the desiredcurrencyfrom the available options.
3.If you don’t find the currency you’re looking for, click on theMore Accounting Formatsoption. This will open a new window
4.Now select theAccountingcategory and click on thedrop-down menunext to Symbol to choose theCurrency.
5.Once done, hit theOKbutton and the currency will be added to the cell.
Tip:Learn how topassword-protect your Excel file.
3. Format Tab (Google Sheets)
Adding a currency in Google Sheets is also as easy as compared to Excel. You just have to select thecelland navigate toFormat > Number > Custom Currency.
A new window will appear, displaying a list of all available currencies. You can either scroll through thelistor use theSearch Barto find your desired currency. Once you’ve found it, select thecurrencyand then click theApplybutton.
That’s it.
Pro Tip:Your top 3 most used currencies will be visible in thesub-menuof theNumberoption. This can make the process slightly faster.
4. Insert Tab (Excel)
One more way to add currency to your Excel File is via Symbols. Let me show you how:
1.All you need to do is switch to theInserttab and click on theSymbolsbutton located on the right side of the Ribbon.
2.After that, select theSymboloption and it will open theSymbol dialog box, which contains a list of symbols and special characters that you may insert.
3.Now, ensure you’re on theSymbolstab and choose theCurrency Symbolsoption by clicking thedropdown menunext toSubset.
4.From there choose thecurrencyand hitInsert.
Note:You can only add one currency symbol at a time, in contrast to the previous methods that allow you to add currency symbols to multiple cells simultaneously.
Tip:Learn how toconvert a picture to an Excel table.
5. Character Viewer
If you’re a Mac user, you also have the option of using the Character Viewer to add currency symbols to your Google Sheets or Excel file. All you need to do is pressCmd + Ctrl + Spaceto openCharacter Viewerand move to theCurrency Symbolstab. From there, you’re able to select anycurrencyyou want to add to the Spreadsheet.
6. Windows Emojis Panel
If you’re using a Windows device, you can use the Emojis panel to insert a currency into your Excel or Google Sheets file. Here’s how:
1.Open the Excel or Google Sheets file on your device and select the cell where you want to add currency.
2.Now pressWindows Key + . (Period) keyand it will open anEmojis panel.
3.From there, navigate to theSymbolsicon and switch to theCurrency Symbolstab.
4.Now to add the currency to your spreadsheet, simply click on thecurrency. That’s it.
How to Set Default Currency on Excel
If there is any currency that you use on a regular basis, it’s better to set it as the default currency on your Excel. Here’s a simple step-by-step process:
1.Open theRundialog box (Windows Key + R) on your Windows PC and enter“control international”and then hitOK.
2.After that, select the currency of yourpreferred countryby clicking on thedrop-down menulocated beneath the Format option.
3.Once done, hit theOKbutton.
As you may see by clicking on the dollar symbol, it adds the Indian Rupee symbol.
Note:Excel relies on your system language settings to determine the default functionality of the currency button. This way you can even change the default currency on Mac too.
How to Set Default Currency on Google Sheets
Setting up the default currency on Google Sheets is a piece of cake and it hardly requires more than a few simple clicks. All you need to do is click on theFiletab and choose theSettingsoption.
Now under the Locale section, click on thedrop-down menuand select yourpreferred country. Once done, hit theSave and reloadbutton.
As you can see, it has changed from US dollars to British Pounds.
Tip:Learn how toimport tables from the website to Google Sheets.
Add Currency Like a Pro in Excel and Google Sheets
Adding currency to a spreadsheet can be challenging, especially for those who are less familiar with the technology. That’s why in this article, we tried to cover as many methods as possible so that you’re able to select the one that aligns with your comfort level.
Before you leave, we also recommend you check out3 ways to export your Android contacts to MS Excel.
Rahul is your go-to guide for fixing Windows, Steam, Android, Samsung TV, and Google Chrome. An engineering college dropout who followed his passion for tech, he brings 3 years of troubleshooting experience and 2+ years of running his own tech blog to the table. When he’s not solving your tech problems, you’ll find him unwinding with the latest anime or K-drama.
