## Insert or Type the Delta Symbol in an Excel Worksheet

by Avantix Learning Team | Updated March 20, 2022

Applies to: Microsoft^{®} Excel^{®} 2013, 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.

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 >

To insert an equation block in Excel:

- Click the Insert tab in the Ribbon.
- Click Symbols. A drop-down menu appears.
- Click Equation. An equation block is inserted on the worksheet.

### 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 2023 Avantix** ^{®}** Learning

#### You may also like

## How to Combine First and Last Name in Excel (5 Ways)

You can combine first and last name in Excel in several ways – using the CONCATENATE operator, the CONCATENATE function, the CONCAT function, the TEXTJOIN function or Flash Fill. These functions are often used to combine text in cells but you can also combine text with spaces, commas, dashes or another character. It's common to combine first and last names that appear in two columns into one new column. Some functions are only available in newer versions of Excel but the CONCATENATE operator and function are available in all versions.

## How to Insert Multiple Columns in Excel (4 Fast Ways with Shortcuts)

You can quickly insert multiple columns in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple columns at once, rather than one by one, is to select the number of columns you want to insert first and then insert columns. Excel will insert the same number of columns you selected.

## Excel XLOOKUP Function (Overview, Syntax + Formula Examples)

The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.

*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