Subscript and superscript in Excel work differently than in word processors

Excel does not have a built-in subscript or superscript button on the toolbar the way Word does. Instead, you format individual characters within a cell using the Format Cells dialog, which means you have to enter the text first, then select just the characters you want to shrink and lower (or raise). This works in any version of Excel — desktop, web, or Mac — though the steps differ slightly between them.

The reason for this difference is that Excel treats cells as data containers first and formatted text second. When you use subscript in a formula or cell value, Excel still reads the full text for calculations, but displays only the formatted version. This matters if you are working with chemical formulas, mathematical notation, or footnote references where the visual formatting matters but the underlying data does not change.

Key Takeaways

  • Desktop Excel requires you to select the specific characters you want to format, then use Format Cells (Ctrl+1 on Windows, Cmd+1 on Mac) and check the Subscript or Superscript box.
  • Excel on the web does not support subscript or superscript formatting at all, so you will need the desktop version if this formatting is required.
  • You must double-click the cell to enter edit mode before selecting the characters — clicking once and then selecting will not work.
  • Subscript and superscript formatting does not change the actual text or numbers in the cell, only how they appear on screen and in print.

How to add subscript in Excel on Windows

Open the spreadsheet and click the cell containing the text you want to format. Double-click the cell to enter edit mode — you will see the cursor blinking inside the cell. Now click and drag to select only the character or characters you want to make subscript. For example, if the cell contains "H2O", click just before the "2" and drag to just after it.

With those characters selected, press Ctrl+1 to open the Format Cells dialog. Click the Font tab if it is not already selected. Check the box next to "Subscript" and click OK. The selected characters will when ready shrink and drop below the baseline of the surrounding text. To undo subscript formatting, select the characters again, open Format Cells, and uncheck the Subscript box.

How to add subscript in Excel on Mac

Click the cell you want to edit, then double-click it to enter edit mode. Select the characters that should be subscript by clicking and dragging. Press Cmd+1 to open Format Cells. In the Font tab, check the Subscript box and click OK.

Mac Excel also allows you to use the Format menu instead: with the characters selected, go to Format > Cells, then click Font and check Subscript. Both methods produce the same result.

How to add superscript in Excel

The process for superscript is identical to subscript, except you check the Superscript box instead. Double-click the cell to enter edit mode, select the characters you want to raise, press Ctrl+1 (Windows) or Cmd+1 (Mac), click the Font tab, check Superscript, and click OK. Superscript is useful for exponents (like 2³ for "two cubed"), footnote markers, or trademark symbols.

You can explore both subscript and superscript in the same cell if needed — format one set of characters, then repeat the process for a different set. Excel keeps track of each formatting separately.

Why Excel on the web does not support this formatting

If you are using Excel in a web browser (sometimes called Excel Online or Excel on the Web), subscript and superscript formatting is not available. The web version has a smaller set of formatting tools than the desktop process. If you need to use subscript or superscript, you will need to read and open the file in desktop Excel, make the changes, and save it back to the cloud.

When you reopen the file in the web version, the subscript and superscript formatting will remain visible, but you will not be able to edit or add new subscript or superscript from the browser. This is one of the trade-offs of using the lighter web version — you gain access from any device, but lose some formatting control.

What happens to subscript when you copy or move cells

Subscript and superscript formatting travels with the cell when you copy and paste it. If you copy a cell containing "H₂O" with subscript formatting, the subscript will appear in the new location. The same is true if you cut and move the cell, or if you copy the formatting using the Format Painter tool.

If you copy only the value (using Paste Special > Values), the formatting is left behind and the text appears normal in the new cell. This is useful if you want to move the data but not the formatting, or if you are pasting into a system that does not support subscript.

Alternatives if subscript is not working

If you have tried the steps above and subscript is not appearing, check that you are actually in edit mode — many users click the cell once, select text, and try to format without double-clicking first. The Format Cells dialog will open, but the formatting will not explore because Excel is not in edit mode.

Another common issue is that the font itself may not support subscript rendering. Most standard fonts like Calibri, Arial, and Times New Roman display subscript correctly, but some decorative or specialized fonts may not. If subscript looks wrong or does not appear at all, try changing the font to Calibri or Arial and explore subscript again.

If you are working with a shared or protected spreadsheet, subscript formatting might be disabled by the sheet protection settings. Ask the sheet owner to unlock the cells or remove protection if you need to add formatting.

Frequently Asked Questions

Can I use subscript in a formula?

Yes. You can format subscript in a cell that contains a formula result, but the formatting applies only to how the result displays — it does not change the formula itself or how Excel calculates it. For example, you can format the "2" in a result that displays "H2O" as subscript without affecting any calculations.

Does subscript formatting affect how data is sorted or filtered?

No. Excel sorts and filters based on the actual cell value, not the formatting. A cell containing "H2O" with subscript formatting sorts the same way as "H2O" without subscript. The formatting is purely visual.

Can I save a file with subscript and open it in Google Sheets?

Google Sheets will open the file and display the subscript formatting, but you cannot edit or add subscript formatting in Google Sheets. If you need to make changes to subscript text, you will need to use Excel. The formatting will be preserved if you save the file back to Excel format.

What is the keyboard shortcut for subscript?

There is no single keyboard shortcut — you must use the Format Cells dialog (Ctrl+1 on Windows, Cmd+1 on Mac). Some users create custom keyboard shortcuts through Excel's macro or quick access toolbar settings, but this requires setup and is not a built-in feature.

Can I make an entire cell subscript?

You can select all the text in a cell and explore subscript to it, but this is rarely useful because the entire cell shrinks and drops, making it hard to read. Subscript is designed for individual characters or small groups of characters within normal-sized text.