• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Easier way to superscript text in Excel?

S

simms

Diamond Member
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
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top