How to Insert Euro Symbol in Excel?

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
  1. Ensure Num Lock is on.
  2. Hold down the ALT key.
  3. Type 0128 on the numeric keypad.
  4. 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
  1. Hold down the Option and Shift keys.
  2. Press 2.
  3. 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:

  1. Click on the cell where you want to insert the symbol.
  2. Go to the Insert tab on the ribbon.
Click the insert button
  1. Click on Symbol in the Symbols group.
Click on the symbols icon in the ribbon
  1. In the Symbol dialog box, select ‘Currency Symbols‘ in the subset drop-down.
Select the currency symbols subset from the drop down
  1. Select the Euro symbol (€).
Select the Euro Symbol
  1. Click Insert, then close the Symbol dialog box.
Click on Insert to get the Euro symbol in cell

Inserting Euro Symbol using Formula

You can use the CHAR or UNICHAR functions to get the Euro Symbol in Excel:

CHAR Function

=CHAR(128)
CHAR function to insert Euro Symbol

UNICHAR Function

=UNICHAR(8364)
UNICHAR function to insert Euro Symbol

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:

DescriptionDetails
Name of SymbolEuro Symbol
Symbol Text€
Shortcut for WindowsAlt + 0128
Shortcut for MacOption + Shift + 2
Inserting using Symbol Dialog BoxFind € 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:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment