• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

alt key symbols

GVN KUMAR

Member
sir,
attached xls file

alt +1 = ☺ smile

alt key with numeric we get symbols but i am regularly usage in files preparation time some required symbols with alt + numeric used for get symbols.

attached file symbols can suggested alt+ key strokes
 

Attachments

  • fonts.xlsx
    10.2 KB · Views: 7
Select the cell where you want your symbol
Change the font to Wingding
Now goto Insert, Symbol
Change the Fonto to Wingding
Scroll down until you see your character
Select it
You will see a Character Code Number change
eg: for the Smalll Diamond it will show 115

Close this dialog

You can now use this number by Holding the Alt Key and pressing 0115 on the Numeric Keypad, not the Number Keys across the top of the key board

You can see the other character codes using this technique

alternatively you can use a formula in your worksheet
eg: =code(A3)
it will show 115 as the code
 
sir, I am regularly used below keys
alt +23,22,25,26,24,27 = →↑↓←↨↑§↓▬↑↓→←↓∟
alt 256→ ■ ,15,16,17,♪ ♫ ☼ ►◄
alt 1,2,3,4,5,6,7,8,9,10=☺☻♥♦♣♠•◘○◙
but some key (alt + numeric )working in word excellent → 10004 got this symboles ✔ in same command in xls→ ¶
Why this differs in various application various results with same command commands???
 
Back
Top