If you’re dealing with chemical formulas in Excel 2010 spreadsheet, you may need to apply super-script and sub-script. In this post we will let you know how to do it. To change text into superscript/subscript values, select the text you want to change into superscript or subscript, right-click the selected text and click Format Cells. Wd passport for mac update firmware.

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. [ad#in-post-ad] 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. Adobe photoshop touch for android. Step 2: Select the text in the formula bar that you want to make a subscript or superscript. [ad#in-post-ad] 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. 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 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.

EASY WORKAROUND— Excel 2010 will not allow superscripted (same goes for subscripts) numbers to appear next to another number in regular font in the same cell (as if numerically writing “5 squared”). The superscript will appear while the cell is active, but once moving to another cell, the superscripted font reverts to normal.

Here’s the workaroundType a space between the regular-font number and the superscripted number, then superscript the desired number. You can then select the space (the one you just typed in between the numbers) and make it a font size of 1 to make the space virtually disappear.