FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Delta Symbol In Excel

Updated on December 27, 2023
Article byJeevan A Y
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Delta Symbol In Excel?

Delta Symbol in Excel is a Greek Symbol/Character used to represent data variations on Excel dashboards. The variations are shown for a time period.

The symbol of the Delta character is ▲.

Delta-symbol-in-Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Delta Symbol In Excel (wallstreetmojo.com)

Key Takeaways

  • The Delta Symbol in Excel is a character that symbolizes the variation of data within a period.
  • Delta is the 4th alphabet in Greek language, and its symbol is Δ, i.e., it looks like an empty triangle. We can customize it into a Triangle with color fill.
  • The shortcut key to add the Delta symbol is “Alt+30”. We will insert the number 30 from the number keyboard, located at the right end of the keyboard, and not from the numeric or special character keys.

Six Methods To Insert Delta Symbol In Excel

The following methods are used to insert the Excel Delta Symbol, namely,

  1. Insert Delta Symbol from Insert tab.
  2. Insert Delta by Shortcut Key.
  3. Insert Delta by Changing the Font Name.
  4. Insert Delta by CHAR Formula.
  5. Insert Delta by Using Excel Autocorrect Feature.
  6. Custom Number Formatting with Delta Symbol.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Now let us discuss each of the methods in detail with an example.

You can download this Delta Symbol Excel Template here – Delta Symbol Excel Template

Method #1 – Insert Delta Symbol from Insert Tab

The steps to insert the Delta Symbol from the “Insert” tab in Excel are as follows:

  1. First, go to the Insert tab. Under the Insert tab, find the Symbols group and Symbol option.


    Delta symbol Example 1

  2. Now, the Symbol window appears.


    Delta symbol Example 1-1

  3. Next, from the Subset drop-down list in Excel, choose Greek and Coptic. As soon as we select this option, we see the Delta Symbol.


    Delta symbol Example 1-2

  4. Next, click on Insert to insert the Delta Symbol.


    Delta symbol Example 1-3
    As a result, we get the Delta Symbol in cell A1 which looks like a triangle with an empty center.

  5. To insert the Delta Symbol with a filled black color in the middle, we must select “Geometric Shapes” under Subset in the symbols window. And under Font, we must choose “Arial.”


    Delta symbol Example 1-4

Subsequently, it has a Delta Symbol with a center filled with black color.

Delta symbol Example 1-5

Method #2 – Insert Delta by Shortcut Key

The quick way to insert a Delta symbol with the shortcut is by using the shortcut key in excelUsing The Shortcut Key In ExcelAn Excel shortcut is a technique of performing a manual task in a quicker way.read more. For example, to insert the second Delta Symbol, i.e., “triangle with filled color”, use the following keys.

  • First, select the Excel cell where we want to insert the Delta Symbol.
  • Next, hold the ALT key, and press 30 from the number keypad on the keyboard.
Delta symbol Example 2

[Note: 30 should be pressed from the number keyboard, usually located at the right end of the keyboard, and not from the numeric keys.]

Method #3 – Insert Delta by Changing the Font Name

We can also insert a Delta Symbol without any filled color by changing the font name.

  • First, enter the text “D” in the targeted cell.
Delta symbol Example 3
  • Now change the font name to “Symbol” to get the Delta Symbol without filling in the center.
Delta symbol Example 1-6

We got a Delta Symbol. So, the text value “D” equals the Delta Symbol in the font name “Symbol”.

Method #4 – Insert Delta by CHAR Formula

As we are aware, we have the Char function in excelChar Function In ExcelThe character function in Excel, also known as the char function, identifies the character based on the number or integer accepted by the computer language. For example, the number for character "A" is 65, so if we use =char(65), we get A.read more that helps users to insert special characters with pre-set numeric values in Excel.

