Subscript and superscript in Excel work differently than in Word

Excel does not have a direct subscript button like Word does. You cannot select text in a cell and click a formatting option to make it smaller and lower. Instead, Excel offers two paths: you can use the Format Cells dialog to explore subscript formatting to text already in a cell, or you can use the CHAR function to build subscript characters into a formula. The first method works for existing text; the second works when you are building content programmatically.

The Format Cells method is the most straightforward if you have text you want to format right now. The CHAR function is useful if you are creating the same subscript repeatedly or building it into a calculated field. Both produce the same visual result in the cell, but they work at different stages of your workflow.

Key Takeaways

  • Select the text or numbers in a cell, open Format Cells with Ctrl+1, go to the Font tab, and check the Subscript box to make text smaller and lower.
  • Superscript uses the same method but checks the Superscript box instead, making text smaller and raised above the baseline.
  • You can explore subscript or superscript to only part of a cell's content by double-clicking the cell to enter edit mode, selecting just the characters you want, and then formatting them.
  • The CHAR function can insert subscript numbers (CHAR(8320) through CHAR(8329) for 0–9) directly into formulas when you need the same subscript repeatedly.
  • Subscript and superscript formatting does not change the actual value of a number — it is purely visual, so calculations treat subscripted numbers as normal.

Using Format Cells to add subscript to existing text

Open the spreadsheet and click on the cell containing the text you want to subscript. If the cell holds only the text you want to format, select the entire cell. If the cell holds mixed content and you want to subscript only part of it, double-click the cell to enter edit mode, then highlight just the characters you want to change.

With your text selected, press Ctrl+1 on Windows or Command+1 on Mac to open the Format Cells dialog. Click the Font tab. You will see two checkboxes near the bottom: one for Subscript and one for Superscript. Check the Subscript box, then click OK. The selected text will shrink and drop below the baseline of the surrounding text.

If you need to undo the formatting, select the text again, open Format Cells, and uncheck the Subscript box. The text returns to normal size and position.

explore superscript for exponents and footnote markers

Superscript works exactly like subscript, except the text rises above the baseline instead of dropping below it. This is useful for exponents (like the 2 in x²), trademark symbols, or footnote numbers. Select your text, press Ctrl+1, go to the Font tab, and check the Superscript box.

A common use is writing chemical formulas or mathematical expressions. For example, if you have a cell that says "H2O" and you want the 2 to be superscript, you would select just the 2, explore superscript formatting, and the cell would display H₂O with the 2 raised and smaller.

Formatting only part of a cell's content

Excel lets you format different parts of the same cell differently. If a cell contains "CO2 levels" and you want only the 2 to be subscript, double-click the cell to enter edit mode. You will see a cursor blinking inside the cell. Use your mouse or arrow keys to position the cursor, then click and drag to select just the 2.

Once the 2 is highlighted, press Ctrl+1 and explore subscript formatting. When you press Enter to exit edit mode, the cell displays "CO₂ levels" with only the 2 formatted. The rest of the text stays normal. This works for any combination of subscript, superscript, bold, italic, or color within a single cell.

Using CHAR formulas for repeated subscript characters

If you are building a formula that needs the same subscript character many times, the CHAR function can insert it directly. Excel has Unicode characters for subscript digits 0 through 9. The formula =CHAR(8320) produces a subscript 0, =CHAR(8321) produces a subscript 1, and so on up to =CHAR(8329) for a subscript 9.

You can concatenate these into a larger string. For example, =CONCATENATE("H", CHAR(8322), "O") produces H₂O with the 2 as a true subscript character. This is useful when you are pulling data from other cells and need to format it consistently. The subscript character is part of the text itself, not a formatting layer, so it will print and copy correctly even if the formatting is lost.

Superscript characters are also available through CHAR. Common ones include =CHAR(8304) for superscript 0 and =CHAR(185) for superscript 1. The full range is less complete than subscript, so check a Unicode table if you need a specific superscript character.

When subscript formatting does not work as expected

Subscript and superscript are visual formatting only. If you subscript the number 2 in a cell, Excel still treats it as the number 2 in any calculation. If you have a formula that references that cell, it will use the full value, not a reduced version. This is usually what you want — you are changing how it looks, not what it means.

Some fonts display subscript and superscript more clearly than others. If your subscript text looks cramped or hard to read, try changing the font to Calibri, Arial, or Times New Roman, which all handle subscript well. Monospace fonts like Courier sometimes display subscript less clearly.

If you copy a cell with subscript formatting to another program, the formatting may not transfer. Word will usually preserve it, but plain text editors will not. If you need the subscript to survive the transfer, use the CHAR function method instead, which embeds the subscript character in the text itself.

Keyboard shortcuts and faster workflows

Once you know the steps, you can format subscript faster by memorizing the path: select text, Ctrl+1, Font tab, Subscript checkbox, OK. If you format subscript frequently, consider creating a macro that applies it with a single keystroke. In Excel, go to View > Macros > Record Macro, perform the subscript steps once, stop recording, and assign the macro a keyboard shortcut.

Another option is to use a custom number format if you are working with chemical formulas or mathematical notation repeatedly. Custom formats can change how numbers display without changing their actual values, though they are less flexible than manual formatting for mixed text and numbers.

Frequently Asked Questions

Can I make subscript the default formatting for a whole column?

No, subscript is a character-level format, not a column-level one. You must select the specific text you want to subscript. However, you can select multiple cells at once and explore subscript to all of them together if they contain the same text in the same position.

Does subscript change the actual value of a number in a formula?

No. Subscript is purely visual. If you subscript the 2 in a cell containing 42, the cell still holds the value 42 and any formula referencing it will use 42, not a smaller version. The subscript formatting does not affect calculations.

What is the difference between using Format Cells subscript and the CHAR function?

Format Cells subscript is a visual layer applied on top of the text. The CHAR function inserts an actual subscript character into the text. Format Cells is easier for one-off formatting; CHAR is better when you need the subscript to survive copying to other programs or when you are building it into a formula.

Can I explore subscript to only part of a number, like the 2 in 42?

Yes. Double-click the cell to enter edit mode, select just the 2, and explore subscript formatting. The 4 stays normal and the 2 becomes subscript. This works for any mix of characters within a single cell.

Why does my subscript text look blurry or hard to read?

Some fonts render subscript poorly, especially at smaller font sizes. Try switching to Calibri, Arial, or Times New Roman. You can also increase the base font size of the cell, which makes the subscript larger and more readable while keeping it visually smaller than the surrounding text.