# 06 Easy Steps How to Insert Delta Symbol in Excel?

This tutorial is the continuation of the How To Use Excel Symbol (Degree Symbol, Check Mark Symbol)

The delta symbol in Excel is generally used to show the difference between values. We can apply any of the following 06 methods to insert delta symbol in Excel (Δ or ▲)

### ➢ METHOD 1: USING THE EXCEL SHORTCUT TO INSERT DELTA SYMBOL IN EXCEL

Select a cell where to insert the delta symbol ➪ Press the F2 key or double-clicking on it to activate the edit mode (this step is optional)➪ Apply the Excel Shortcut Alt+30 (hold down the Alt key and then press 30 from the numeric keypad on the keyboard).

If we want to apply it to other cells, simply copy the delta symbol and paste it to other cells one by one.

■ Note: This Method only works on the 10 keys numeric keypad, otherwise it doesn’t work.

### ➢ METHOD 2: USING THE CHAR() FUNCTION TO INSERT DELTA SYMBOL IN EXCEL

This method is best for applying the Delta symbol in a range of cells.

We can use the CHAR() function to insert delta symbol in Excel, for example, =CHAR(114) As a result, the coderappears in a cell Then change the font to Windings 3 from the Front group under the Home tab. As an outcome, the code “r” will be converted into a delta symbol.

Similarly, we can insert the delta symbol with center fill with the CHAR() function =CHAR(112) ➪ As a result, the code p appears in a cell ➪ Then change the font to Windings 3 from the Front group under the Home tab. As an outcome, the code “p” will be converted into a delta symbol (with center fill).

We can add the delta symbol in a range of cells with the help of the cell reference and concatenate function, for example, =CHAR(114)&A1.

After applying the formula in a single cell, we can extend the formula till the end of the range Then copy (Ctrl+C) the range and press Alt+E+S+V (sequentially press Alt, E, S, V) or press Alt+Ctrl+V+V (press Alt+Ctrl+V, then V) which will select the Values option in the Paste Special dialog box Finally, press Enter or click OK. As a result, all the formulas will be converted into values.

■ Note: We had detail discussed on Paste Special in a separate tutorial, suggested you read this tutorial: Paste Special in Excel Vs Break Link – Which one is Better?

After converting into values, press Ctrl+H which will open the Replace Tab in Find and Replace dialog box ➪ Type ‘r‘ in the Find what: box; and paste the delta symbol (▲) or press Alt+30 from 10 keys numeric pad in the Replace with: box ➪ Finally, press Replace All.

As a result, all the ‘r‘ characters will be replaced with the delta symbol (▲ or Δ ).

■ Note: We had detail discussed on Find and Replace in a separate tutorial, suggested you read this tutorial: 07 Points Guided You How to Find And Replace in Excel?

### ➢ METHOD 3: USING THE SYMBOL DIALOG BOX TO INSERT DELTA SYMBOL IN EXCEL

Select a cell where to insert degree symbol ➪ Press the F2 key or double-clicking on it to activate the edit mode ➪ Press Alt+N+U (sequentially press Alt, N, U) which will open the Symbol dialog box (Equivalently, Insert tab ➪ Symbol drop-down ➪ Click Symbol) ➪ Find and Select the Greek and Copic from the Subset drop-down ➪ Scroll down to select the delta symbol and click Insert. As a result, the delta symbol is inserted into the cell.

Equivalently, we can type the specific character code 394 in the ‘Character code:’ box and select Unicode (hex) from the ‘from:’ dropdown (if required). Excel, by default, selects the delta symbol and click Insert.

### ➢ METHOD 4: USING CAPITAL ALPHABET TO INSERT DELTA SYMBOL IN EXCEL

Select a cell where to insert delta symbol ➪ Type capital letter D (or press Shift+D) ➪  Select this character and change the font to Symbol from the Front group under the Home tab. As a result, the capital letter “D” will be converted into a delta symbol.

■ Note: We can change the color of the delta symbol (likes red, green, etc.) and make it bold (press Ctrl+B) too.

### ➢ METHOD 5: USING AUTOCORRECT TO INSERT DELTA SYMBOL IN EXCEL

Select a cell where to insert degree symbol ➪ Press the F2 key or double-clicking on it to activate the edit mode ➪ Press Alt+F+T (sequentially press Alt, F, T) which will open the Excel Options dialog box (Equivalently, File tab → Options) ➪ Select Proofing from the left sidebar ➪ Click ‘AutoCorrect Options‘ which will open the AutoCorrect dialog box ➪ Type DELTA in ‘Replace:‘ box. Paste the delta symbol from another place in ‘With:‘ box ➪ Click Add, then press OK twice.