In the targeted cell, type the CHAR function as =CHAR(

Delta symbol Example 4

Then, enter the number 114, and press the “Enter” key to get the character “r”.

Delta symbol Example 4-2

We must change the font name to “Wingdings 3” to get the Delta Symbol without fill.

Delta symbol Example 4-3

To get the Delta Symbol with center fill, replace 114 to 112 (112 is numeric code for Delta Symbol with center fill). So the formula will now be =CHAR(112). The output is shown below.

Delta symbol Example 4-4

Method #5 – Insert Delta by Using Excel AutoCorrect Feature

We can insert the Delta Symbol by entering the text using the Excel AutoCorrect feature

The steps to insert the Delta Symbol using autocorrect in excelAutocorrect In ExcelExcel's AutoCorrect feature automatically corrects commonly misspelt words, extends a short phrase to a full sentence, and even pops up a full form of an abbreviation. It also automatically capitalizes the first word after a full stop.read more are.

Step 1: First, copy the Delta Symbol, Δ. Then, we must click on File >>> Options.

Delta symbol Example 5

Step 2: We need to go to the “Proofing”, and “AutoCorrect” options in the next window.

Delta symbol Example 5-1

Step 3: In the below window, paste the copied Delta Symbol in the “With” box.

Delta symbol Example 5-2

Step 4: In the “Replace” box, we must type the text as desired.

Delta symbol Example 5-3

Step 5: Now, we need to click the “Add” button to add to the “AutoCorrect” option, click “OK”, and close the window.

Delta Example 5-4

Step 6: Now, return to the worksheet. In cell A1, type “ABCD” in capital letters, press the “Enter” key, and see what value we get in cell A1.

Delta Symbol 5

Rather than getting “ABCD”, we get a Delta Symbol, since we have set the AutoCorrect option of typing the text “ABCD” for the Delta Value.

Method #6 – Custom Number Formatting with Delta Symbol

In most of the Dashboards we notice that the Delta Symbols are differently colored.

We will now use simple data to insert Delta Symbols using a custom number format in excel.Custom Number Format In Excel.Excel custom number formatting is nothing but making the data look better or visually appealing. Excel has many inbuilt number formatting. On top of this, we can customize the Excel number formatting by changing the format of the numbers.read more

Delta Example 6

For this data, first, find the variance value. The steps are,

Step 1: To find the variance, select cell C2, insert the formula = Actual – Target, i.e., =B2-A2, and press “Enter”.

Then, drag the formula from cell C2 to C7 using the fill handle. The results are seen in cells C2:C7.

Delta Example 5-5

Step 2: Now, select “Variance” data, and press Ctrl + 1 to open the “Format Cells” window.

Delta Example 5-6

Step 3: In the “Format Cells” window, select the “Custom” option on the left, and choose “General Δ” in the “Type:” category, as shown below.

Delta xample 6-1

Step 4: Then, press “OK”. We will get a Delta Symbol with numbers.

Delta Example 6-2

But this is not the ideal way of showing the Delta Symbol. An upward Delta Symbol indicates both positive and negative numbers. Let us use the upward delta to represent positive variance and downward delta to represent negative variance. We must copy these to apply two Delta Symbols ▲▼.

Step 5: Select the “Variance” column, right-click on it, and click the “Format Cells” option to open the “Format Cells” dialog box. Then go to “Custom”, and apply a format like the one below.

Delta Example 6-3

Step 6: Press “OK” to apply the formatting. We now see the upward and downward Delta Symbols for positive and negative variance, respectively.

Delta Example 6-4

Step 7: We can still apply colorful formatting for these variance numbers. If the variance is positive, we can use a “Green” color, and “Red” color for negative variance values.

So, for this, below is the formatting code.

Delta Example 6-5

Thus, it will apply to the formatting below.

Delta symbol Example 6-6

Important Things To Note

  • The Delta Symbol comes in two ways: a filled delta and another is an empty delta.
  • The CHAR function can insert both kinds of Delta Symbols in Excel.
  • The Delta Symbol is used in the dashboard, created with eye-catching colors.
  •  To insert the Delta Symbol in Excel, ALT + 30 is the shortcut.

Frequently Asked Questions (FAQs)

1. Name the different ways a Delta Symbol in Excel is used?

Delta Symbol in Excel represents changes in data on Excel dashboards, and the symbol of the Delta character is ▲.
It comes in two ways: a filled delta and an empty delta.

2. Name some methods to insert Delta symbol in Excel.

The following methods are used to insert the Excel Delta Symbol, namely,
1. Insert Delta from Insert option.
2. Insert Delta by Shortcut Key.
3. Insert Delta by Changing the Font Name.
4. Insert Delta by CHAR Formula.
5. Insert Delta by Using Excel Autocorrect Feature.
6. Custom Number Formatting with Delta Symbol.

3. How can we insert the Delta using the Insert tab?

We can use the Insert tab from the ribbon to insert the Delta Symbol as follows:

First, choose a cell to insert the Delta Symbol – select the “Insert” tab – go to the “Symbols” group – click the “Symbol” option drop-down – select the “Symbol” option, as shown below.

Delta symbol Example 1

Now, the Symbol window appears.

Delta symbol in Excel - symbol

Finally, select the Delta Symbol in the 5th option of the 3rd Row, click “Insert”, and select the “Close” option, as shown below.

Delta symbol Example 1-2

Now, we will see the Delta Symbol in the chosen cell.

Download Template

This article must help understand Delta Symbol in Excel with its formulas and examples. You can download the template here to use it instantly.

Recommended Articles

This article is a guide to Delta Symbol in Excel. Here we see ways to insert Delta symbol using Insert tab, Char, Shortcut key, example, downloadable template. You may learn more about Excel from the following articles: –