Easier way to superscript text in Excel?

[simms]

I'm doing several physics labs for school and there are various powers, etc used in equations. These are for display purposes, not for calculations used by Excel. Is there a way to add a shortcut onto the toolbar like Word where I can click a button and it can make the selected text super/subscript? I can only do this currently by selecting text, right click, format cells, then superscript, then OK. That's a lot of work.

Any help?

-Simon

 

[kranky]

You can record a macro and assign it to a key like CTRL-a.

Start the macro recorder with a cell selected, then go through the format cells - superscript - OK steps, and stop the recorder. Then edit the macro to remove all the lines between "With Selection.Font" and "End With" except the line that says ".Superscript = True" so you don't affect other attributes of the cell.

 

[BillinSDCA]

Here is a site totally dedicated to Excel help:

OzGrid Excel Forum

HTH,
Bill