DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Format Text or Characters as Superscript/Subscript in Excel 365?

In this article, we are going to see how to Format Text or Characters as Superscript/Subscript in Excel Office 365 using Kutools. Let’s jump into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Format Text or Characters as Superscript:

Check this too: Subscript All Numbers in Chemical Equations

If you want to apply a superscript format for your input text or characters, then follow the below steps.

  • You need to select a cell that contains text or character to apply superscript format.

Input Cell
Input Cell

  • On the Kutools Tab, select the Format option, choose the Superscript/Subscript option from the drop-down list.

Go to the Kutools Tab
Go to the Kutools Tab

  • Now, it will display the Superscript/Subscript Formatting Dialog Box.
  • In that dialog box, you can see that all the contents of the selected cell will be displayed in the box.
  • You need to click one character that you want to format and click the Superscript option under the Char 3 section.
  • You can also apply the formatting attributes such as bold, italic, font size, and the case for the input characters.
  • After formatting one character, repeat the above four steps to continue formatting other characters.
  • Then, click the OK button.

Click the OK button
Click the OK button

  • At last, you can get the result as shown in the below screenshot.

Output
Output

Steps to Format Text or Characters as Subscript:

To format input values as a subscript, please follow the below steps.

  • You need to select a cell that you want to format as a subscript.

Input cell
Input cell

  • Go to the Kutools Tab, select the Format option, choose the Superscript/Subscript option from the drop-down list.

Go to the Kutools Tab
Go to the Kutools Tab

  • Now, it will open the Superscript/Subscript Formatting Dialog Box.
  • In that dialog box, you can see that all the contents of the selected cell will be displayed in the box.
  • You need to click one character that you want to format and click the Subscript option under the Char 3 section.
  • You can also apply the formatting attributes such as bold, italic, font size, and the case for the input characters.
  • After formatting one character, repeat the above four steps to continue formatting other characters.
  • Then, hit the OK button.

Hit the OK button
Hit the OK button

  • Finally, you can see that the characters that you specified have been formatted as subscript as shown in the below image.

Result
Result

Note:

  • You can also check the In-cell preview option to see the effect instantly without clicking the OK button.
  • If the selected cell contains a formula, this operation cannot be used.

Summary:

In the above article, you can easily understand the steps to Format Text or Characters as Superscript/Subscript in Excel Office 365 using Kutools. Leave your feedback in the comment box. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

Top comments (0)