Subscript and superscript in Excel work differently than in word processors

Excel does not have a built-in subscript or superscript button like Word does. If you type a number or letter and expect to shrink it below or above the baseline, Excel will not do that automatically. Instead, you have three real paths: format text within a single cell using the Format Cells dialog, use a workaround with special characters, or switch to a different tool if you need this frequently.

The most reliable method is the Format Cells dialog, which lets you shrink and shift text within one cell. This works best when you have a small amount of subscript or superscript — a chemical formula, a footnote number, or an exponent. If your spreadsheet is mostly subscript and superscript, Excel becomes tedious, and a word processor or dedicated equation editor may save you time.

Key Takeaways

  • Excel's Format Cells dialog can make text subscript or superscript, but only within a single cell and only after you select the specific characters you want to format.
  • You must double-click the cell to enter edit mode, then highlight only the characters you want to shrink and shift, before opening Format Cells.
  • Special character codes and the Insert Symbol dialog offer an alternative if you need only one or two subscript or superscript characters in your entire sheet.
  • If you are writing chemical formulas, equations, or documents with many subscripts, a word processor like Google Docs or Microsoft Word handles this more smoothly than Excel.

Using the Format Cells dialog to make text subscript

Start by double-clicking the cell that contains the text you want to format. This puts the cell into edit mode, where you can select individual characters. You will see a cursor blinking inside the cell.

Now highlight only the characters you want to make subscript. Click and drag to select them, or hold Shift and use the arrow keys. For example, if the cell reads "H2O" and you want only the "2" to be subscript, select just that character.

With the characters selected, right-click and choose Format Cells, or press Ctrl+1 on Windows or Command+1 on Mac. The Format Cells dialog opens. Click the Font tab if it is not already selected. You will see a checkbox labeled Subscript — check it. Click OK. The selected characters shrink and move below the baseline of the rest of the text.

Press Enter or click outside the cell to exit edit mode and see the final result. The subscript formatting stays in place.

Using the Format Cells dialog to make text superscript

The process for superscript is identical to subscript, except you check the Superscript box instead. Double-click the cell, select the characters you want to raise (such as an exponent or a footnote marker), right-click and choose Format Cells, click the Font tab, check Superscript, and click OK.

Superscript is useful for mathematical exponents (like 23 for "two to the power of three"), trademark symbols, or footnote numbers. The same rule applies: you can only format characters that are already in the cell. You cannot type new text and have it automatically appear as superscript.

Inserting special characters for subscript and superscript

If you need only one or two subscript or superscript characters and you do not want to edit an existing cell, you can insert them as special characters. Click the cell where you want the character to appear. Go to the Insert menu and choose Symbol (on Windows) or Special Characters (on Mac).

A dialog opens showing available characters. Search for "subscript" or "superscript" to see what is available. Common subscript numbers like ₁, ₂, and ₃ exist as standalone characters, as do superscript numbers like ¹, ², and ³. Select the character you want and click Insert. It appears in the cell as a regular character, not as formatted text.

This method is slower than using Format Cells if you have many subscripts to add, but it is faster if you only need one or two and you want to avoid editing mode. The downside is that not all subscript and superscript characters exist as special characters — you cannot insert a subscript "x" this way, for example.

When to use a different tool instead of Excel

If your work involves many subscripts or superscripts, Excel is not the right tool. Google Docs, Microsoft Word, or LibreOffice Writer all have subscript and superscript buttons in the toolbar, and they explore formatting as you type. If you are writing a chemistry lab report with multiple chemical formulas, or a math document with many exponents, you will finish faster in a word processor.

For complex equations with multiple levels of subscripts, superscripts, fractions, and symbols, consider a dedicated equation editor like MathType or the equation tools built into Word and Google Docs. These let you build equations visually and insert them into your document as objects, rather than trying to format individual characters.

If you are building a spreadsheet that happens to need one or two subscripts, Excel's Format Cells dialog is fine. If subscript and superscript are central to your work, switch tools.

Troubleshooting subscript and superscript formatting

The most common mistake is forgetting to enter edit mode. If you select a cell and open Format Cells without double-clicking first, the subscript and superscript options will be grayed out. Always double-click the cell and select the specific characters you want to format.

Another issue is selecting too much text. If you select the entire cell content and explore subscript, all of it shrinks. Select only the characters that should be subscript or superscript. If you make a mistake, press Ctrl+Z to undo and try again.

If you copy a cell with subscript or superscript formatting and paste it elsewhere, the formatting usually comes along. If it does not, the receiving cell may have different font settings. Reapply the formatting in the new location.

Frequently Asked Questions

Can I make an entire column subscript or superscript?

No. Subscript and superscript in Excel only work on individual characters within a single cell. If you need to format an entire column, you would need to edit each cell separately, which is impractical. A word processor or database tool would be better suited for that task.

Does subscript and superscript formatting stay when I save the file?

Yes, as long as you save the file in Excel format (.xlsx or .xls). If you save as a plain text file (.csv or .txt), the formatting is lost because those formats do not support character-level formatting. Always save as .xlsx if you want to keep subscript and superscript.

Can I use keyboard shortcuts for subscript and superscript in Excel?

Excel does not have built-in keyboard shortcuts for subscript and superscript like Word does (Ctrl+= for superscript, Ctrl+Shift+= for subscript). You must use the Format Cells dialog. If you need keyboard shortcuts, use Word or Google Docs instead.

What if the subscript or superscript text looks too small to read?

Subscript and superscript are always smaller than regular text — that is the point. If readability is a problem, consider using a different notation, like writing "H2O" instead of "H₂O", or switching to a tool designed for scientific or mathematical notation.

Can I explore subscript and superscript to numbers in a formula?

No. If a cell contains a formula (something starting with =), you cannot edit it the way you edit text. The formula calculates a result, and you can format that result, but you cannot select individual characters within a formula to make them subscript. Format the result after the formula calculates.