What is superscript and subscript in Excel?
Superscript is a small letter or number typed above the baseline. If there is any preceding text in a cell, superscript is attached to the top of the regular sized characters.
For example, you can use superscript to write square units like m2 or inch2, ordinal numbers such as 1st, 2nd, or 3rd, or exponents in math such as 23 or 52.
Subscript is a small character or string that sits below the line of text.
In math, it is often used to write number bases like 648 or chemical formulas such as H2O or NH3.
How to do superscript and subscript for text values
Most Excel formatting can be applied to any data type in the same way. Superscript and subscript are a different story. The methods described in this section work only for text values, but not for numbers. Why? I believe only the Microsoft team know the exact reason :) Possibly because this would convert numbers to strings and they want to prevent you from accidentally mangling your data.
Apply superscript or subscript format
Every time you want to format text in Excel, open the Format Cells dialog box. It allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want.
In case of superscript and subscript, there is one hurdle. You can't just apply the format normally to the entire cell because this would move all the text above or below the baseline, which is almost certainly not what you want.
Here are the steps to insert subscript or superscript correctly:
Select the text you'd like to format. For this, double click a cell and select the text using the mouse. Or you can go the old-fashioned way - click the cell and press F2 to enter edit mode.
Open the Format Cells dialog by pressing Ctrl + 1 or right-click the selection and choose Format Cells… from the context menu.
In the Format Cells dialog box, go to the Font tab, and select Superscript or Subscript under Effects.
Click OK to save the change and close the dialog.
Done! The selected text will be subscripted or superscripted depending on which option you've ticked off.
Note. Like any other formatting in Excel, it changes only visual representation of the value in a cell. The formula bar will display the original value without any indication of the applied superscript or subscript format.
If you have any query or want any help related to excel feel free to join our Telegram channel and message us..
Channel link :
https://t.me/msexcelmaster101
0 Comments