• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

ALT Codes for Symbols and Characters

You are here: Home / Excel / ALT Codes for Symbols and Characters
ALT codes for symbols and characters
March 29, 2018 by Philip Treacy

On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the ALT key and then using the numeric keypad to type the ASCII or Unicode code for that character.

For example, holding down ALT and then typing 184 on the numeric keypad, prints ©, the copyright symbol.

Some History of ALT Codes

IBM PC's

On IBM PC's you could hold down the ALT key then type a number on the numeric keypad. The software running on the PC would interpret this as a key being pressed on the keyboard and would attempt to display the character corresponding to the numeric code you typed.

The numeric codes and characters (or glyphs) were stored in a table called a Code Page. For early IBM PC's they used what was called Code Page 437 (CP437).

CP437 was the default for some countries, including the USA. To support accented characters Code Page 850 was created and this is the default in Western Europe, and some English speaking countries like the UK, Ireland, Canada and Australia.

Other languages and locales use different code pages.

CP437 and CP850 both contained 256 characters, with the first 128 being the same. Beyond that the characters differ.

Windows

When Windows came along the use of these ALT codes was so widespread that Microsoft decided to continue support for them in their software.

Windows began using a different code page, CP1252 which varied a little from CP437 and CP850, but still only had 256 characters.

Unicode

In 1991 the Unicode Consortium was created to standardize the encoding, representation and handling of characters and symbols in all major operating systems and software.

Unicode allows for the encoding of over 1,000,000 characters/symbols, including letters and characters from many languages, mathematical symbols, geometric shapes, currency symbols and many others.

Using ALT Codes in Excel

To use an ALT code in Excel just hold down the ALT key then on the numeric keypad type the numeric code for the character you want.

For example, to display the registered trade mark symbol hold ALT and type 169.

Registered trade mark symbol in Excel using alt codes

Now, things can get a little confusing here so hang on.

Remember I said that Windows still supports the old CP437 and CP850 code pages from original IBM PC's? Excel also has support for the newer CP1252 code page used by Windows.

The first 128 characters in CP437, CP850 and CP1252 are the same. Once you get to characters beyond that you can encounter some differences.

If you want to use a character in the Windows CP1252 you precede your numeric code with a 0.

So typing ALT 0169 in Excel will actually give you a copyright symbol © rather than the ® you get if you type ALT 169.

Copyright symbol in Excel using alt codes

By preceding the code with a 0, you tell Excel to load the character from the Windows CP1252 code page, not the old CP437/850 (whichever one your PC supports).

Download the Workbook With Examples and Codes

I've prepared a workbook with the numeric codes and corresponding characters for CP850 and CP1252, codes 1 to 255.

The workbook also has sheets with codes for some currency symbols, superscript and subscripts characters and the Greek alphabet. Useful if you are doing some maths ☺.

That smiley face was ALT1 by the way.

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

CHAR() Function

The CHAR() function does the same thing as typing an ALT code, and uses the characters from Windows CP1252, but you don't need to use a preceding 0 like you do if you type the code.

CHAR() only works with numbers from 32 to 255.

excel char function

CharMap (Character Map)

Another alternative to typing the ALT code is to use the CharMap program in Windows. This allows you to find the numeric codes for characters and symbols.

Using character map for alt codes

In the image I've clicked on the symbol for micro, µ.

On the bottom left of the image you can see U+00B5 which is the Unicode code for µ. On the bottom right of the image you can see the ALT code which is ALT+0181. Note the leading 0.

If you click on a character in CharMap you can click on the Select button (or double click with your mouse) and then on the Copy button, to copy the character into your clipboard. Use CTRL+V to paste it into Excel.

You can Select (or double click) a series of characters and then copy/paste the entire string too.

Using Unicode Characters

As Unicode supports so many characters, and much of the Unicode documentation shows character codes in hexadecimal, rather than using decimal we must enter the Unicode character codes in hex.

The process described here works for Excel.

For other Office programs e.g. Word, Outlook, etc, you first type the Unicode code then press ALT X

For more info read this Microsoft article Entering Unicode in Office Programs


To do this in Windows we need to edit the registry.

WARNING : At this point I have to give you the usual warning about editing the registry and messing it up. The registry controls how your Windows PC operates and if you get it badly wrong, you can even prevent Windows from starting.

However as I'm sure you are pretty switched on, and the change that is needed is very minor, the risk of turning your PC into a large paperweight is low. That said, don't mess it up. You have been warned.

