Formatting Issues

How to Apply Superscript and Subscript Formatting in Excel

Ayan Masood Sep 28, 2026 869 views

Question details

The user wants to know how to apply superscript and subscript formats to text or numbers within an Excel cell.

How to Apply Superscript and Subscript Formatting in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting specific characters, such as mathematical powers or chemical formulas, within a cell or formula bar.
Observed behavior: Excel does not have a dedicated Symbol dialog subset for superscripts and subscripts, so users must apply these effects manually via font formatting settings.

Before you start

Double-click the target cell to enter edit mode, as you typically need to select specific characters rather than the entire cell to properly apply superscript or subscript effects.

Solution 1Recommended

Apply Formatting Using the Format Cells Dialog

The standard and most reliable method to apply superscript or subscript effects to selected characters in an Excel cell.

By using the Format Cells menu, you can precisely control which characters within your text string are elevated or lowered without altering the entire cell's layout.

Select the characters

Double-click the cell containing the text and highlight only the specific characters you want to format. Alternatively, you can select them directly in the formula bar at the top.

Open Format Cells

Right-click the highlighted text and choose 'Format Cells' from the context menu, or use the keyboard shortcut Ctrl+1.

Apply the effect

In the Format Cells dialog, navigate to the 'Font' tab. Check the box for 'Superscript' or 'Subscript' under the Effects section, then click OK to apply the formatting.

Apply Formatting Using the Format Cells Dialog

Shortcut Tip: Once the Format Cells dialog is open, you can press Alt+E to quickly check Superscript or Alt+B for Subscript.

Solution 2

Add Commands to the Quick Access Toolbar

Customize your Excel interface for one-click access if you frequently use superscript and subscript formatting.

Efficient Spreadsheet Formatting

Format Cells Easily with WPS Spreadsheet

WPS Office provides an intuitive, free alternative for all your spreadsheet tasks, including advanced cell formatting. You can quickly apply superscript and subscript effects with a highly familiar interface.

1. Select Text: Open your spreadsheet in WPS Office and double-click the cell to select the specific text or numbers.
2. Open Format Menu: Right-click the selected text and choose 'Format Cells', or simply press Ctrl+1 on your keyboard.
3. Apply Effect: Under the Font tab, check the Superscript or Subscript box and click OK.

Easily apply superscript and subscript formatting to any selected cell data.Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Free, lightweight, and fast-loading comprehensive office suite.Familiar ribbon interface requires zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Can I apply superscript to an entire cell instead of specific characters?

Yes, you can click once on the cell to select it entirely, right-click, choose Format Cells, and apply the superscript or subscript effect. However, this will format all current and future text typed within that cell, which may not be ideal if you only need partial formatting.

Are there direct keyboard shortcuts for superscript and subscript in Excel?

Excel does not have default direct keyboard shortcuts like Microsoft Word (where you can use Ctrl+= or Ctrl+Shift++). In Excel, you must press Ctrl+1 to open the Format Cells dialog, then press Alt+E for Superscript or Alt+B for Subscript, followed by Enter.

Why did my numbers change to regular text after applying superscript?

When you apply superscript or subscript to a portion of numbers within an Excel cell, the cell's underlying format is typically treated as Text. This means you may not be able to use those specific numbers in standard mathematical formulas or calculations without losing the visual formatting.

Is it possible to add superscript options to the main Ribbon?

Yes. Go to File > Options > Customize Ribbon. You can create a new custom group under the Home tab and add the Superscript and Subscript commands from the 'All Commands' list for easier access.

Document & File Issues