Select a cell where to insert the delta symbol ➪ Press the F2 key or double-clicking on it to activate the edit mode ➪ Type DELTA and press Spacebar. As a result, a delta symbol appears in a cell.

### ➢ METHOD 6: USING CUSTOM FORMATTING TO INSERT DELTA SYMBOL IN EXCEL

For the Excel dashboard (Summary) preparation, we can easily insert the delta symbol in a range of cells.

(01) Select the range of cells with Ctrl+⬇ or Shift +⬇ ➪ Then press Ctrl+1 which will open the Format Cells dialog box ➪ Select Custom format in the Number tab and input in the ‘Type:‘ box

▲ General

As a result, both the positive and negative numbers are mapped with the delta symbol (▲) .

(02) Select the range of cells with Ctrl+⬇ or Shift +⬇ ➪ Then press Ctrl+1 which will open the Format Cells dialog box ➪ Select Custom format in the Number tab and input in the ‘Type:‘ box

▲ General; ▼ -General;

As a result, the positive are mapped with the delta symbol (▲) and the negative numbers are mapped with the inverted delta symbol (▼)

(03) Select the range of cells with Ctrl+⬇ or Shift +⬇ ➪ Then press Ctrl+1 which will open the Format Cells dialog box ➪ Select Custom format in the Number tab and input in the ‘Type:‘ box

[Green]▲ General; [Red]▼ -General;

As a result, the positive are mapped with the green delta symbol () and the negative numbers are mapped with the red inverted delta symbol ()

Microsoft Excel 2019/Office 365 Series

Bestseller
4.9/5

Introduction to Database Development (Self-Paced Tutorial)

Bestseller
4.9/5

Advanced Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)

Bestseller
4.9/5

CompTIA&reg; Network+ Certification Prep

High Rated
4.9/5

Microsoft Office Specialist 2016 (MOS) Certification Training

Top Rated
4.7/5

Certified Six Sigma Yellow Belt and Green Belt (Exam Cost Included)

Bestseller
4.9/5

Managing Web Design Projects

Bestseller
4.9/5

Bestseller
4.9/5

Visual Basic Series

Bestseller
4.9/5

Data Analysis and Visualization

Bestseller
4.9/5

Excel Fundamentals for Data Analysis

Bestseller
4.9/5

Data Visualization in Excel

Bestseller
4.9/5

Bestseller
4.9/5

Bestseller
4.9/5

Applied AI with Deep Learning

Bestseller
4.9/5

Bestseller
4.9/5

Accounting Analytics

Bestseller
4.9/5

Accounting Data Analytics

Bestseller
4.9/5

Master Excel Functions in Office 365 – Excel Dynamic Arrays (Learn to Use Excel’s NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP.) to Dramatically Simplify the Work You Do in Excel.)

High Rated
4.9/5

Excel Essentials for the Real World (Complete Excel Course) [Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas. (Excel 365, 2019 & 2016)]

Bestseller
4.8/5

Advanced Excel – Top Excel Tips & Formulas (Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)

Bestseller
4.6/5

The Ultimate Excel Programmer Course (Learn Excel VBA from Scratch with Dan Strong, Bestselling Excel Expert with Over 180K Students Worldwide!)

Bestseller
4.8/5

Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (Ace the Excel MO-201 Exam. Learn advanced data analysis & earn the Excel Expert Certification (MS Excel 2019/Office 365)

Bestseller
4.8/5

Excel Charts, Graphs & Data Visualization in Excel (Master 20+ Advanced Dynamic Excel Charts and Create Impressive Excel Graphs & Data Visualization in Microsoft Excel)

High Rated
4.8/5

Excel Power Query, Power Pivot, Power Map & DAX Masterclass (Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019)

Bestseller
4.8/5

Beginners to Expert Excel and Excel VBA 38 Hours Mega Course (Learn Excel formulas, Pivot Tables, Excel VBA macros, charts and the basics with our Microsoft Excel 38+ hours tutorial)

Top rated
4.6/5

Microsoft Power BI Masterclass – Expand Excellence (achieve the next Level of Business Intelligence with Microsoft Power BI Desktop. How to master Power BI Desktop)

Top Rated
4.7/5

Something went wrong.

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

## Like it? Share with your friends!

Share via

Community grow with You. * VERIFY & CONFIRM YOUR EMAIL *

Fill the Correct Information.

Something went wrong.

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

We use cookies to ensure that we give you the best experience on our website (by analyzing).  Please see our cookies page for further details or agree by clicking the 'Accept' button.

Below you can choose which kind of cookies you allow on this website. Click on the "Save cookie settings" button to apply your choice.

FunctionalOur website uses functional cookies. These cookies are necessary to let our website work.

AnalyticalOur website uses analytical cookies to make it possible to analyze our website and optimize for the purpose of a.o. the usability.