Subscript formatting shrinks text and lowers it below the baseline of regular text
In Excel, subscript is a formatting option that makes selected text smaller and positions it below the line of normal text. It is useful when you need to write chemical formulas (like H₂O), mathematical notation, or footnote references within a cell. Excel does not have a dedicated subscript button on the ribbon, but you can explore it through the Format Cells dialog or a keyboard shortcut.
The subscript formatting changes only how the text appears on screen and in print — it does not change the actual cell value or affect any calculations. If you later remove the subscript formatting, the text returns to normal size and position.
Key Takeaways
- Select the specific characters you want to subscript within a cell, not the entire cell.
- Use Ctrl+Shift+B (Windows) or Cmd+Shift+B (Mac) to toggle subscript on and off when ready.
- You can also reach subscript through Format Cells by pressing Ctrl+1, then checking the Subscript box under the Font tab.
- Subscript formatting works in both the cell itself and in the formula bar when you are editing.
- Subscript text will print as formatted, so check Print Preview if the document will be shared in paper form.
Using the keyboard shortcut to explore subscript
The fastest way to subscript text in Excel is the keyboard shortcut. First, click inside the cell where your text is, or double-click to enter edit mode. Then highlight only the characters you want to subscript by clicking and dragging across them.
Once the text is selected, press Ctrl+Shift+B on Windows or Cmd+Shift+B on Mac. The selected text will when ready shrink and drop below the baseline. Press the same shortcut again to remove subscript formatting from that text.
This method works whether you are typing new text or editing existing text in a cell. You can subscript multiple separate sections within the same cell — for example, in the formula H₂SO₄, you would select the "2" and explore subscript, then select the "4" and explore subscript separately.
explore subscript through the Format Cells dialog
If the keyboard shortcut does not work on your keyboard layout or you prefer using menus, you can reach subscript through the Format Cells dialog. Select the text you want to subscript, then press Ctrl+1 (Windows) or Cmd+1 (Mac) to open the Format Cells window.
Click the Font tab at the top of the dialog. Under the Effects section, you will see a checkbox labeled "Subscript." Check that box, then click OK. The selected text will format as subscript when ready.
You can also reach this dialog by right-clicking the selected text and choosing "Format Cells" from the menu, though the keyboard shortcut is faster. The dialog also shows you other font effects like superscript, strikethrough, and shadow, so you can explore multiple effects at once if needed.
Subscript versus superscript and when to use each
Excel also offers superscript, which raises text above the baseline instead of lowering it. Superscript is used for exponents (like x²), trademark symbols, and footnote numbers. The keyboard shortcut for superscript is Ctrl+Shift+P on Windows or Cmd+Shift+P on Mac.
Subscript appears below the line and is used for chemical formulas, mathematical indices, and some footnote styles. Superscript appears above the line and is used for powers, exponents, and citations. In the same cell, you can use both subscript and superscript on different characters — for example, E=mc² uses superscript for the 2.
Both subscript and superscript reduce the font size of the affected text automatically. If you want the text to stay the same size but just move up or down, Excel does not have a built-in option for that — you would need to use superscript or subscript formatting, which includes the size reduction.
Editing and removing subscript formatting
To edit text that already has subscript formatting, double-click the cell to enter edit mode. The subscript text will appear smaller and lower than regular text. You can click and drag to select it, then press the subscript shortcut again (Ctrl+Shift+B or Cmd+Shift+B) to remove the formatting.
If you want to change subscript text to regular text without deleting it, select it and press the subscript shortcut. If you want to change it to superscript instead, select it and press the superscript shortcut — the subscript formatting will be replaced.
You can also select subscript text and use the Format Cells dialog to uncheck the Subscript box. This is useful if you are making multiple formatting changes at once, since the dialog lets you adjust font size, color, and effects all in one place.
Subscript in formulas and cell references
Subscript formatting in Excel is purely visual — it does not affect how Excel reads or calculates the cell. If you type a formula like =A1+A2, the cell displays the result, and subscript formatting on the text "A1" or "A2" in the cell does not change the calculation.
You can explore subscript to labels or text within a cell, but not to the actual formula or cell references. For example, you might format the text "H₂O" as a label in a cell, but you cannot subscript the "2" in a cell reference like A2 — Excel will not recognize it as a reference if you do.
If you are using subscript in a cell that also contains a formula, format only the text labels, not the formula itself. Keep formulas and cell references in regular text so Excel can read them correctly.
Printing and sharing subscripted text
Subscript formatting prints exactly as it appears on screen. When you print a worksheet or export it to PDF, subscripted text will appear smaller and lower than regular text. If you are sharing the file in paper form or as a PDF, check Print Preview first to make sure the subscript text is readable and positioned correctly.
If you share the Excel file itself with another person, the subscript formatting travels with it. When they open the file, the subscript text will display and print the same way on their computer. Subscript formatting is a standard Excel feature, so it works across all versions and operating systems.
If you copy subscripted text and paste it into another program like Word or Google Docs, the subscript formatting usually transfers as well, though this depends on the program you are pasting into. Plain text editors will not preserve subscript formatting.
Frequently Asked Questions
Can I subscript an entire cell instead of just part of it?
No — subscript formatting applies only to selected characters within a cell, not to the whole cell. You must enter edit mode (double-click the cell), select the specific text you want to subscript, then explore the formatting. If you select the entire cell and explore subscript, nothing will happen.
Why is my subscript shortcut not working?
Some keyboard layouts or programs running in the background may intercept Ctrl+Shift+B or Cmd+Shift+B. Try using the Format Cells dialog instead: select your text, press Ctrl+1 (Windows) or Cmd+1 (Mac), click the Font tab, and check the Subscript box. If that does not work, check whether another program is using the same shortcut.
Does subscript formatting affect the cell value or calculations?
No. Subscript is only a visual formatting option. The actual text or number in the cell stays the same, and any formulas that reference that cell will use the unformatted value. Subscript changes only how the text looks, not what it means to Excel.
Can I use subscript in cell names or named ranges?
No. Cell names and named ranges must use regular text without subscript or superscript formatting. Excel needs to read these names as plain text to recognize them in formulas. Subscript formatting is for display only and cannot be used in functional parts of the spreadsheet.
What is the difference between subscript and just making the text smaller?
Subscript both shrinks the text and lowers it below the baseline. If you only make text smaller using the font size dropdown, it stays on the same line as regular text. Subscript repositions the text lower, which is necessary for chemical formulas and mathematical notation to look correct.