How to Add Subscript and Superscript with a Formula in Excel 1. Using CHAR Function Select cell C5 and enter this formula to add superscripts using the CHAR function: ="2"&CHAR(185) Note: The CHAR function can only return 3 superscripts and no subscripts. 2. Using UNICHAR Function Sele...
Knowing how to format text or numbers in superscript and subscript formats will help you better present texts in technical expressions like exponents, units, and chemical formulas In Microsoft Word, it’s easy to find and apply these formats, but in Microsoft Excel, not so easy. This is becau...
This tutorial will teach you a few quick ways to insert superscript and subscript in Excel, both for text values and numbers. Microsoft Office users sometimes wonder why a particular feature is present in one Office application and absent in another. So is the case with superscript and ...
Excel Easy #1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us Superscript and Subscript in Excel It's easy to format a character as superscript (slightly above the baseline) or subscript (slightly below the baseline) in Excel. 1. For example...
Learn how to apply superscript and subscript formats in Excel using various methods, including formulas, custom formatting, and keyboard shortcuts.
Subscript is the same but with letters attached to the bottom. For example with chemical formulas: H2O, or when mentioning number bases in math: 6416.Formatting the text as superscript or subscript goes as follows:Write the text as usual, with regular sized letters, and press Enter. Now ...
How to add superscript or subscript in Excel The procedure to add superscript or subscript by using the Font Settings method or the shortcut is exactly the same as with Microsoft Word. Simply select the text that needs to be converted and add the needful. ...
5. And then click OK, the characters that you specified have been formatted as superscript. See screenshots:Format text or characters as subscript in a cell With this utility, you can also format the text as subscript in Excel. 1. Select the cell that you want to format the characters as...
Superscript and Subscript formats are used more often in MS Word and PowerPoint and you can also add these to Quick Access Toolbar. Unfortunately, there is no option to add these in the QAT in Excel.You May Also Like the Following Excel Tutorials:...
Select characters in a cell or cell range that you’d like to format. On theHometab, in theFontgroup, select the Font Settingsdialog box launcher. OR Press CTRL+1. UnderEffects, check theSuperscriptorSubscriptbox, and clickOK. Tip:Although Excel doesn’t have quick keyboard sh...