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 within a cell — not to entire cells or columns. The most direct method is to select the characters you want to format, then use the Format Cells dialog or a keyboard shortcut to apply the subscript effect.
Subscript is useful when you need to write chemical formulas (H₂O), mathematical notation (x₂), or footnote references within a cell. Excel does not have a subscript button on the main toolbar, so you will need to use either the Format menu or a keyboard combination. Unlike some word processors, Excel treats subscript as a character-level format that you must apply manually to each piece of text that needs it.
Key Takeaways
- Select only the specific characters you want to subscript before applying the formatting — subscript applies to your selection, not the whole cell.
- The keyboard shortcut Ctrl+= (Windows) or Command+= (Mac) toggles subscript on and off for selected text.
- You can also reach subscript through Format > Cells > Font tab > Effects section, then check the Subscript box.
- Subscript formatting is visual only and 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 characters you want to subscript, then press Ctrl+= (Ctrl and the equals sign). On Mac, use Command+= (Command and the equals sign). The text will immediately shrink and drop below the baseline. Press the same combination again to remove subscript formatting.
This method works in any version of Excel and is faster than opening a menu. The shortcut toggles subscript on and off, so if you accidentally subscript the wrong characters, select them again and press the shortcut to undo it. You do not need to open any dialog or navigate through menus — the change happens instantly in the cell.
Using the Format Cells dialog
Select the characters you want to subscript. Right-click and choose Format Cells, or go to the Format menu and select Cells. In the dialog box, click the Font tab. Under the Effects section, check the box next to Subscript, then click OK.
This method is useful if you prefer using menus or if the keyboard shortcut is not working on your device. The dialog also shows you a preview of how the text will look before you apply the change. On some keyboards, particularly laptops or international layouts, the Ctrl+= shortcut may not register properly, making the menu route more reliable.
Subscript does not change the cell value or calculations
Subscript is purely a display format. If you type "H2O" in a cell and subscript only the "2", the cell still contains the text "H2O" — Excel does not interpret the subscript formatting as part of a formula or calculation. If another cell references this cell, it will see the full text, not just the visible characters.
This means subscript is safe to use for labels, chemical formulas, or any text where you want visual clarity without affecting how Excel processes the data. The underlying value remains unchanged, so sorting, filtering, and searching will all work based on the actual text content, not the formatting.
Subscript in formulas and functions
You cannot apply subscript formatting inside a formula itself. If you write =A1+A2 in a cell, you cannot subscript the "1" or "2" in the formula. However, you can subscript text in a cell that contains a formula result if you format the cell after the formula calculates.
For example, if a cell contains a formula that produces the text "H2O", you can select just the "2" and apply subscript formatting to make it display as "H₂O". The formula continues to work normally behind the scenes. This approach works well when you are using formulas to generate labels or text output that you want to format for readability.
Combining subscript with other formatting
You can apply subscript together with bold, italic, color, or font changes. Select your text, apply subscript using either the keyboard shortcut or the Format Cells dialog, then apply additional formatting as needed. Excel will layer these formats together.
For instance, you might make a subscript character red to draw attention to it, or bold a subscript number in a chemical formula. Each format is independent, so you can remove one without affecting the others. This flexibility allows you to create visually distinct text for different purposes within the same spreadsheet.
Frequently Asked Questions
Can I subscript an entire column or row at once?
No. Subscript applies only to individual characters within cells. If you select an entire column or row and apply subscript, nothing will happen. You must select the specific text inside each cell that you want to subscript.
What is the difference between subscript and superscript?
Subscript lowers text below the baseline (like H₂O). Superscript raises text above the baseline (like x²). In Excel, superscript uses the keyboard shortcut Ctrl+Shift+= on Windows or Command+Shift+= on Mac. Both are applied the same way — by selecting characters and using a keyboard shortcut or the Format Cells dialog.
Will subscript formatting copy to other programs?
If you copy a cell with subscript formatting and paste it into Word or another program, the subscript formatting usually transfers. However, if you paste as plain text or into a program that does not support formatting, the subscript effect will be lost and the text will appear normal.
Can I undo subscript formatting?
Yes. Select the subscript text and press Ctrl+= (Windows) or Command+= (Mac) again to toggle it off. You can also select the text, open Format Cells, and uncheck the Subscript box.
Does subscript work in Excel on mobile devices?
Excel for mobile (iOS and Android) has limited formatting options. The keyboard shortcut may not work, and the Format Cells dialog may not include the Subscript option. For full subscript support, use Excel on a desktop or laptop computer.