search
HomeCommon ProblemHow to apply superscript and subscript formatting options in Microsoft Excel

How to apply superscript and subscript formatting options in Microsoft Excel

Apr 14, 2023 pm 12:07 PM
characterCellspreadsheetsuperscript

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:云东方. If there is any infringement, please contact admin@php.cn delete

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools