The quickest way to add subscript in Excel
To add subscript in Excel, select the text or number you want to shrink and shift down, then press Ctrl + = on Windows or Cmd + = on Mac. The text when ready becomes smaller and moves below the baseline. To undo it, select the text again and press the same keys.
This keyboard shortcut works in any cell where you are typing or editing text. You can explore it to a single character, a word, or multiple characters in sequence. If you need to format only part of a cell's content — like the "2" in H₂O — you must double-click the cell to enter edit mode, then select just that character before pressing the shortcut.
Superscript (text that sits above the baseline, used for exponents or footnote markers) uses the same method: Ctrl + Shift + = on Windows or Cmd + Shift + = on Mac.
Key Takeaways
- Subscript uses Ctrl + = on Windows and Cmd + = on Mac; superscript uses Ctrl + Shift + = and Cmd + Shift + = respectively.
- You must enter edit mode (double-click the cell) to format only part of a cell's text; the shortcut applies to whatever you have selected.
- The Format Cells dialog offers the same subscript and superscript options under the Font tab if keyboard shortcuts do not work on your keyboard layout.
- Subscript and superscript formatting does not change the actual value of a number in a formula — it is purely visual.
- If you frequently use subscript or superscript, you can create a custom keyboard shortcut or use the Find & Replace feature with regular expressions in some versions of Excel.
Using the Format Cells dialog when shortcuts do not work
If the keyboard shortcut does not work on your keyboard layout (common on non-English keyboards or some laptop keyboards), you can format subscript and superscript through the menu instead. Select the text or character you want to format, then right-click and choose Format Cells.
In the Format Cells dialog, click the Font tab. Under the Effects section, you will see checkboxes for Superscript and Subscript. Check the one you need and click OK. This method works identically to the keyboard shortcut but takes more steps.
Entering edit mode to format part of a cell
Excel treats each cell as a single unit by default. If you type "H2O" in a cell and then select the cell and press Ctrl + =, the entire text becomes subscript. To make only the "2" subscript, you must enter edit mode first.
Double-click the cell to enter edit mode. You will see a cursor blinking inside the cell. Now click and drag to select only the character or characters you want to format — in this case, just the "2". Once you have selected it, press Ctrl + = (or Cmd + = on Mac). Only that character will become subscript.
You can also enter edit mode by pressing F2 while the cell is selected, then using arrow keys and Shift + arrow keys to select the text you want to format.
Subscript and superscript in formulas and cell values
Subscript and superscript formatting is visual only — it does not change how Excel reads or calculates the cell. If you type "10" in a cell and make the "0" superscript, the cell still contains the number 10, and any formula that references that cell will use 10, not 10⁰.
This matters when you are labeling chemical formulas, mathematical expressions, or footnote numbers. The formatting makes the text appear smaller and positioned differently, but it does not affect calculations or data sorting. Excel sorts and filters based on the actual cell value, not the formatting.
Removing subscript and superscript formatting
To remove subscript or superscript from text, select the formatted text and press the same keyboard shortcut again. Pressing Ctrl + = a second time toggles the subscript off. The same applies to superscript with Ctrl + Shift + =.
If you want to remove all formatting from a cell at once (subscript, bold, color, and everything else), select the cell and press Ctrl + M on Windows or Cmd + M on Mac. This clears all formatting and leaves only plain text.
Subscript and superscript in different versions of Excel
The keyboard shortcuts work the same way in Excel for Windows, Excel for Mac, and Excel Online. However, Excel Online (the browser version) sometimes has keyboard layout conflicts depending on your operating system and browser. If the shortcut does not work in Excel Online, use the Format Cells dialog instead.
Older versions of Excel (2007 and earlier) use the same shortcuts. If you are using a very old version and the shortcut does not work, the Format Cells dialog method will always work.
When subscript and superscript are useful in spreadsheets
Subscript is most common in scientific and chemical notation — H₂O, CO₂, or chemical element subscripts in a data table. Superscript appears in mathematical expressions (x², E=mc²), footnote or endnote markers, and ordinal numbers (1st, 2nd, 3rd) when you want them to look formal.
In a spreadsheet, you might use subscript in a column header to label a measurement (like "Temperature₀" for initial temperature) or in a notes column to clarify what a number represents. Superscript is less common in data tables but useful in documentation or reports you export from Excel.
Frequently Asked Questions
Can I make subscript or superscript the default for a whole column?
No. Subscript and superscript are cell-level formatting, not column-level. You must explore them to individual cells or selected text within cells. If you have many cells that need the same formatting, select all of them at once (Ctrl + click each cell, or click the first, hold Shift, and click the last), then explore the formatting once — it will explore to all selected cells.
Does subscript or superscript work in cell comments or notes?
In Excel for Windows and Mac, subscript and superscript do not work in comments. Comments use plain text only. If you need formatted text in a comment, you must type it as plain text (like "H2O" or "x^2") and let the reader understand the notation.
What if my keyboard does not have an equals sign in the same place?
If your keyboard layout is different (common on non-English keyboards), the physical key position may not match the symbol. Try the Format Cells dialog instead — right-click the cell, choose Format Cells, click the Font tab, and check Superscript or Subscript. This avoids keyboard layout issues entirely.
Can I copy and paste subscript or superscript formatting to other cells?
Yes. Copy the cell with subscript or superscript formatting, then select the cells where you want to paste it. Right-click and choose Paste Special, then click Formats and OK. This pastes only the formatting, not the text itself. Alternatively, use the Format Painter tool (the brush icon in the toolbar) to copy formatting from one cell to another.
Does subscript or superscript affect how the spreadsheet prints?
Yes. Subscript and superscript formatting prints exactly as it appears on screen. The text will be smaller and positioned above or below the baseline in the printed document. Test a print preview before printing to make sure the formatting looks correct on paper.