Is there a shortcut key for subscript or superscript in excel?

Brady · 02-01-2005, 01:06 AM

Bill Martin -- (Remove NOSPAM from address) · 02-01-2005, 11:06 AM

Not directly that I'm aware of -- unless you've got some font that
supplies them.

However you can type x2, for example, then go back and highlight the 2,
then from the format cell panel you can tell it to make that a
superscript, etc.

Bill

**swatsp0p** · 02-01-2005, 11:07 AM

There is no built in shortcut, however you can add these macros to create one for each:

Note: this will format the cell only and will affect ALL text in that cell. It will not work on "selected text" within the cell. Macros cannot be run whilst in the Edit mode!

In your workbook, open the VBA editor (Alt+F11) and in the Project pane (left side) right click on your workbook's VBAProject and select Insert>Module

In the window that opens on the right, paste these macros:

Sub Macro1()
' Keyboard Shortcut: Ctrl+y
'
With Selection.Font
.Superscript = True
End With
End Sub

Sub Macro2()
'
'
' Keyboard Shortcut: Ctrl+j
'
With Selection.Font
.Subscript = True
End With
End Sub

Close the VBA window. Press Ctrl+F8 to open the Run Macro dialog. Select the Superscript macro with a *single* click then click Options. Enter "j" (no quotes) for the shortcut key and optionally, enter a description. Click OK, then select and repeat for Subscript, entering "u" for shortcut key. Click OK then Cancel to exit the dialog box.

Save your file! Now, pressing CTRL+u or CTRL+j changes text in the selected cell(s) to super- or sub- script.

Good Luck.