3: Superscript / Subscript button. Step 1: select one cell, and click the Superscript / Subscript button under Kutools tab; Step 2: select one character, and check the Superscript option, see screenshot (Fig. 4); Step 3: if you need to format other characters as superscripts, redo the Step 2. In the Format Cells dialog, check the Superscript or Subscript If you have not Classic Menu for Excel 2007/2010/2013/2016 installed, you can The ribbon interface is a bit difficult to get the Format Cell dialog.
What is Superscript? It’s when you are using small letters or numbers that are attached to the top of the regular sized letters. For example, when writing ordinal numbers, such as 1 st, 2 nd, 3 rd etc, or when you mention powers in math such as 2 8. Subscript is the same but with letters attached to the bottom. For example with chemical formulas: H 2O, or when mentioning number bases in math: 64 16. Formatting the text as superscript or subscript goes as follows: • Write the text as usual, with regular sized letters, and press Enter.
• Now double click inside that cell, and carefully select the characters to become superscript. • Right click inside your selection, and choose 'Format cells' (or use the shortcut keys: Ctrl+1) • Check the 'Superscript' box and click OK. • Now click outside the cell, and you're done.
Ever wanted to add a subscript or a superscript to the contents of a cell? Game Zombie Bowl-o-rama Full Version. 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. 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.