Shortcut keys for superscript and subscript

[Catherine]

I need to enter a significant number of chemical formulas
into excel. Does anyone know of any shortcut keys that
put characters into super and subscript? I have tried the
the ctrl + = and shift + ctrl + = combinations from Word,
but they don't workin in excel. Any hints would eb
helpful!

Thanks!

Catherine

 

[Peo Sjoblom]

I don't think there are any shortcuts for that, you might want to record a
macro
and tie it to a shortcut

otherwise you have to use several key presses

Ctrl + 1, F, tab 5 times and enter for superscript, tab 6 and enter for sub


a recorded macro edited a bit could look like

Sub Macro1()
'
' Macro3 Macro
' Macro recorded 2/16/2004 by Peo Sjoblom
'
' Keyboard Shortcut: Ctrl+y
'
With Selection.Font
.Superscript = True
End With
End Sub

 

[Gord Dibben]

Unfortunately macros won't function while in Edit mode, which mode the OP
would most likely be in.

John Walkenbach's SuperSub add-in would be the easiest and most convenient way
to go.

Allows selecting text to Super or Sub.

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

Gord Dibben Excel MVP