Input special characters in Excel by pressing Alt + Numpad - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Tuesday, January 21, 2020

Input special characters in Excel by pressing Alt + Numpad

Input special characters in Excel by pressing Alt + Numpad

Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together.  If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way.
Well, what to do with it then?  Out of the hundreds special characters, how many of them are actually frequently used in daily work?
Depends on what your job is, you many find many special characters applicable and useful to you.  However there are just a few to me, as shown below:
Image
(these codes are for Windows PC)
Note: You have to keep PRESSing ALT, while you enter the number in the number pad, then release ALT
I use the up and down arrow a lot.  They look good and save space.  Also I am glad to discover ALT+167 as I used to type “o” and then superscript it in order to give the symbol for degree… I guess many people do the same, right?

Input special characters / symbols by Inserting Symbol

Similarly, we can insert different symbols in Excel.
1) Go to Insert on the Ribbon –> Click Symbols
Image
2) Note that Symbols are basically different fonts of Wingdings.  Scroll down to explore.  The Tick / Cross and various arrows are my favorite.  After you select the symbol you want, click Insert.
Image
3) Note that the Font changes to Windings.  Look at the formula bar, they are “strange” symbols.  But with Windings, they appear to be the tick and cross.
Image
4) If you need to add other text behind the symbols, you will get a “strange” symbols as they are all in Wingdings.
Image
Image
5) Simply select the texts in the formula bar and change them to other fonts, e.g. Arial
Image
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment