Table of Contents

Superscript and Subscript

It’s easy to format a character as superscript (slightly above the baseline) or subscript (slightly below the baseline) in Excel.

1. For example double click cell A1.

Double Click Cell

2. Select the value 2.

Select Character

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

Format Cells

The ‘Format Cells’ dialog box appears.

4. On the Font tab under Effects click Superscript.

Click Superscript

5. Click OK.

Result:

Superscript in Excel

6. Needless to say a superscript effect cannot return a result. To square a number use a formula like this:

Square a Number

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

7. To format a character as subscript (slightly below the baseline) repeat steps 1-5 but at step 4 click Subscript.

Result:

Subscript in Excel

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

Insert Equation

Note: equations in Excel are floating objects and do not return results.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog