Shortcut Key for Subscripts/Superscripts

[Guest]

Does anyone know how the shortcut key to subscript/superscript highlighted text???

In word2000 you simply highlight and press CTRL-'=' for subscripting, CTRL+SHIFT+'=' for superscripting, but what about excel?

 

[Mark W.]

I don't think there is a keyboard shortcut. There's not even a supplied toolbar button! I trust that you know how to do it using Control+1.

 

[Jack in the UK]

HI

This can only be done via format cells, i have never solved this one, also VBA can do the same but need to secect carefully what to super or subscript else all i guess.

I have date ie ... 27th febuary 2002 to th in super

HTH

 

[gplhl]

On 2002-02-27 15:49, Jack in the UK wrote:
HI

This can only be done via format cells, i have never solved this one, also VBA can do the same but need to secect carefully what to super or subscript else all i guess.

I have date ie ... 27th febuary 2002 to th in super

HTH

Never done it myself, but if it can be done in VBA use what you have selected to tell it what range to cover, i.e. the cells you have highlighted.

Sub SuperScriptText()
'Superscript's the selected area
With Selection.Font
.Superscript = True
End With
End Sub

Then assign your own shortcut keys for the Macro.


_________________
Regards,

Gary Hewitt-Long
This message was edited by gplhl on 2002-02-27 16:04

 

[Cosmos75]

This works for cells, but what about only part of a cell?? I know you can choose where to start based on the length of the texts, but how about just selecting part of the cell and running a macro?

http://www.mrexcel.com/board/viewtopic.php?topic=5752&forum=2&8
This message was edited by Cosmos75 on 2002-04-19 11:29

 

[Jack in the UK]

Hi cosmo this links in with post
http://www.mrexcel.com/board/viewtopic.php?topic=5752&forum=2&14

where i have offered help and you choose not to take me up on that offer i guess you decided my help is not required...