Editing the Registry

You need to run the Registry Editor, which in Windows 10 is Regedit. In other versions of Windows you may also have RegEdt32.

running the registry editor

Once the Registry Editor is running, navigate your way to the folder called Input Method under HKEY_CURRENT_USER\Control Panel and with Input Method highlighted, right click on it and then choose New -> StringValue.

add string value in registry

This creates a new entry on the right hand side of the Registry Editor window with the default name New Value #1. Just type over this and rename it EnableHexNumpad.

If you accidentally clicked off the new entry, or mistyped the name, just right click on it and choose Rename to rename it.

Renaming entry in registry

Next you have to give the entry a value. Double click on it and it will open up a small window where you can enter a value into the Value data box.

Enter 1 and then click on OK.

Edit EnableHexNumpad value in registry

Things should look like this now. Bear in mind the other entries in your Input Method folder may be different to mine. All we are working with here is the EnableHexNumpad entry.

EnableHexNumpad in registry

If everything looks good, close the Registry Editor and reboot your PC. I'll still be here when you get back.

If you've rebooted your PC you can now use Unicode codes to enter characters. Remember that you need to enter these in hex. You can use the letters and numbers above the letters, or a combination of letters and numbers off the numeric keypad.

There is one other little thing to remember when using Unicode codes, you must precede the number with a +, so to display the symbol for a 3 dimensional angle, ⟀ , type ALT+27C0. Don't forget you actually have to type the + on the numeric keypad.

Unicode Website and Charts

The Unicode website lists all the characters it supports and you can download the various character/symbol charts in PDF format.

ALT codes for symbols and characters

More Shortcuts Posts

double click shortcuts thumbnail

Hidden Excel Double Click Shortcuts

There are a load of hidden Excel double click shortcuts that will streamline the way you work in Excel and save loads of time
dax editor keyboard shortcuts

DAX Editor Keyboard Shortcuts

Keyboard shortcuts for the DAX editor in Power BI. Learning DAX is hard enough. Make your life easier by using these keyboard shortcuts.
power query keyboard shortcuts

Power Query Keyboard Shortcuts to Save Time

Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook

20 Pro Excel Keyboard Shortcuts

Excel Keyboard Shortcuts Used by Pros. These aren't your average CTRL+C type shortcuts. These are shortcuts that take the average user years to learn.
essential excel shortcuts

23 Essential Excel Keyboard Shortcuts

Excel keyboard shortcuts I use all the time to help me work quickly and efficiently. How many do you use?
Excel Named Ranges

Excel Named Range Shortcut

This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.

More Excel Posts

tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

How to remove Excel password protection when you’ve forgotten the password. Works for sheets, workbooks and read only files.
Import data from a picture to Excel

Import Data from a Picture to Excel

Import data from a picture to Excel. Works with pictures from a file or the clipboard and loads it to the spreadsheet.
excel online

5 Excel Online Features Better than Desktop

5 Excel Online Features Better than Desktop including searchable data validation, track changes, single line ribbon and more.

10 Common Excel Mistakes to Avoid

10 common Excel mistakes to avoid, including merge cells, external links, formatting entire rows/columns and more.
new Excel features

Cool New Features in Excel for Microsoft 365

Cool New Features in Excel for Microsoft 365 including the navigation pane, smooth scroling, unhide multiple sheets and more.
dynamic dependent data validation

Dynamic Dependent Data Validation

Dynamic Dependent Data Validation with dynamic array formulas like FILTER make it quick and easy to set up.
QAT

Excel Quick Access Toolbar

The Excel Quick Access Toolbar is not only a handy for your mouse, but it also enables some super easy keyboard shortcuts.


Category: ExcelTag: shortcuts
Previous Post:Excel ADDRESS Function
Next Post:Relative Named Ranges

Reader Interactions

