Lesson 50: How to add superscript and subscript in Excel

In this article, I will guide you to add superscript as exponent and subscript in Excel.

Join the channel Telegram belong to AnonyViet 👉 Link 👈

How to add superscript and subscript in Excel

first. For example, double-click cell A1.Lesson 50: How to add superscript and subscript in Excel 12

2. Select value 2.

Lesson 50: How to add superscript and subscript in Excel

3. Right-click, and then select Format Cells (or press Ctrl + 1).

Lesson 50: How to add superscript and subscript in Excel 13

4. On the tab Fontunder Effectspress Superscript.

Lesson 50: How to add superscript and subscript in Excel 14

5. Press OK.

Result:

Lesson 50: How to add superscript and subscript in Excel 15

6. The above index cannot return results. To square a number, use the following formula:

Lesson 50: How to add superscript and subscript in Excel 16

Note: to insert the caret symbol ^, press SHIFT + 6.

7. To format a character as subscript, repeat steps 1-5 but in step 4 click Subscript.

Result:

Lesson 50: How to add superscript and subscript in Excel 17

8. Did you know you can also insert equations in Excel? On the Insert tab, in the Symbols group, click Equation.

Lesson 50: How to add superscript and subscript in Excel 18

Note: Equations in Excel are image objects and do not return results.

In addition, you can also see many other excel articles here.

The article won: 1/5 – (999 votes)

Source: Lesson 50: How to add superscript and subscript in Excel
– TechtipsnReview

, , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *