×
英语
很抱歉。本文没有你的语言版本。

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

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

If you are an Office subscriber, 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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×