Home >Common Problem >How to apply superscript and subscript formatting options in Microsoft Excel

How to apply superscript and subscript formatting options in Microsoft Excel

PHPz
PHPzforward
2023-04-14 12:07:112345browse

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.

How to apply superscript and subscript formatting options in Microsoft Excel

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.

How to apply superscript formatting in Excel

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.

How to apply superscript and subscript formatting options in Microsoft Excel

Step 2: With the text selected, right-click on it and select "Format Cells " option.

How to apply superscript and subscript formatting options in Microsoft Excel

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.

How to apply superscript and subscript formatting options in Microsoft Excel

Step 4: If you look at the formatted text now, you can see that the superscript formatting has been successfully applied.

How to apply superscript and subscript formatting options in Microsoft Excel

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.

How to apply superscript and subscript formatting options in Microsoft Excel

How to apply subscript formatting in Excel

Step 1: Just like in superscript formatting, firstDouble-click the cell and select the text to which you want to apply the subscript format .

How to apply superscript and subscript formatting options in Microsoft Excel

Step 2: Now right click on the selected text and click Click the "Cell Format" option.

How to apply superscript and subscript formatting options in Microsoft Excel

Step 3: Next, select the checkbox corresponding to the Subscript option andClick the OK button.

How to apply superscript and subscript formatting options in Microsoft Excel

Step 4: If you look at the Excel worksheet now, you can see that the subscript formatting has been successfully applied.

How to apply superscript and subscript formatting options in Microsoft Excel

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.

How to apply superscript and subscript formatting options in Microsoft Excel

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!

Statement:
This article is reproduced at:yundongfang.com. If there is any infringement, please contact admin@php.cn delete