Home >Common Problem >How to apply superscript and subscript formatting options in Microsoft Excel
A superscript is a character or characters, either letters or numbers, that you need to set slightly higher than a normal line of text. For example, if you need to write 1st, the letters st need to be slightly higher than the characters 1. Likewise, a subscript is a group of characters or a single character and needs to be set slightly lower than normal text level. For example, when you write a chemical formula, you need to place the numbers below the normal line of characters. The following screenshots show some examples of superscript and subscript formatting.
Although it may seem like a daunting task, applying superscript and subscript formatting to your text is actually quite simple. In this article, we will explain in some simple steps how to easily format text using superscript or subscript. Hope you enjoyed reading this article.
Step 1:Double-click the cell containing the text to which you want to apply superscript formatting. Once in edit mode, click and selectthe text you want to set as superscript.
Step 2: With the text selected, right-click on it and select "Format Cells " option.
Step 3: In the Format Cells window, under the Effects section, select the The option Superscript corresponds to the checkbox. Click the OK button when finished.
Step 4: If you look at the formatted text now, you can see that the superscript formatting has been successfully applied.
Step 5: There is no shortcut to batch format superscript text. You need to apply superscript formatting one by one. Below is a screenshot of the entire column with superscript formatting.
Step 1: Just like in superscript formatting, firstDouble-click the cell and select the text to which you want to apply the subscript format .
Step 2: Now right click on the selected text and click Click the "Cell Format" option.
Step 3: Next, select the checkbox corresponding to the Subscript option andClick the OK button.
Step 4: If you look at the Excel worksheet now, you can see that the subscript formatting has been successfully applied.
Step 5: Again, we don’t have the option to batch apply subscript formatting. So, you have to do it manually one by one as shown in the screenshot below.
The above is the detailed content of How to apply superscript and subscript formatting options in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!