In Mathematics, many Greek letters have meanings. For example, the delta symbol, or the sigma character. Also, with nowadays naming the COVID-19 variants after Greek letters, you might need to use them in Excel. Here are 5 simple methods of how to add them to Excel cells and to use them in Excel charts – in Windows and Mac!
Method 1: Use the Symbol window to insert Greek letters
The “traditional” way to insert the sign showing the difference in Windows is through the Insert Symbol window:
- On the Insert ribbon, click “Symbol” (the right-most button).
- In the Symbol window, select “Unicode (hex)” in the from field.
- Type the number of your desired Greek letter into the “Character code” field (here 0394 for delta Δ). You should now see the Greek character selected above.
- Click on Insert to insert the symbol into the cell or chart.
This table has all the values you type into the “Character code” field.
|Letter||Small Greek letter||Character code for small letter||Capital Greek letter||Character code value for capital letter|
Method 2: Use Professor Excel Tools to insert Greek characters
The second method works similar to the first one: You select the Greek letter you want to insert from a list. But this time, we use Professor Excel Tools, our Excel add-in to boost your productivity.
- On the Professor Excel ribbon, click on “Insert Symbol”.
- Select “Greek Characters” and click on the letter you want to insert.
- Click on “Insert”.
The advantages of this method: Selecting the category of Greek characters is very fast and you can bulk insert the characters to all selected cells.
Please download the free trial version of Professor Excel Tools here.
This function is included in our Excel Add-In ‘Professor Excel Tools’
(No sign-up, download starts directly)
More than 35,000 users can’t be wrong.
Method 3: Use the UNICHAR function in Excel
The third method is using the built-in UNICHAR function. Just type
into an Excel cell and it returns the Omicron letter. Please refer to the following table for all the other unicode numbers of Greek characters.
This method also works under MacOS.
|Letter||Small Greek letter||UNICHAR small letter||Capital Greek letter||UNICHAR Capital Letter|
Have you ever built an app based on Excel?
Method 4: Copy & paste
Probably not as beautiful, but it usually works: Alternatively, just copy and paste the Greek letters from one of the tables above.
This method also works under MacOS
Method 5: Insert Greek letters in MacOS
As said already, the method 3 and four above also work under MacOS.
It’s almost the same in Mac OS as in Windows, but the window looks a bit different. Still, you have to go to the Insert ribbon and click on Symbol on the right-hand side:
- On the Insert ribbon, click on Symbol (on the right-hand side).
- In the Character Viewer, go to Mathematical Symbols.
- Insert the ∆ by double-clicking on it.
Add the Greek characters to a chart
You want to show Greek characters on a chart? It works the same way as described above. The only difference: Insert a text field first.
In order to do this, select your chart. Then go to the Insert ribbon. On the right-hand side, click on the button “Text Box” and draw it onto the chart. Now, you can simply copy & paste or insert the Greek letter there.
IImage by PImage by Michelle Raponi from Pixabay