How to insert the Euro symbol (€) in Google Sheets

The currency symbol in Google Sheets, in addition to the familiar $ symbol, also has the Euro symbol (€).

It is very easy to insert the dollar symbol $ into the Sheets table, when we use the keyboard shortcut available. With the Euro symbol (€), although there is no keyboard shortcut (€), you have many options for inserting the Euro symbol into the Sheets sheet. Here are ways to insert the Euro symbol (€) in Google Sheets.

Insert the Euro (€) symbol in Google Sheets with keyboard shortcuts

You click on the cell you want to insert the Euro symbol (€), then hold the ALT key and then press the 0128 keys in turn and then release. Immediately will display the symbol (€) as shown below.

How to insert the Euro symbol (€) in Google Sheets Picture 1How to insert the Euro symbol (€) in Google Sheets Picture 1

Insert the symbol (€) Google Sheets in currency format

You just need to reformat the cell according to the currency format, and the icon (€) will be displayed immediately to click.

Step 1:

You highlight the cells you want to insert the Euro symbol in Google Sheets, then click the format icon on Sheets as shown. Next, click on Custom Currency below the list.

How to insert the Euro symbol (€) in Google Sheets Picture 2How to insert the Euro symbol (€) in Google Sheets Picture 2

 

Step 2:

Now display a list of currencies, we scroll down and click on Euro to use. After selecting the Euro unit, click the Apply button to insert the content.

How to insert the Euro symbol (€) in Google Sheets Picture 3How to insert the Euro symbol (€) in Google Sheets Picture 3

As a result, we have a series of Euro coins as below.

How to insert the Euro symbol (€) in Google Sheets Picture 4How to insert the Euro symbol (€) in Google Sheets Picture 4

Use the CHAR function to insert the Euro symbol in Google Sheets

Select the cell where you want to insert the Euro symbol, then press the function formula = CHAR(8364) .

How to insert the Euro symbol (€) in Google Sheets Picture 5How to insert the Euro symbol (€) in Google Sheets Picture 5

 

The result also shows the Euro symbol in Google Sheets as shown below.

How to insert the Euro symbol (€) in Google Sheets Picture 6How to insert the Euro symbol (€) in Google Sheets Picture 6

Above are some ways to insert the Euro symbol in Google Sheets. We can use keyboard shortcuts to quickly insert the Euro symbol in the data table.

4 ★ | 1 Vote