Any shortcut for subscript and postscript in Excel?

[smallxyz]

Hi,

To subscript /postscript a certain letter within a cell, I wonder if there exists any more convenient shortcut to do so.
The best to my knowledge is to utilize Ctrl + 1, after selecting the letters within the cell.

Could there be any VBA solution or add-in for this?

I am currently using Excel 2007.

Thanks!

 

[James006]

Hi,

You could test and adapt the following

Sub Test()
ActiveCell.Characters(Start:=Len(ActiveCell), Length:=1).Font.Superscript = True
End Sub

HTH

 

[smallxyz]

Hi James, your code works well to superscript the last characters.
Thanks!

Is it also possible to superscript any other characters from different positions?

 

[James006]

Hi,

As I said, you can adapt the code to your needs ... :wink:

The portion .Characters(Start:= ...., Length:= ...) allows to precisely isolate any character in any position ...

HTH

 

[thisoldman]

ADVERTISEMENT

Perhaps you are looking to display chemical formulas? I've been generally pleased with the results of the Excel and Word add-ins from http://christopherking.name/ChemFormat/index.html

I've tried the add-ins using Office 2003 and 2013. There are occasional issues but they work exactly as I want 99 percent of the time.

 

[smallxyz]

Yes. In this way it may require frequent adjustments to the code.
I wonder if VBA could let Excel behave like Word's superscript-while-user-is-typing.
In this way, the superscript process will be more flexible.

 

[thisoldman]

I don't know if that is possible in Excel. I haven't been able to get a macro to run while Excel is in "Enter" or "Edit" modes. All the macros I've found do the font change after the data has been fully entered.

 

[thisoldman]

A workaround using keyboard shortcuts

While you're entering your text, press Ctrl+1. This brings up the format dialog for the font.
Next, to start typing in superscript, press Alt+e then the Enter key. To leave superscript mode, press Ctrl+1 and again press Alt+e and Enter.

To switch to subscripts, press Alt+b.

After a few thousand times, you might find the key-sequence finger-dance stops being annoying and awkward.