Discussion Locked

Superscripts in Excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a shortcut or any way of creating superscripts and subscripts in an Excel cell? I was trying to type exponents and it wouldn't work.

2 replies

by dklippert

First select the text, then go to Format>Cell and choose Superscript. You could record a macro, or use the shortcut:
SuperScript
Alt+O+e+Alt+e+Enter

Subscript
Alt+O+e+Alt+b+Enter

by dklippert

Here's something else for you.
For ? use Alt and 0176 on the keypad
For ? use Alt and 0178 on the keypad
For ? use Alt and 0179 on the keypad

John Walkenbach has a free download to do this as well:
(There are no spaces in the URL)

www.j-walk.com/ss/excel/files/supersub.htm

Macros won't work while the cell is in edit mode, but you could go through the troble of writing one to do it after the entry.

This discussion is closed to new replies.