Excel - superscript/subscript

[Thunderbolt]

Doing loads of simulations on Excel at the moment and really missing the lack of a shortcut to the sub/superscript buttons as you get in Word. Tried the the 2010 version as well to find it hasn't been implemented there either.

Does anyone know if there is a reason why they don't put this feature in, and if there is a way of making a macro to do it. Am I the only one that finds it really annoying

 

[Meeko]

Sub Superscript()
     If Selection.Font.Superscript= False Then
          Selection.Font.Superscript= True
     Else
          Selection.Font.Superscript= False
     End If
End Sub

Sub Subscript()
     If Selection.Font.Subscript= False Then
          Selection.Font.Subscript= True
     Else
          Selection.Font.Subscript= False
     End If
End Sub

EDITED : Tweaked the macro so that it will change format of text to opposite of current format (allows your to turn Superscript on or off using the same button)

Use those as your macros and assign them to a custom toolbar button

Right click on a toolbar
choose Customise
goto Commands tab
select Macros from the list on the left
then drag and drop the Custom Buttom from the right onto the toolbar
Right click on the button and select Assign Macro...
Chose the appropriate Macro (Sub/Superscript)

 

[Thunderbolt]

Thanks for your help, can't seem to follow your instruction using Excel 2007 though.