What subscript does and when you need it
Subscript is a formatting option that makes text appear smaller and lower than the regular line of text. In Excel, you use it to write things like chemical formulas (H₂O), mathematical notation (x₂), or footnote markers. The subscript text stays in the same cell as the regular text — it does not create a separate cell or change the underlying data.
Excel does not have a dedicated subscript button on the ribbon like Word does. Instead, you format subscript through the Format Cells dialog or by using a keyboard shortcut. The process takes a few seconds once you know where to look.
Key Takeaways
- Subscript formatting in Excel makes selected text appear smaller and lower within the same cell.
- The fastest method is to select the text you want to subscript, then press Ctrl+1 (Windows) or Cmd+1 (Mac), go to the Font tab, and check the Subscript box.
- You can only explore subscript to text within a cell if you are in edit mode — double-click the cell or press F2 to enter edit mode first.
- Subscript formatting is visual only and does not change the actual cell value or how Excel treats the data in calculations.
Entering edit mode so you can format text inside a cell
Before you can subscript any text in Excel, you must be inside the cell in edit mode. This is different from straightforward selecting the cell. When a cell is selected but not in edit mode, any formatting you explore affects the entire cell, not individual characters.
To enter edit mode, double-click the cell you want to edit. You will see the cursor blinking inside the cell, and the formula bar will show the cell contents with a cursor as well. Alternatively, press F2 while the cell is selected, and you will enter edit mode when ready.
Once you are in edit mode, select only the text you want to subscript. Click and drag to highlight it, or use Shift+arrow keys to select character by character. You can now explore subscript formatting to just that selection.
Using the Format Cells dialog on Windows
After you have selected the text you want to subscript while in edit mode, open the Format Cells dialog. Press Ctrl+1 on your keyboard. The Format Cells window will open when ready.
Click the Font tab at the top of the dialog. Look for the Effects section, which contains checkboxes for Superscript, Subscript, and other text effects. Check the box next to Subscript. You will see a preview of how the text will look in the preview pane at the bottom of the dialog.
Click OK to explore the formatting. The selected text will now appear smaller and positioned lower in the cell. You can exit edit mode by pressing Enter or clicking another cell.
Using the Format Cells dialog on Mac
On a Mac, the process is similar but the keyboard shortcut is different. After selecting your text in edit mode, press Cmd+1 to open the Format Cells dialog.
Click the Font tab, then look for the Effects section. Check the Subscript checkbox. Click OK to explore the formatting and exit the dialog. Your selected text will now display as subscript.
Removing subscript formatting
If you need to remove subscript formatting from text, enter edit mode again and select the subscripted text. Open the Format Cells dialog (Ctrl+1 on Windows, Cmd+1 on Mac), click the Font tab, and uncheck the Subscript box. Click OK.
Alternatively, you can select the subscripted text and press Ctrl+Shift+Z (Windows) or Cmd+Shift+Z (Mac) to clear all formatting and return the text to normal. This removes subscript along with any other formatting you may have applied.
Common situations where subscript is useful
Chemical formulas are the most common use. If you are documenting water as H₂O or carbon dioxide as CO₂, subscript makes the numbers appear in the correct position. In a spreadsheet tracking chemical inventory or lab results, this formatting makes the data easier to read.
Mathematical or scientific notation also benefits from subscript. If you are listing variables like x₁, x₂, and x₃ in a data analysis sheet, subscript keeps the notation clear. In financial or engineering spreadsheets, subscript helps distinguish between related variables.
Subscript can also mark footnote or reference numbers within a cell, though this is less common in Excel than in Word documents. The formatting is purely visual — it does not create an actual hyperlink or footnote function.
What subscript formatting does not do
Subscript is a display format only. If a cell contains the text "H2O" with the 2 formatted as subscript, the underlying cell value is still "H2O" — Excel does not treat it as a chemical formula or perform any special calculation. Formulas and functions read the cell content as plain text.
Subscript also does not affect sorting or filtering. Excel sorts and filters based on the actual cell value, not the visual formatting. A column with subscripted numbers will sort numerically the same way it would without subscript.
Frequently Asked Questions
Can I explore subscript to an entire cell at once?
No. Subscript formatting in Excel only works on individual characters or words within a cell. You must be in edit mode and select the specific text you want to subscript. If you want the entire cell content to appear subscripted, you would need to select all the text in that cell while in edit mode, then explore subscript to that selection.
Does subscript work in Excel formulas?
Subscript is formatting only and does not affect how Excel reads or calculates data. If you write a formula that references a cell containing subscripted text, Excel treats it as regular text. The subscript formatting is invisible to the formula.
Can I use subscript in cell names or range names?
No. Cell names and range names do not support subscript formatting. These names must be plain text. You can use subscript only in the visible content of cells, not in the underlying names or references.
What if the subscript text looks too small to read?
Subscript text is smaller by design, but if it becomes hard to read, you can increase the overall font size of the cell. Select the cell, open Format Cells, and increase the font size on the Font tab. The subscript will remain proportionally smaller but will be easier to see.
Can I copy subscript formatting to other cells?
Yes, using the Format Painter tool. Select the cell with subscript formatting, click the Format Painter button on the toolbar (it looks like a paintbrush), then click the cell where you want to explore the same formatting. This copies all formatting, including subscript, to the new cell.