I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters in Excel via using this method. So lets start

Delta Symbol

Excel Symbol Dialog Box

Here I have created two sections for inserting various symbols in Excel as below:

1. How to Insert Symbol in Excel using Symbol Dialog Box?

2. How you can find mostly used symbol in Symbol Dialog Box?

Mostly Used Symbol

You may directly copy these symbols from below boxes and paste it in any documents i.e. Excel, Word, Outloolk, Power Point etc.

Section 1: Insert Symbol in Excel using Symbol Dialog Box
  • Here I will be taking an example to insert Delta ▲ symbol here. Select Cell/Place where you want to insert Delta ▲ symbol
Insert Symbol Box
  • Select Insert Option from Excel Menus and Select “Symbol” as shown below:
Delta Symbol
  • Below box will appear:
Delta Symbol
  • Select “Symbol” under Font field:
Delta Symbol
  • Select the required symbol from below list i.e. we selected Delta (▲) symbol as below and click Insert on the designated cell
Cents Symbol
  • This will insert the symbol in excel on the user designated place. You may insert any special character symbols in Excel through this method
Delta Symbol
Section 2: Finding Most Used Symbol in Symbol Dialog Box

Though there are many options and ways to insert various symbol however we are talking here the most useful and easy way to find these symbols. 

Here we will be talking only mostly used symbols as below however you can also find many others symbols with this same method. 

Please go through the images to learn how you can find your Favorite symbol in Symbol Dialog Box

1. Select Font Type as "Normal Text" and Subset "Latin-1 Supplement"
  • Yen Symbol ¥‎
  • Degree Symbol °
  • Cents Symbol ¢
Yen Symbol

Note:

1.  Select “Currency Symbols” under Subset option for Currency Symbols

2. Select “Greek and Coptic” under Subset option for Greek letters

2. Select "Symbols" for all other Symbols
  • Delta Symbol ▲‎
  • Alpha Symbol α
  • Pie Symbol π
Delta Symbol

Hope you liked this article. Please do not hesitate to comment here, if you are facing any challenge to find or insert any special character or symbol in Excel

Leave a Reply

avatar
SUBTRACTION AND ADDITION IN DATE FUNCTION
EXCEL TRICKS
Calculations with Date in Excel

Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are working on large database, this become tedious job for calculating date difference Here we discussed the various scenarios where we …

Date Function in Excel
EXCEL TRICKS
Date Function in Excel

While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that helps in various calculations. This Function also helps to convert the serial numbers to Date format of your …

Logo Inserting Symbols in Excel
EXCEL TRICKS
How to Insert Symbol in Excel Numbers?

Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special Character Symbols in Excel Number Formatting.  You may easily do this by following below steps: …

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn