The Euro symbol (€) is the currency sign used for the euro, the official currency of the eurozone. It’s the official currency of 20 countries and is the second-highest traded currency in the world.
So naturally, many people who work with data in Excel may want to know how to get the Euro symbol in Excel.
In this article, I will show you some simple ways to insert the Euro symbol in Excel
Keyboard Shortcut to Insert Euro Symbol in Excel
Below are the keyboard shortcuts to insert the Euro symbol in Excel:
On Windows in Excel:
Shortcut: Alt + 0128
- Ensure Num Lock is on.
- Hold down the ALT key.
- Type 0128 on the numeric keypad.
- Release the Alt key to insert the Euro symbol.
Note: This shortcut also works in other MS applications such as MS Word or PowerPoint.
On Mac in Excel:
Shortcut: Option + Shift + 2
- Hold down the Option and Shift keys.
- Press 2.
- Release all keys to insert the Euro symbol.
Inserting Euro using the Symbol Dialog Box
To insert the Euro symbol in Excel using the Symbol Dialog Box, follow these steps:
- Click on the cell where you want to insert the symbol.
- Go to the Insert tab on the ribbon.
- Click on Symbol in the Symbols group.
- In the Symbol dialog box, select ‘Currency Symbols‘ in the subset drop-down.
- Select the Euro symbol (€).
- Click Insert, then close the Symbol dialog box.
Inserting Euro Symbol using Formula
You can use the CHAR or UNICHAR functions to get the Euro Symbol in Excel:
Copy and Paste the Euro Symbol into Excel
You can easily insert the euro symbol into Excel by simply copying it from a web page or another document. Here’s the symbol for you to copy:
Just paste it wherever you need it in Excel!
Below is a table that summarizes all the methods to insert the Euro symbol in Excel:
|Name of Symbol
|Shortcut for Windows
|Alt + 0128
|Shortcut for Mac
|Option + Shift + 2
|Inserting using Symbol Dialog Box
|Find € in the Symbol dialog box
|Inserting using Formula
|=CHAR(128) or =UNICHAR(8364) (Mac)
This guide provides comprehensive methods for inserting the Euro symbol in Excel on both Windows and Mac platforms. Whether using keyboard shortcuts, the Symbol dialog box, or formulas, these methods make it easy to include the Euro symbol in your Excel documents.
Other Excel articles you may also like: