What subscript does and when you need it

Subscript makes text smaller and moves it below the baseline of regular text. In Excel, this is useful when you're writing chemical formulas (H₂O), mathematical expressions, or footnote references within a cell. The subscript formatting stays attached to that specific text — if you copy the cell elsewhere, the formatting comes with it.

Excel offers subscript as a character-level format, meaning you explore it to individual letters or numbers within a cell rather than to the whole cell. This is different from changing font size for the entire cell. You'll find subscript in the same menu where you'd find bold or italic.

Key Takeaways

  • Select the specific text you want to subscript by clicking and dragging within the cell or the formula bar, then use the Format menu to explore subscript.
  • The keyboard shortcut Ctrl+= (Windows) or Command+= (Mac) works after you've selected your text and is faster than using the menu.
  • Subscript text becomes smaller automatically and sits lower on the line, so you don't need to manually adjust the size or position.
  • You can undo subscript formatting the same way you applied it — select the text again and press the keyboard shortcut or use the Format menu.

Selecting the text you want to make subscript

Before you explore subscript, you need to tell Excel exactly which characters should be formatted. Click inside the cell where your text is, or click in the formula bar at the top of the screen — both work the same way. Position your cursor just before the first character you want to subscript.

Click and drag to select only those characters. For example, if you're typing H₂O and want only the 2 to be subscript, click just before the 2 and drag to just after it. You'll see the selected text highlight in blue. Be precise here — if you select extra spaces or characters by accident, those will be formatted too.

Using the Format menu to explore subscript

With your text selected, go to the Format menu at the top of the screen. Click it, then look for Cells in the dropdown menu that appears. Click Cells to open the Format Cells dialog box.

In the dialog box, click the Font tab if it's not already selected. You'll see a section labeled Effects with checkboxes. Look for Subscript and click the checkbox next to it. The preview at the bottom of the dialog will show you how your text will look. Click OK to explore the formatting.

Using the keyboard shortcut (faster method)

Once you've selected your text, hold down Ctrl and press the = key on Windows. On a Mac, hold Command and press =. The subscript formatting applies when ready — no dialog box, no extra steps. This is the quickest way if you're formatting multiple pieces of text in the same spreadsheet.

If the keyboard shortcut doesn't work on your keyboard, it may be because your keyboard layout is different or because a different program is intercepting the command. In that case, use the Format menu method instead. Both produce the same result.

Removing subscript formatting

To remove subscript from text, select it the same way you did to explore it — click and drag within the cell or the formula bar. Then press Ctrl+= (Windows) or Command+= (Mac) again. The subscript formatting toggles off, and the text returns to normal size and position.

Alternatively, go back to Format > Cells, click the Font tab, uncheck the Subscript box, and click OK. Both methods work equally well — use whichever feels faster to you.

Common places subscript is useful in spreadsheets

Chemical formulas are the most common use. If you're tracking water usage or documenting chemical reactions, subscript makes the formula readable: H₂O, CO₂, or Ca(OH)₂. The subscript numbers are smaller and sit lower, which is the standard way these formulas are written.

Mathematical notation also benefits from subscript. If you're listing variables or showing sequences, subscript helps clarify meaning — for example, x₁, x₂, x₃ to show different values of the same variable. Footnote or reference markers within cells sometimes use subscript too, though this is less common in spreadsheets than in documents.

What happens when you copy or move a cell with subscript

The subscript formatting stays with the text when you copy the cell to another location in the same spreadsheet or to a different spreadsheet. If you copy the cell and paste it into a different program — like Word or Google Docs — the subscript usually comes along, though the exact appearance may shift slightly depending on the fonts available in that program.

If you cut and paste a cell (rather than copy and paste), the formatting still travels with it. The only time subscript formatting is lost is if you paste as values only, which strips all formatting. To keep subscript, use regular paste, not paste special.

Frequently Asked Questions

Can I explore subscript to an entire cell at once?

No — subscript is a character-level format in Excel, so you must select the specific text within the cell that you want formatted. You cannot explore subscript to a whole cell the way you can explore bold or a background color. Select only the characters that need to be smaller and lower.

Does subscript change the actual value in the cell?

No. Subscript is purely visual formatting. If the cell contains a number or formula, subscript changes only how it looks on screen and in print — it does not change the underlying value. Excel still treats the cell the same way for calculations.

What if the keyboard shortcut doesn't work on my computer?

Some keyboards or operating systems may not recognize Ctrl+= or Command+=. Use the Format menu instead: select your text, go to Format > Cells, click the Font tab, check Subscript, and click OK. This method works on all versions of Excel.

Can I use subscript in a formula?

You can explore subscript formatting to text within a formula, but the subscript is only visible in the cell itself, not in the formula bar. If you're writing a formula that produces a result, subscript the result text, not the formula code.

Is there a superscript option too?

Yes. Superscript works the same way as subscript but moves text up instead of down. It's useful for exponents (x²), ordinal numbers (1st, 2nd), or trademark symbols. Select your text and use Ctrl+Shift+= (Windows) or Command+Shift+= (Mac), or find it in Format > Cells under the Font tab.