Adding Subscripts and Superscripts to a Cell
- 7 Comment
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
7 Comments on this post
Trackbacks
-
Automobile India said:
Subscripts will apply only to the element to their immediate left unless parenthesis tell you to apply the subscript to the whole unit.
May 4th, 2010 at 1:25 am -
Automobile India said:
Another option is to take the column, remove your superscript, and put the superscript in a free floating text box (options for this are on the drawing toolbar – view|toolbars). Then it won’t be in the actual cell, but when printed out or whatever, it will look to be right next to it.
June 1st, 2010 at 11:54 pm -
Automobile India said:
I’ve a friend who is writing a drafting textbook and needs someone who is experienced in MS Word and symbols such as subscripts, superscripts and square roots. Where would I look for such a person??
July 1st, 2010 at 4:51 am -
used tires said:
Awesome! Been looking for this, I couldn’t believe that my biology professor actually graded us all lower because everyone in the class did not have their subscripts/superscripts as you call it, in the right presentation style, we were all baffled that she marked us for such a silly thing!
Till then,
Jean
July 18th, 2010 at 4:21 am -
Automobile India said:
I use a spreadsheet that I created myself as a template, and we use zeros and ones to ‘add up’ scores. To keep track of the zeros we use superscript. For one, two or three zeros we use a symbol so that it can be copied and pasted to another cell.
August 2nd, 2010 at 4:55 am -
PY said:
You can copy the correctly formated text from MSword. That way you can use the short cut keys to get the super/sub-scripts without going into the option menu. (super script: ctrl+shift+”+”; subscript: ctrl+”+”)
August 9th, 2010 at 5:45 pm -
computer support said:
Many time came across with this problem while was working in office.
Thanks for solving my problem. You showed how easily super/sub script we can do. I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.August 21st, 2010 at 2:36 pm
Loading ...