Friday, February 8, 2019

Format text or numbers as superscript or subscript

Format text or numbers as superscript or subscript

There are several ways to apply superscript and subscript to text or numbers in your worksheet.

Format text values as superscript or subscript

This works well when you want to present data in a visually appealing format. To format numeric values or formulas for a mathematical, chemical, or other type of technical expression, use the equation symbols and templates.

  1. Select characters in a cell or cell range that you'd like to format.

  2. On the Home tab, in the Font group, click the Font Settings dialog box launcher.

    Format Cells dialog box launcher

    OR

    Press CTRL+1.

  3. Under Effects, check the Superscript or Subscript box, and click OK.

    Format dialog box with superscript selected.

    Tip: Although Excel doesn't have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. Use Alt+HFNE for superscript, and Alt+HFNB for subscript.

Add superscript and subscript to your Quick Access Toolbar

If you are an Office subscriber or you have Office 2019, you can add shortcuts to the superscript and subscript commands to your Quick Access Toolbar. This keeps them at your fingertips to use any time. Learn more about customizing the Quick Access Toolbar

Quick Access Toolbar showing superscript and subscript commands

Apply superscript or subscript to a numeric value

When you want to present a formula or an equation for numeric values:

  1. Click Insert > Equation > Design.

  2. Click Script and select the format you want.

Superscript button on equation tool bar

  1. Click the squares and type the values.

Typing in the superscript format box

Tip:  The equation box isn't anchored to a cell and you can move, resize or rotate it using the handles.

Also check out formatting options for equations and formulas with the equation tools.

No comments:

Post a Comment