Instructions for inserting delta symbols in Excel

The delta symbol in Excel, also known as the triangle symbol in Excel, is used a lot in the statistics table, expressing the amount of increase or decrease, or certain data according to the user's discretion.

And to be able to insert delta data in Excel, you have many different ways, using the special character insert tool in Excel or using keyboard shortcuts. The following article will guide you to insert the delta symbol in Excel.

1. Insert delta symbol in Excel with keyboard shortcut

Shortcuts in Excel, in addition to helping you to act quickly, can also enter symbols quickly. With the delta symbol in Excel, you will hold down the Alt key and then type 3 and 0 and then release.

We use the numeric keypad to display the delta symbol in Excel.

Instructions for inserting delta symbols in Excel Picture 1Instructions for inserting delta symbols in Excel Picture 1

2. Use the font to insert the delta symbol Excel

First, type the letter D in the cell you want to insert . Then we will change to the Symbol font .

Instructions for inserting delta symbols in Excel Picture 2Instructions for inserting delta symbols in Excel Picture 2

The resulting letter D is also converted to delta notation as shown below.

Instructions for inserting delta symbols in Excel Picture 3Instructions for inserting delta symbols in Excel Picture 3

3. Insert delta symbol from symbol tool in Excel

Step 1:

At the interface on Excel, click Insert and then click the Symbol tool to insert a special symbol into Excel.

Instructions for inserting delta symbols in Excel Picture 4Instructions for inserting delta symbols in Excel Picture 4

Step 2:

Display special symbols table in Excel. At Font you choose Calibri , at Subset we will choose Greek and Coptic . As a result you will see the delta symbol in this interface. Click Insert to insert into Excel.

Instructions for inserting delta symbols in Excel Picture 5Instructions for inserting delta symbols in Excel Picture 5

As a result we also get delta notation in Excel.

Instructions for inserting delta symbols in Excel Picture 6Instructions for inserting delta symbols in Excel Picture 6

4. Use the CHAR function to insert the Excel triangle symbol

Step 1:

In the cell in Excel you will enter the formula =CHAR (112) or = CHAR (114) .

Instructions for inserting delta symbols in Excel Picture 7Instructions for inserting delta symbols in Excel Picture 7

Step 2:

At the display symbol we will switch to the Wingdings 3 font to create a triangle icon in Excel.

Instructions for inserting delta symbols in Excel Picture 8Instructions for inserting delta symbols in Excel Picture 8

The symbol will then turn into a triangle symbol.

Instructions for inserting delta symbols in Excel Picture 9Instructions for inserting delta symbols in Excel Picture 9

5. Insert delta symbol in Excel automatically

In case you often have to use delta notation, you can use the AutoCorrect Excel feature

Step 1:

First you also need to insert a delta symbol into Excel as a template . Then copy this icon again.

Next, click File and select Excel Options . In the new interface, click on the Proofing item . Look to the right and click on AutoCorrect Options .

Instructions for inserting delta symbols in Excel Picture 10Instructions for inserting delta symbols in Excel Picture 10

Step 2:

Then at this interface you will enter the triangle symbol in the With line , and the arbitrary root word in Replace . Click Add to save this abbreviation.

Now when you type the original word and press Enter it will be replaced by a triangle symbol.

Instructions for inserting delta symbols in Excel Picture 11Instructions for inserting delta symbols in Excel Picture 11

5 ★ | 2 Vote