How to Insert Euro Symbol in Google Sheets [6 Methods]

how to add Euro Symbol in Google Sheets 37

Hi everyone, in this article, we will learn how to insert euro (currency) symbol in google sheets. We mostly work with money-related data in google sheets, and we need so many symbols to have in the sheets, there are not enough special characters available on any keyboard, so we must need to learn some workarounds to learn tricks and easy methods to follow. This article will teach you how to add Euro symbol in google sheets using various methods.

Importance of Inserting Currency Symbol in Google Sheets

When we work with currencies, we use Shift + 4 to add a dollar sign to our sheets data, but there is no special character for Euro symbol in any general keyboard. So how do we add a euro symbol, as we need it just like the Dollar symbol?

Well, this article will enable you to add the Euro symbols using 6 ways, and you will be able to add Euro and other currency symbols very smartly, with almost no consumption of time. So, to show currency on the money-related data we need to learn how to add Euro symbol in google sheets.

See also  How to Delete Empty Rows in Google Sheets [4 Methods]

How to Insert Currency (Euro) Symbol in Google Sheets

Here we will see how to add Euro symbol in google sheets using many ways, we will learn the step-by-step procedure to learn all the methods so that you don’t have any problems in the future.

Insert Euro Symbol in Google Sheets – Copy Paste Method

The simplest, and easiest method is to copy from anywhere else and paste wherever you need it. In this method we will learn how to add euro symbol in google sheets using a simple copy-paste method, you can also copy the euro symbol € from here,

or the best way is to copy it from the internet.

The simple procedure to copy and paste the euro symbols into sheets is shown below.

Step 1

Search for the Euro symbol from your web browser

how to add Euro Symbol in Google Sheets 1

Step 2

In the results, you will find the euro symbol written

how to add Euro Symbol in Google Sheets 2

Step 3

Go to the euro symbol select it, and copy

how to add Euro Symbol in Google Sheets 3

Step 4

Go back to sheets, double click on the cell, and paste

how to add Euro Symbol in Google Sheets 4

If you paste directly over the cell, you will get the original size as shown below

how to add Euro Symbol in Google Sheets 5

Once you have pasted it in sheets, now you don’t need to do anything else you can copy it, again and again, billions of times, and reuse it for a lifetime.

But, sometimes we don’t have internet access, so below are some more methods that work without internet so don’t worry about it.

Insert Euro Symbol in Google Sheets – Keyboard Shortcut

We all love to have keyboard shortcuts for everything, and we all enjoy using keyboard shortcuts because they are fast and easy. So, in this section, we will learn how to add euro symbol in google sheets using a keyboard shortcut. The keyboard shortcut is a little longer so you need to be careful when using it.

Step 1

Select a cell in which you want to add the euro symbol

how to add Euro Symbol in Google Sheets 6

Step 2

Double click the cell, press Enter key, or press the F2 key to go into the editor mood

how to add Euro Symbol in Google Sheets 7

Step 3

Place the cursor where you want to add the euro symbol

how to add Euro Symbol in Google Sheets 8

Step 4

Press and hold the ALT key, and then press 0128 from Numpad

how to add Euro Symbol in Google Sheets 9

Note: The numbers 0128 should be pressed one by one sequentially

Step 5

Leave the ALT key and you can see the euro symbol is added to the cell

how to add Euro Symbol in Google Sheets 10

This is how using a keyboard shortcut you can add the euro symbol in google sheets.

Tip: The shortcut only works on the Numpad keyboards, if you don’t have Numpad on your keyboard, then this method is not going to work for you using the numeric keys below the function keys.

Here you can use an on-screen keyboard for using this shortcut key.

See also  How to Insert Google Sheets Data into Google Docs (Best Practice)

Insert Euro Symbol in Google Sheets – On-Screen Keyboard

To use the on-screen keyboard, we need to follow the below steps and we will also enable the num keys in the on-screen keyboard if they are not enabled by default.

Step 1

In the start menu search bar, type on-screen keyboard

how to add Euro Symbol in Google Sheets 11

how to add Euro Symbol in Google Sheets 12

Step 2

Click on the app to open

how to add Euro Symbol in Google Sheets 13

Step 3

Now you can see I don’t have num keys enabled by default

how to add Euro Symbol in Google Sheets 14

Step 4

Click on the options key

how to add Euro Symbol in Google Sheets 15

Step 5

Here you can check on “turn on the numeric keypad” and then click Ok

how to add Euro Symbol in Google Sheets 16

Now you can use the keyboard shortcuts that contain num keys.

how to add Euro Symbol in Google Sheets 17

How to Insert Euro Symbol in Google Sheets – using CHAR function

When working on the special characters, how can we forget the CHAR function, In this section, we will learn how to add euro symbol in google sheets using the CHAR function.

Step 1

Type the CHAR function in any cell where you want to have the euro symbol

how to add Euro Symbol in Google Sheets 18

Step 2

Pass the character code for Euro symbol 8364

how to add Euro Symbol in Google Sheets 19

Step 3

Press Enter key, and you can see the euro symbol is generated.

how to add Euro Symbol in Google Sheets 20

Now if you don’t like to have it as a formula, you can copy it and paste it as a value to have a pure value without a formula

