Sunday, March 28, 2021

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.

1 comment:

  1. I’m a 36-year-old software engineer living in the Midwest. Most of my early life I never had good credit. 3 months ago my credit scores were 580 low 600s. I was obviously not happy with those scores so I started to clean up my credit. Opened 2 secured cards; Discover IT for 200; Navy Federal secured for 250. Did the pledge loan as well; self-account, stellar fi, boom for renting reporting, cap one only a 300 limit. Asking a family member to become an AU on their BOA still nothing changed instead my credit score kept dropping. Thanks PINNACLE CREDIT SPECIALIST after reading so many reviews about them. When I got in touch with PINNACLE CREDIT SPECIALIST my story changed for the better. He helped me delete all negative items on my credit report within 6 days. My current score now is 806 TransUnion 811 Experian and 802 Equifax. Here is his contact info: PINNACLECREDITSPECIALIST@GMAIL.COM I proudly and strongly recommend PINNACLE CREDIT SPECIALIST service to everyone out there in need of a credit fix. He’s above the best and simply the best. 

    ReplyDelete