Results 1 to 6 of 6

Shortcut Key for Subscripts/Superscripts

This is a discussion on Shortcut Key for Subscripts/Superscripts within the Excel Questions forums, part of the Question Forums category; Does anyone know how the shortcut key to subscript/superscript highlighted text??? In word2000 you simply highlight and press CTRL-'=' for ...

  1. #1
    Guest

    Default

    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?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,114

    Default

    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

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136

    Default

    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 ]

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    357

    Default

    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/viewtop...5752&forum=2&8

    [ This Message was edited by: Cosmos75 on 2002-04-19 11:29 ]

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,114

    Default

    Hi cosmo this links in with post
    http://www.mrexcel.com/board/viewtop...752&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...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com