Step 4

Copy > Paste special > values only

Keyboard Shortcut is Ctrl + Shift + V

how to add Euro Symbol in Google Sheets 21

how to add Euro Symbol in Google Sheets 22

Insert Euro Symbol in Google Sheets – using Custom Formatting

In this section, we will learn how to add euro symbol in google sheets using built-in formatting, we have all the currencies format built-in in google sheets, and we have some variations as well, so let’s see how we can convert plain numeric values in Euro by adding a Euro symbol through formatting.

Tip: This euro symbol does not change the number into other formats, it makes the number into currency format that is a sub-category inside numbers, which means that you can still perform any kind of calculation on these values, and even when you go to the editor mode of the cell the Euro symbol will disappear, which indicates that the symbol is only for display purpose and nothing to do with the calculations.

For this example, I have some dummy data

Step 1

Select the data to which you want to add euro symbols

how to add Euro Symbol in Google Sheets 23

Step 2

Go to Format in the main menu

how to add Euro Symbol in Google Sheets 24

Step 3

Go to Number > custom currency

how to add Euro Symbol in Google Sheets 25

Step 4

Here you have all the currencies available, type Euro in the search box

how to add Euro Symbol in Google Sheets 26

Step 5

Click on the Euro in the search results

how to add Euro Symbol in Google Sheets 27

Step 6

Now you have a dropdown of Euro currencies, you can click on it to pick your desired notation

how to add Euro Symbol in Google Sheets 28

how to add Euro Symbol in Google Sheets 29

Step 7

Click on apply

how to add Euro Symbol in Google Sheets 30

how to add Euro Symbol in Google Sheets 31

Step 8

The values are still numbers and have not changed to any other format, you can verify it by using the ISNUMBER function

how to add Euro Symbol in Google Sheets 32

how to add Euro Symbol in Google Sheets 33

how to add Euro Symbol in Google Sheets 34

Step 9

You can use them as values as well

how to add Euro Symbol in Google Sheets 35

how to add Euro Symbol in Google Sheets 36

how to add Euro Symbol in Google Sheets 37

This is how you can use the custom currency format to add euro symbols to your data and they will also remain valid to perform calculations, unlike if you manually add a euro function, then the value will be changed from a number to a string, and the calculation will not be performed.

See also  How to Use VLOOKUP in Google Sheets (User Guide)

Insert Euro Symbol in Google Sheets – using Character Map

In this section, we will learn how to add euro symbol in google sheets using a character map that is built-in in windows, we have covered this in other articles as well, in which we learned to insert a degree symbol in google sheets. So, to quickly learn this, simply follow the below steps.

Step 1

Go to the start menu and search for “character map”

how to add Euro Symbol in Google Sheets 38

Step 2

Open the app

how to add Euro Symbol in Google Sheets 39

Step 3

In the Go to Unicode section pass the Unicode to get the symbol 20AC

how to add Euro Symbol in Google Sheets 40

Step 4

You will get the Euro symbol you can copy it by clicking on Select then Copy

how to add Euro Symbol in Google Sheets 41

how to add Euro Symbol in Google Sheets 42

how to add Euro Symbol in Google Sheets 43

Step 5

Back to your sheet and paste the symbol

how to add Euro Symbol in Google Sheets 44

Insert Euro Symbol in Google Sheets – Using Google Docs

In this section, we will learn how to add Euro symbol in google sheets using google docs. Google docs have its character map for special characters we can copy from here and paste to sheets.

Step 1

Go to insert > Special characters

how to add Euro Symbol in Google Sheets 45

Step 2

Now here you can write the name of the symbol to search

how to add Euro Symbol in Google Sheets 46

Step 3

Or here, you can draw the symbol to search

how to add Euro Symbol in Google Sheets 47

Step 4

In both cases, you will get the Euro sign, click on it to type on the document

how to add Euro Symbol in Google Sheets 48

Step 5

Copy it

how to add Euro Symbol in Google Sheets 49

Step 6

Back to sheets and paste

how to add Euro Symbol in Google Sheets 50

how to add Euro Symbol in Google Sheets 51

So, this is how you can use any of these so many methods to add the euro symbol in google sheets. I like the keyboard shortcut method, and the CHAR function to add euro or other symbols into google sheets. Which method do you think is the easiest and most useful? Share your thoughts with us in the comments section below.

See also  How to Indent in Google Sheets [4 Methods]

Important Notes

  • CHAR function can generate any special character, you just need to have the character code for it which can be found on the internet.
  • The best way is to use the keyboard shortcut, its fast and you don’t need to go to another tab
  • Euro symbols added by formatting are only for the display, they don’t have anything to do with formulas, functions, or other calculations of the values, you can also remove them if you need to hide them by changing the format to the number or automatic.

See also  How to Sort by Number in Google Sheets (A-Z or Z-A)

Conclusion

That’s all from how to insert euro symbol in google sheets, we have learned why we need to add a euro symbol in google sheets, and we saw so many easy methods to add it. I tried to cover every method so that anyone even a beginner can use this to add euro symbol google sheets.

I hope you find this tutorial useful. I will see you soon with another helpful article. Keep learning with OfficeDemy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general