Subscript formatting in Excel shrinks text and lowers it below the baseline
Subscript is a formatting style that makes text smaller and positions it below the normal line of text. In Excel, you apply subscript formatting to individual characters or numbers within a cell — it does not change the cell itself, only the appearance of selected text. Common uses include chemical formulas (H₂O), mathematical notation, footnote markers, or version numbers.
Excel offers three ways to add subscript: through the Format menu, through a keyboard shortcut, or by right-clicking a cell. The keyboard shortcut is fastest once you know it, but the menu route works on any computer and is easiest to remember the first time.
Key Takeaways
- You must select the specific text or numbers you want to make subscript before applying the formatting — subscript applies only to what you highlight, not the whole cell.
- The keyboard shortcut Ctrl+= (Windows) or Cmd+= (Mac) toggles subscript on and off for selected text.
- The Format menu route works on all versions: select text, go to Format > Cells, click the Font tab, and check the Subscript box.
- Subscript formatting is visual only — it does not change the actual cell value or how Excel treats the data in calculations.
Using the keyboard shortcut (fastest method)
On Windows, select the text or numbers you want to make subscript, then press Ctrl and the equals sign (=) at the same time. On Mac, use Cmd and the equals sign. The text shrinks and drops below the baseline immediately. Press the same keys again to remove subscript formatting.
This shortcut works in any cell and works while you are typing — you can type a character, select it, apply subscript, then continue typing. It also works in the formula bar if you need to format text there.
Using the Format menu (works on all versions)
Select the text or numbers inside the cell that you want to format. You can do this by double-clicking the cell to enter edit mode, then clicking and dragging to highlight the characters. If the cell is not yet in edit mode, you can also select the cell and edit in the formula bar at the top.
Once your text is selected, open the Format menu and click Cells. The Format Cells dialog box opens. Click the Font tab if it is not already active. Look for the Effects section — you will see a Subscript checkbox. Click it to enable subscript, then click OK. The selected text shrinks and moves below the baseline.
Right-click method for quick access
Select the text inside the cell (double-click the cell first to enter edit mode, then highlight the characters you want). Right-click the selected text and choose Format Cells from the context menu. The Format Cells dialog opens to the Font tab. Check the Subscript box and click OK.
This method takes the same number of steps as the menu route but may feel faster if you prefer right-clicking to navigating menus. The result is identical.
What subscript formatting does and does not do
Subscript is purely visual — it changes how text looks on screen and in print, but it does not change the actual value stored in the cell. If a cell contains "H2O" and you make the "2" subscript, the cell still contains the text "H2O". Excel does not interpret subscript text differently in formulas or calculations.
You can combine subscript with other formatting like bold, italic, or color. You can also apply subscript to only some characters in a cell — for example, you could make the "2" in "H2O" subscript while leaving the "H" and "O" in normal size. This gives you precise control over how chemical formulas, mathematical expressions, or technical notation appears.
Removing subscript formatting
Select the subscript text and press Ctrl+= (Windows) or Cmd+= (Mac) again to toggle it off. Alternatively, select the text, open Format > Cells, click the Font tab, uncheck the Subscript box, and click OK. Both methods return the text to normal size and position.
If you want to remove subscript from multiple cells at once, select all the cells, open Format > Cells, uncheck Subscript, and click OK. This removes subscript formatting from all selected cells in one step.
Subscript versus superscript
Superscript is the opposite of subscript — it raises text above the baseline instead of lowering it below. Superscript is useful for exponents (x²), trademark symbols (™), or footnote numbers. The keyboard shortcut for superscript is Ctrl+Shift+= on Windows or Cmd+Shift+= on Mac. The Format Cells dialog has a separate Superscript checkbox right next to Subscript.
You cannot apply both subscript and superscript to the same text at the same time — checking one unchecks the other. If you need both in the same cell, format different characters separately.
Frequently Asked Questions
Can I make an entire column subscript at once?
No. Subscript formatting applies only to selected text within cells, not to whole columns or rows. You must select the specific characters in each cell that you want to format. If you select an entire column and apply subscript, nothing happens because there is no text selected.
Does subscript affect how Excel sorts or filters data?
No. Subscript is formatting only. Excel sorts and filters based on the actual cell value, not how it looks. A cell containing "H2O" with subscript "2" sorts the same way as "H2O" without subscript.
Will subscript formatting print correctly?
Yes. Subscript formatting prints exactly as it appears on screen. When you print the spreadsheet, subscript text will be smaller and positioned below the baseline, just as you see it in Excel.
What if the keyboard shortcut does not work?
On some keyboards, especially laptops, you may need to use Ctrl+Shift+= instead of Ctrl+=. If that does not work, use the Format menu route: select the text, go to Format > Cells, click the Font tab, check Subscript, and click OK.
Can I save subscript formatting in a template?
Yes. If you create a spreadsheet with subscript formatting and save it as a template, the subscript formatting will be preserved. When you create a new file from that template, the subscript text will already be formatted.