Apr 15 2010

Adding Subscripts and Superscripts to a Cell

Ever wanted to add a subscript or a superscript to the contents of a cell?  Excel provides a method to do just that, although it might not be intuitive to do so.


Subscript / Superscript Example
Below are the steps necessary to place a subscript or a superscript into a cell.  The process is the same for both, you just select which one you want to use during the process.  So let’s get started.

Step 1: Type the contents of you cell, including the subscript or superscript text.

Step 2: Select the text in the formula bar that you want to make a subscript or superscript.


Step 3: Right click and select “Format Cells” or go to the menu bar at the top and select “Format”–> “Cells”.  Once this is selected, chose “subscript” or “superscript” and click “OK”.

Step 4: Enjoy your new Subscript or Superscript.

That’s it.  This can also be done in VBA code but we’ll save that for another day.  If you want to try it for yourself in the meantime, don’t forget you can do it by recording a macro and viewing how Excel handles it.

Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 


1 Comments on this post


  1. Underfloor heating mats said:

    A different option would be to take the column, get rid of your superscript, and set the superscript in a no cost floating text box (alternatives for this are to thewon’t be inside actual cell, but when printed out or what ever, it’s going to search to be suitable following to it.

    November 1st, 2010 at 2:29 pm

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks