MS Excel, Subscript and Superscript macros

End user supplied how to documents and discussion.

MS Excel, Subscript and Superscript macros

Postby Doug » Fri Dec 05, 2008 3:03 pm

MS Excel lacks buttons for changing characters to subscript and superscript styles, unlike MS Word. QuicKeys can very simply do this. I set the "Action Scope" to Microsoft Excel in each case, and assigned my choice of Hot key F10 for Subscript and Shift-F10 for Superscript
First, select the cell or a character string in the cell that you want to change, then push F10 or Shift-F10, which makes the change in font and returns you to the cell you were in. Example: in a cell containing the word, "SUBSCRIPT", select the character string "SCRIPT" and tap the F10 key. Thus, you can create C2H5OH, where the small letters would be subscripted but I can't show that in this message!
Subscript macro (assign to Hot key: F10; (your choice of hot key)
Type Keystroke [Ctrl+1] ; this produces the Font menu
Type Keystroke [Alt +B] ; this puts a check mark in the Subscript box
Type Keystroke [Enter] ; this makes the change and exits back to the cell you were in

Superscript macro (assign to Hot key: Shift+F10; (your choice of hot key)
Type Keystroke [Ctrl+1] ; this produces the Font menu
Type Keystroke [Alt+E] ; this puts a check mark in the Superscript box
Type Keystroke [Enter} ; this makes the change and exits back to the cell you were in.

Theoretically you can assign these to a custom button in Excel, but I haven't figured out how!
Doug
 
Posts: 1
Joined: Thu Dec 04, 2008 9:11 pm

Re: MS Excel, Subscript and Superscript macros

Postby reyes » Wed Sep 16, 2009 11:40 pm

Awesome! Thank you for sharing these. :wink:
reyes
 
Posts: 1
Joined: Wed Sep 16, 2009 11:37 pm


Return to QKW How Tos

Who is online

Users browsing this forum: No registered users and 4 guests

cron