Superscripts in Custom Formats

When working in Excel, you can easily format text so that it contains superscripts, subscripts, or whatever other formatting tricks you want. You use the Format Cells dialog box (Ctrl+Shift+F) to make these font modifications. This dialog box is not available when you are defining custom formats, however. (You can't use the tools on the Font tab of the Format Cells dialog box while you are defining a custom format on the Number tab of the Format Cells dialog box.) What if you want to place a superscript in your custom formats?

The answer is to use some of the special font characters available to Windows users. Using these characters you can easily insert superscripted numbers, as long as they are the numbers 0, 1, 2, or 3. Simply use the following shortcuts, where you hold down the Alt key as you type the numbers on the numeric keypad:

These shortcuts work if you are using the Arial font in your worksheet, which is the default. If you are using some other font, the character codes to create the superscripted numbers may be different. In that case, you will need to use the Windows Character Map accessory to figure out what shortcut keys to use to get the results you want. (On my Windows XP system, I can access the Character Map accessory by choosing Start | All Programs | Accessories | System Tools | Character Map. It may differ on your version of Windows. You may also need to install the Character Map using Windows Setup program if you cannot find it on your system.) When using the Character Map, you can select a symbol and see in the lower-right corner of the program window what the numeric keypad shortcut key is for the character.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8665) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Superscripts in Custom Formats.