Comments

  1. Subrata

    September 20, 2020 at 2:41 pm

    Hi, This is Subrata from India.
    While using ALT Codes in Excel, What Font should be selected.

    Reply
    • Mynda Treacy

      September 20, 2020 at 7:01 pm

      They work with most fonts.

      Reply
  2. John Mann

    May 28, 2020 at 6:16 am

    Interesting article. I’ve been using ALT+num pad codes for a long time, and often use CharMap as a quick look up for the code to use. I then make a note on a sticky note attached to a convenient spot on the compurter. I find that I tend to be using the same character frequently for a short period of time (a few days or a week or two) then don’t need it again.

    The history was interesting, not very often encounterd, and I’ve never seen any explanation of code pages other than they exist and in the DOS days it might have been specified in Autoexe.bat

    When ediiting the registry, I have a safegard procedure. First I make a backup copy of either the section I’m editing, or the whole thing. Have care, though. Regedit will try to save the copy as a *.REG file, which if accidentaly double clicked will be executed imediately, restoring the settings being changed – rather anoying if you didn’t intend to do it. I always make my backup a *.TXT file, which Regedit can import, but won’t trigger Regedit if accidentally executed – it loads Notepad instead so you can read the thing!.

    Reply
    • Philip Treacy

      May 28, 2020 at 10:35 pm

      Thanks John. I regularly had to use ALT+0163 for the Pound Sterling symbol. It’s still burned into my brain.

      I know what you mean about reg files. Would be good if double clicking them didn’t do that.

      ALWAYS make a backup before editing.

      Cheers

      Phil

      Reply
  3. DEBASHIS CHAKRABORTY

    October 31, 2018 at 9:42 pm

    Very useful .Techniques are useful for doing the work more faster.

    Reply
    • Philip Treacy

      November 1, 2018 at 7:21 am

      Thanks

      Reply
  4. Nitish Sharma

    August 8, 2018 at 5:19 pm

    very helpful for me,

    Please share more videos and excel dashboard.
    nice…

    and thanks,

    Reply
    • Mynda Treacy

      August 8, 2018 at 8:15 pm

      Glad you liked it, Nitish 🙂

      Reply
  5. mo

    July 19, 2018 at 8:25 am

    i just love it thank you soooooooooo much

    Reply
    • Philip Treacy

      July 19, 2018 at 8:29 am

      You’re welcome 🙂

      Reply
  6. Alex B

    March 30, 2018 at 3:40 pm

    Great article.
    I have known about the Excel functions Char() & Code() and the vba functions Chr() & Asc() for a while but have only recently found out about the vba Unicode functions ChrW() & AscW().

    I don’t if there is an Excel function to handle the Unicode.

    Reply
    • Philip Treacy

      March 30, 2018 at 4:24 pm

      Thanks Alex.

      You could write your own function to handle Unicode like so

      
      Function charw(target As Long)
      
          charw = ChrW(target)
      
      End Function
      
      

      then call it in the worksheet :

      =charw(923)

      which will print Λ (Upper case Lambda).

      This simple function requires you to convert the Unicode hex values to decimal (039B to 923), but you could rewrite it to accept hex values.

      Cheers

      Phil

      Reply
      • Alex B

        March 31, 2018 at 4:43 pm

        Thanks Phil,

        I am not really likely to need a UDF for this but having said that I am not really a fan of using them either.
        Making a UDF volatile seems like a bad idea but without that I have never been comfortable that they recalculate at the right times.
        For example if you hand a UDF the first and last cell to sum a range, I don’t think it recalculates if you change a value between those cells.
        If you have a post covering recalculation of UDFs maybe post a link here for me.

        PS: I am a bit if a UDF luddite and in trying to set up an example to test this I couldn’t even get the worksheet function “sum” to work when passing in a first and last cell.

        Reply
        • Philip Treacy

          April 4, 2018 at 3:25 pm

          Hi Alex,

          Depending on what the UDF is doing it may or may not recalculate when you want it to. I haven’t written a post on this topic but sounds like a good one to cover.

          Excel will monitor the arguments passed into your function to see if they have changed, and then recalculate as required. If, for example, you trying to sum a range but only pass in the first and last cells, but some other cell in the range changes, the function won’t recalculate. You’re best off passing in the entire range so Excel will monitor the entire range for changes:

          
          Function sumall(myrange As Range)
          
              sumall = WorksheetFunction.Sum(myrange)
          
          End Function
          
          

          and call it like this if wanting the sum of cells A1:D10 :

              =sumall(A1:D10)
          

          Cheers

          Phil

          Reply
  7. Joan

    March 30, 2018 at 1:55 am

    Thank you for the great explanation of history and use of Alt Code and Unicodes. ☺

    Reply
    • Philip Treacy

      March 30, 2018 at 9:50 am

      You’re welcome

      Reply
  8. Vergenia

    March 30, 2018 at 1:49 am

    Thanks Mynda

    Reply
    • Mynda Treacy

      March 30, 2018 at 8:03 am

      Actually, Phil wrote this post, but we’re glad you liked it 🙂

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.