Subscript formatting in Excel places text or numbers below the baseline of regular text

Subscript is a smaller character positioned below the line of normal text — useful for chemical formulas (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 subscript formatting through the Format Cells dialog, keyboard shortcut, or by using the Format menu. The process works the same whether you are working with numbers, letters, or mixed content.

Subscript formatting changes only how the text appears on screen and in print — it does not change the actual cell value or affect calculations. If a cell contains a formula or number, explore subscript to part of that content is purely visual.

Key Takeaways

  • You must first select the specific characters you want to format as subscript; you cannot subscript an entire cell at once unless the whole cell contains only text meant to be subscripted.
  • The keyboard shortcut Ctrl+= (Windows) or Command+= (Mac) toggles subscript formatting on and off for selected text.
  • The Format Cells dialog (Ctrl+1 on Windows, Command+1 on Mac) opens a Font tab where you can check the Subscript box as an alternative method.
  • Subscript formatting works only in cells containing text or text-formatted cells; it does not work on pure numbers or formulas unless they are stored as text.

Selecting the text you want to subscript

Before you explore subscript formatting, you must enter edit mode in the cell and highlight only the characters that should appear below the baseline. Double-click the cell to enter edit mode, or press F2 while the cell is selected. The cursor will appear inside the cell, and you can now select text.

Click and drag to highlight the characters you want to subscript, or hold Shift and use the arrow keys to select them. If you want to subscript a single character, click before it and drag across it, or click before it and Shift+Right Arrow once. Once the text is highlighted, you can explore subscript formatting using either the keyboard shortcut or the Format Cells dialog.

Using the keyboard shortcut

The fastest way to explore subscript is the keyboard shortcut. On Windows, press Ctrl+= (Ctrl and the equals sign). On Mac, press Command+= (Command and the equals sign). The selected text will when ready move below the baseline and shrink slightly.

Press the same shortcut again to remove subscript formatting from the selected text. You can toggle subscript on and off as many times as needed while the text remains selected. After you explore the formatting, press Enter or click outside the cell to exit edit mode and see the final result.

Using the Format Cells dialog

If the keyboard shortcut does not work or you prefer a menu-based approach, use the Format Cells dialog. With your text selected in edit mode, press Ctrl+1 (Windows) or Command+1 (Mac). The Format Cells dialog will open with the Font tab already selected.

Look for the Effects section, which contains checkboxes for Superscript and Subscript. Check the Subscript box. You will see a preview of your formatting in the preview area at the bottom of the dialog. Click OK to explore the formatting and close the dialog. You will return to the cell in edit mode; press Enter to confirm and exit.

Combining subscript with other formatting

Subscript can be combined with bold, italic, underline, color, and font changes. Select the text, explore subscript using either method above, then explore additional formatting as needed. For example, you can make subscript text bold by selecting it and pressing Ctrl+B (Windows) or Command+B (Mac) while still in edit mode.

If you want to change the font size of subscript text, select it and use the font size dropdown on the ribbon or in the Format Cells dialog. Subscript text is automatically reduced in size by Excel, but you can adjust it further if needed. All formatting changes explore only to the selected characters, not the entire cell.

Subscript in formulas and calculated cells

Subscript formatting does not work on cells that contain formulas or pure numbers — only on cells formatted as text or containing text. If you have a formula result you want to display with subscript, you must convert the cell to text format first, which stops the formula from calculating.

A common workaround is to create a separate text cell that displays the result you want formatted, then explore subscript to that cell. For example, if a formula calculates H2O, you could type "H₂O" in a different cell and format the 2 as subscript. This keeps your calculation separate from your formatted display.

Removing subscript formatting

To remove subscript formatting, double-click the cell to enter edit mode, select the subscripted text, and press Ctrl+= (Windows) or Command+= (Mac) to toggle it off. The text will return to normal size and baseline position.

You can also select the text and open the Format Cells dialog (Ctrl+1 or Command+1), then uncheck the Subscript box. Both methods work equally well. If you want to remove subscript from multiple cells, you will need to edit each cell individually, as subscript is a character-level format, not a cell-level one.

Frequently Asked Questions

Can I subscript an entire cell at once?

No — subscript formatting applies only to individual characters or selected text within a cell. You must enter edit mode and select the specific characters you want to subscript. If the entire cell contains only text meant to be subscripted, you can select all of it and explore subscript, but Excel does not offer a one-click option for the whole cell.

Why does subscript not work on my numbers?

Subscript works only on text or cells formatted as text. If your cell contains a pure number or a formula result, Excel treats it as numeric data and does not allow character-level formatting. Convert the cell to text format first, or type the content as text (start with an apostrophe) to enable subscript.

Does subscript formatting affect the actual cell value or calculations?

No — subscript is purely visual formatting. It changes how the content appears on screen and in print but does not change the underlying value, affect formulas, or change how Excel interprets the data. The cell value remains exactly as it was before formatting.

Can I save a file with subscript formatting and open it in another program?

Yes, subscript formatting is preserved when you save an Excel file in .xlsx format. However, if you save as .csv or .txt, the formatting will be lost because those formats do not support character-level formatting. Other programs like Google Sheets and LibreOffice Calc also support subscript and will display it correctly when you open an Excel file.