Comments on: How to do subscript and superscript in Excel for text and numbers

In this tutorial, you will learn many different ways to do superscript and subscript in Excel: keyboard shortcuts, custom formats, writing superscripted and subscripted characters with a mouse, and more. Continue reading →

Table of contents

Comments page 2. Total comments: 45

  1. Great article very helpful. I would like to have 4 options in a drop down menu that contain a mixture of units, eg cm, cm2, m and m2. Is it possible to have the 2 in the options as superscript??
    Thanks

    1. cm
      cm2
      m
      m3

      Use these in a values in a sheet and refer this as source for the List to be considered for the drop down.

      I.e., source = =$C$23:$C$26

  2. Excellent article. Found exactly what i was looking for, and could do what i needed in more than 1 manner.

  3. Hallo, i would like to ask a simple question. I often work with tables including many cells containing entries in the following format "numberT" (e.g. 2547T or 12344T). Is it possible to automatically superscript the "T" letter simultaneously in multiple cells? I tried to replace the T with the superscript formatted T but it resulted in the superscript format of all cell contents (not only the T).
    Thank you, Pavel

  4. how does this thing work????

  5. Is there a way to make letter subscripts (e.g. with symbols) so that I could insert that to my graphs without any extra fuss?

  6. Hello
    do you have any idea how to set superscript into auto correct? i.e 1st, m2 to be superscript automatically set into auto correct. i have tried to copy from the cells but could not paste it at auto correct.

    thanks
    Chris

  7. I am running excel 2016 and the quick command for superscripts and subscripts is not under "Commands Not in the Ribbon" as said in the "Add Superscript and Subscript icons to Quick Access Toolbar" section of this article. It is not even in "All Commands"

  8. Hi
    extremely helpful guide! Thank you!

    Is there also a comma symbol for superscript and subscript?

    Best regards

  9. Can you tell how to subscript/superscript in "Google Sheets" ? None of these work there.
    Even google docs command "ctrl+, " is not working in sheets.

      1. Thanks Darling!

  10. Why I try the format but didn't work with me

  11. ="Dated this the "&TEXT(TODAY(),"dd")&"ᵗʰ"&" day of "&TEXT(TODAY(),"MMMM")&", 2019"

    1. How about 1st and 2nd, can you share with me that fonts?

      1. I leave this here for anyone who struggle with the same problem in the future...

        ˢᵗ , ⁿᵈ , ʳᵈ , ᵗʰ

        1. Can you help for superscript 2 - 3 (Ex: m^2, m^3) as well bro?

  12. When i use text inside an ''IF" formula i cannot change the formatting and all the superscripts and subscripts return to normal. Is there any way to change the format inside the "IF" ??

  13. thanks

  14. I tried the ctrl1 for superscript and it worked but the moment I move to the next bar it goes back to the same number without subcript.why is that?

    1. I have this same problem. When I double click on the cell it shows the superscript formatting but if I click out of that cell it goes away.

  15. Thanks very Much
    It was very very usefull.

  16. why i could not use CHAR function to generate superscript? When i input formula =A2&Char(185), it always shows Char(185) as empty or blank.

    1. Tdat:
      The character returned is based on the character set used by your computer. Entering A2&CHAR(185) in A3 should add the superscript to the number displayed in A3 to the number displayed in A2.
      You can see the character set you are currently using and change to another set in Win 10 by:
      Open Control Panel, go to Clock, Language, and Region,select Region. Now the Region wizard opens and the Administrative tab is there. You can see your region and language and add a language if needed.
      However, this will change all the characters you use on your computer.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)