Insert or Type the Delta Symbol in an Excel Worksheet
by Avantix Learning Team | Updated September 18, 2024
Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows)
You can insert or type the Delta symbol in Excel worksheets using built-in commands or keyboard shortcuts. The Delta symbol is the fourth letter of the Greek alphabet and corresponds to the letter D. Delta can be entered in upper case (Δ) or lower case (δ). You can insert the Delta symbol using the Insert Symbol command, the Symbol font, Alt code shortcuts, AutoCorrect shortcuts or a custom format. The Delta symbol can be entered in cells, text boxes and equation blocks in Excel.
Contents
In this article, we'll review 7 ways to insert the Delta symbol in Excel:
- Use the Insert Symbol command
- Press Alt and then enter a number sequence
- Use the Symbol font and press the corresponding letter on the keyboard
- Create a custom format
- Add custom AutoCorrect entries to create shortcuts
- Use Math AutoCorrect shortcuts in an equation block or placeholder
- Use the Equation tab in the Ribbon to insert symbols in an equation block or placeholder
In mathematics, Delta means change.
Recommended article: How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)
Do you want to learn more about Microsoft Excel? Check out our virtual classroom or in-person classroom Excel courses >
1. Insert the Delta symbol using Insert Symbol
To insert the Delta symbol using Insert Symbol in an Excel worksheet:
- Click in the cell, text box or equation block where you want to insert the Delta symbol. Double-click the cell if you want to edit a cell that has other content.
- Click the Insert tab in the Ribbon.
- In the Symbols group, click Symbol. A drop-down menu appears.
- Click More Symbols. A dialog box appears.
- If necessary, click the Symbols tab.
- Select (normal text) from the Font drop-down menu and then Greek and Coptic from the Subset menu. Alternatively, you could select the Symbol font.
- Click the Delta symbol.
- Click Insert.
- Click Close.
The Insert Symbol dialog box displays the Delta symbol when you select normal text as the font and Greek and Coptic as the subset:
Some Excel users may want to insert a solid upward-pointing or downward-pointing triangle to represent change (or a delta) as follows:
▲▼
To insert the upward-pointing or downward-pointing triangle:
- Click in the cell, text box or equation block where you want to insert the Delta symbol. Double-click the cell if you want to edit a cell that has other content.
- Click the Insert tab in the Ribbon.
- In the Symbols group, click Symbol. A drop-down menu appears.
- Click More Symbols. A dialog box appears.
- If necessary, click the Symbols tab.
- Select Wingdings 3 from the Font drop-down menu.
- Scroll through until you see the triangles you want to use.
- Click the upward-pointing or downward-pointing triangle.
- Click Insert.
- Click Close.
The Insert Symbol dialog box displays the triangle symbols when you select Wingdings 3 as the font:
2. Use Alt code keyboard shortcuts to insert the Delta symbol
You can use Alt code shortcuts by pressing the Alt key in combination with numbers on the numeric keypad to insert Greek symbols in a cell, text box or equation block.
Press and hold Alt and then enter number sequences on the numeric keypad to enter the following:
Δ (Upper case Delta) – Alt + 916
δ (Lower case Delta) – Alt + 235
If these sequences don't work, press the NumLock key on the numeric keypad.
If you don't have a numeric keypad, you may be able to press the Fn key and access the numbers at the top of your keyboard.
In the Insert Symbol dialog box, Alt keyboard shortcuts are also displayed for each character at the bottom. The Unicode (hex) sequences listed in the dialog box are entered differently. In the document, press the indicated keys (using the numeric keypad) and then press Alt + X.
If you prefer to enter the following upward-pointing or downward-pointing triangles, press the following and use the numbers on the numeric keypad:
▲ – Alt + 30
▼ – Alt + 31
3. Insert the Delta symbol by switching to the Symbol font
You can use the Symbol font to insert the Delta symbol in Excel.
To insert the Delta symbol using the Symbol font:
- Click in the cell, text box or equation block where you want to insert the Delta symbol.
- Click the Home tab in the Ribbon.
- Select Symbol from the Font drop-down menu.
- Type the character to insert the required letter or symbol (such as the letter D).
The Greek characters correspond to standard characters. For example, if you type the letter d, Excel enters the corresponding Greek lowercase letter. Note that this changes the font for the entire cell if you have selected a cell.
4. Create a custom format for the Delta symbol
You can insert the Delta symbol in cells with numbers that you want to use in calculations by creating a custom number format. You can also use this method to display the upward-pointing or downward-pointing triangles which is common in dashboards. Once you create the format, you can apply it to cells containing numbers and you will still be able to perform calculations on the numbers.
Custom number formats have up to 4 parts separated by semi-colons. The first part affects positive numbers, the second part affects negative numbers, the third part affects zero values and the fourth part affects text. Literal text needs to be enclosed in quotation marks ("") and zeros force digits to display.
To create a custom number format to apply the upward-pointing or downward-pointing triangles in a format (in this case for percentages):
- Insert the triangles in a cell using the Insert Symbol or Alt method above.
- Double-click the cell and drag over the triangles.
- Press Ctrl + C to copy the triangles.
- Press Ctrl + 1 to display the Format Cells dialog box. Alternatively, right-click one of the selected cells and select Format Cells from the drop-down menu.
- Click the Number tab.
- In the categories on the left, click Custom.
- Delete the format that appears in the Type area.
- Enter a positive number format. For example, press Ctrl + V to paste the triangles and then enter 0%.
- Delete the downward-pointing triangle.
- Type a semi-colon to create a negative format part and enter a minus sign (-).
- Press Ctrl + V to paste the triangles again and then enter 0%.
- Delete the upward-pointing triangle in the negative part.
- If you want the upward-pointing triangle to appear in green, type [Green] at the beginning of the first part. If you prefer a darker green, enter [Color10] instead of [Green].
- If you want the downward-pointing triangle to appear in red, type [Red] at the beginning of the second part.
- If you want to format zero values, add a semi-colon at the end of the format and enter a zero value part.
- Click OK.
The following custom number format would display a green upward-pointing arrow for positive percentages and a red downward-pointing arrow for negative percentages:
[Color10] ▲0%;[Red] ▼-0%
In the following example, the custom number format has been entered in the Type area in the Format Cells dialog box:
If you wanted to display 2 decimals for a % format, you could create the following custom format:
[Color10] ▲0.00%;[Red] ▼-0.00%
The Format Cells dialog box appears as follows with a custom format that includes upward-pointing and downward-pointing triangles:
Custom number formats can now be applied to selected cells. Note that custom number formats are only saved in the current workbook.
You can create a similar format using the Delta symbol instead of the triangles.
To apply a custom number format:
- Select the cells where you want to apply the format.
- Press Ctrl + 1. Alternatively, right-click one of the selected cells and select Format Cells from the drop-down menu.
- Click the Number tab.
- In the categories on the left, click Custom.
- Scroll through formats on the right.
- Click the custom number format (custom number formats appear at the bottom of the list).
- Click OK.
A custom format has been applied to the cells in column C of the following worksheet with upward-pointing and downward-pointing triangles:
5. Create a custom AutoCorrect shortcut for the Delta symbol
You can also create a custom AutoCorrect shortcut for the Delta symbol. Although you can use Math AutoCorrect entries in equation blocks in Excel, you can't use them outside of math regions.
To create an AutoCorrect entry in Excel for the Delta symbol:
- Click in the cell, text box or equation block where you want to insert the Delta symbol. Double-click the cell if you want to edit a cell that has other content.
- Insert the Delta symbol using Insert Symbol or the Alt code method above.
- Double-click the cell and drag over it the letter or symbol.
- Press Ctrl + C to copy the symbol.
- Click the File tab in the Ribbon.
- Click Options. A dialog box appears.
- Select Proofing in the categories on the left.
- Click AutoCorrect. A dialog box appears.
- In the Replace with box, enter the name of the entry (such as \delta).
- Click in the With box and press Ctrl + V to paste the symbol.
- Click Add.
- Click OK.
- Click Close.
- Click in the cell, text box or equation block where you want to insert the Greek symbol. Double-click the cell if you want to edit a cell that has other content.
- Type the entry (such as \delta) and then press the Spacebar.
The AutoCorrect dialog box appears as follows with the Delta symbol to be added as an entry:
6. Insert the Delta symbol in an equation block using AutoCorrect for Math
Excel has built-in Math AutoCorrect entries that are available to insert in equation blocks.
To insert the Delta symbol in an equation block using AutoCorrect for Math:
- Select the Excel worksheet where you want to insert an equation.
- Click the Insert tab in the Ribbon.
- Click Symbol. A drop-down menu appears.
- Click Equation to insert a new equation block or placeholder. You can also use an existing equation block or placeholder.
- Click in the equation block or placeholder and type a backslash (\) plus the name of the symbol (such as \delta) and then press the Spacebar. To enter a Greek capital letter, use the same method but start with a capital letter (such as \Delta).
7. Insert the Delta symbol in an equation block using the Equation tab in the Ribbon
To insert the Delta symbol in an equation block or placeholder using the Equation tab in the Ribbon:
- Select the Excel worksheet where you want to insert an equation.
- Click the Insert tab in the Ribbon.
- Click Symbol. A drop-down menu appears.
- Click Equation to insert a new equation block or placeholder. You can also use an existing equation block or placeholder.
- Ensure that you have clicked in the equation block and then click the Equation tab in the Ribbon.
- Click the More arrow on the bottom right of the Symbols gallery.
- At the top of the Symbols gallery, select the drop-down menu (typically, this displays Basic Math).
- Select Greek Letters from the drop-down menu.
- Click the Greek symbol you want to insert.
The Symbol gallery with Greek Letters selected appears as follows:
You can also insert the Delta symbol in an equation block using Alt codes or the Insert Symbol dialog box.
Subscribe to get more articles like this one
Did you find this article helpful? If you would like to receive new articles, JOIN our email list.
More resources
How to Remove Duplicates in Excel (3 Easy Ways)
How to Merge Cells in Excel (4 Ways with Shortcuts)
How to Lock Cells in Excel (Protect Formulas and Data)
How to Combine Cells in Excel using Concatenate (3 Ways)
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
Related courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Introduction to Visual Basic for Applications (VBA)
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Copyright 2024 Avantix® Learning
You may also like
How to Replace Zeros (0) with Blanks in Excel
There are several strategies to replace zero values (0) with blanks in Excel. If you want to replace zero values in cells with blanks, you can use the Replace command or write a formula to return blanks. However, if you simply want to display blanks instead of zeros, you have two formatting options – create a custom number format or a conditional format.
What is Power Query in Excel?
Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.
How to Freeze Rows in Excel (One or Multiple Rows)
You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you freeze rows containing headings, the headings will appear when you scroll down. You can freeze columns as well so when you scroll to the right columns will be frozen.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca