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
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.
Last edited by swatsp0p; 02-01-2005 at 11:15 AM. Reason: additional information...
Bruce
The older I get, the better I used to be.
USA
You may want to look at John Walkenbach's addin:
http://j-walk.com/ss/excel/files/supersub.htm
Brady wrote:
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks