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.

Picture 1 of Instructions for inserting delta symbols in Excel

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 .

Picture 2 of Instructions for inserting delta symbols in Excel

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

Picture 3 of Instructions for inserting delta symbols in Excel

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.

Picture 4 of Instructions for inserting delta symbols in Excel

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.

Picture 5 of Instructions for inserting delta symbols in Excel

As a result we also get delta notation in Excel.

Picture 6 of Instructions for inserting delta symbols in Excel

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) .

Picture 7 of Instructions for inserting delta symbols in Excel

Step 2:

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

Picture 8 of Instructions for inserting delta symbols in Excel

The symbol will then turn into a triangle symbol.

Picture 9 of Instructions for inserting delta symbols in Excel

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 .

Picture 10 of Instructions for inserting delta symbols in Excel

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.

Picture 11 of Instructions for inserting delta symbols in Excel

Update 17 February 2023
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile