To add subscript in Excel for Microsoft 365 on Windows, select the cell or the characters you want to lower, press Ctrl+1, choose the Font tab, check Subscript under Effects, and select OK. Use this character formatting for labels such as H₂O or x₁; it changes how text looks, not the value or calculation in a cell.
Apply subscript to an entire cell
If all the text in a cell should appear as subscript, format the cell directly. The quickest route is the Format Cells dialog:
- Select the cell or range of cells containing the text.
- Press
Ctrl+1to open Format Cells. - Open the Font tab.
- Under Effects, select Subscript, then choose OK.
You can also open the dialog from the ribbon: go to Home, find the Font group, and select its small dialog box launcher in the lower-right corner. The Font tab contains the same Subscript option. Excel does not put a dedicated Subscript button in the standard Home ribbon, so the Format Cells dialog is the usual built-in method.
For example, typing H2O in a cell and applying Subscript to the whole cell lowers the H, 2, and O together. That is not the usual chemical notation: only the 2 should be lowered. To format just part of the entry, edit the cell and select only the relevant character, as described below.
Subscript only selected characters
Excel can apply font effects to only part of a text entry. This is useful for chemical formulas, footnote markers, and labels that combine ordinary text with a lowered character. Start editing the cell, select the specific character or characters, and then apply the Subscript effect in Format Cells.
- Double-click the cell, or select it and press
F2, to edit its contents. - Select only the character you want to lower. You can also click in the formula bar and select the character there.
- Press
Ctrl+1, open the Font tab, and check Subscript under Effects. - Choose OK, then confirm the edit by pressing
Enterif Excel is still in edit mode.
For H2O, select just the 2 before applying the effect; H and O remain on the normal baseline. For CO2, format the 2 in the same way. In a notation such as x1, format the 1 to produce the appearance of x₁. The cell still contains the same letters and digits as before; only the selected character’s display formatting changes.
If selecting text is awkward, widen the formula bar or click its text and use the mouse to highlight the character. Avoid selecting the cell’s border or moving the insertion point without highlighting anything: in that case, Excel may apply the effect to the whole cell text rather than just the intended character.
What subscript formatting changes
Subscript is a font effect. Excel displays the affected character lower than the baseline and typically smaller than surrounding text. It does not add a new value, insert a special calculation, or change the cell’s underlying characters. If a cell contains the text H2O, formatting its 2 does not turn the entry into a different chemical formula in the workbook’s data.
This distinction matters when working with numbers and formulas. Subscript is primarily a visual treatment for text. It is not a way to change the meaning of a number, alter an operator, or make a formula calculate differently. Excel’s formulas return values; they do not normally produce a result in which only one character has a separately applied font effect. If a formula returns text such as CO2, the returned string can be displayed, but Excel does not automatically apply subscript to just the 2 based on the formula’s result.
Cell-level formatting is also separate from the cell’s number format. Number formats control how numerical values are displayed—for example, as dates, percentages, or currency—while Subscript is a font effect. It is not a substitute for a custom number format or a feature for building mathematical notation that must remain machine-readable.
Examples for labels and notation
Subscript is most useful when the lowered character communicates a label or convention rather than changing a calculation. Common examples include:
- Chemical notation: lower the 2 in H2O or CO2. For more complex formulas, select and format each subscript character or group separately.
- Indexed variables: use x1, y2, or a similar label when a report distinguishes one variable from another.
- Footnote-style markers: lower a number or letter placed after a word, provided the marker is only a visual reference and not part of the cell’s data structure.
- Technical labels: format a character in an equipment code or scientific label when the document’s notation requires a lowered baseline.
For a table of measurements, keep the numerical measurement in its own cell and use a separate, clearly formatted label if readers need to see scientific notation. For instance, a cell storing a measured value should remain a number if it will be averaged or charted. A neighbouring text label can carry the notation. This separation prevents a visual formatting choice from being mistaken for a data transformation.
Subscript formatting versus Unicode characters
There are two ways to make a character look lowered: apply Excel’s Subscript font effect to ordinary text, or replace a character with a Unicode subscript character. They can look similar, but they are not the same in the workbook.
With font formatting, the entry remains ordinary text—for example, the characters H, 2, and O—with the 2 marked for subscript display. With Unicode, the 2 is replaced by a distinct character such as ₂, so the entry itself contains H, ₂, and O. Unicode includes subscript digits such as ₀, ₁, ₂, and ₃, as well as some other subscript symbols. Its set of letter characters is limited, and the appearance can vary with the font or software used to open the file.
- Use font formatting when you want ordinary text to remain editable and want the formatting to be controlled in Excel.
- Use Unicode when the exact lowered character should travel as part of the text, such as in a plain-text label or a system that does not preserve Excel formatting.
- Check compatibility if sharing Unicode characters with older systems, databases, or applications, since search, sorting, or font support may differ.
Copying a formatted cell into a format that strips styling, such as plain text, may remove Excel’s font effect. A Unicode subscript character is part of the text and is more likely to remain visually lowered in plain-text transfer, but it can behave differently from an ordinary digit during searching or data matching.
Limitations and common problems
A frequent surprise is that a whole cell becomes subscript when only one character was intended. This usually means Excel was not in text-editing mode or the character itself was not selected. Edit the cell first, highlight the precise character, and then open Format Cells. If the selection is still unclear, undo the formatting with Ctrl+Z and try again.
Another limitation is that Excel does not provide a dedicated default keyboard shortcut that immediately toggles Subscript in the way some word processors do. Ctrl+1 opens Format Cells, but you still need to select the Font tab and check the effect. A reliable dialog workflow is preferable to relying on an assumed shortcut that may belong to a different application.
Subscript may also be hard to read in small cells or at low zoom. The lowered glyph is smaller and closer to the bottom of the line, so check the worksheet at its intended viewing size and print scale. If the character is clipped, adjust the row height or font size, or use a clearer label layout. Avoid shrinking surrounding text unnecessarily just to make the subscript fit.
Finally, a formula-generated string does not gain character-by-character formatting simply because the formula joins text and digits. If a formula builds a label, its result is still formula output. For a static heading, you can type or paste the text and format selected characters manually. For a changing, formula-driven label, consider using a Unicode subscript character where appropriate, or keep the label and calculated value separate.
Windows, Mac, and Excel for the web
These steps are for Excel for Microsoft 365 on Windows. On Windows, Ctrl+1 opens Format Cells. On a Mac, use Command+1 to open the formatting dialog, then look for the Font tab and the Subscript effect. If a Mac keyboard requires function-key mode for editing a cell, double-clicking the cell is an alternative to using F2.
Excel for the web can display formatting applied in the desktop app, but its browser interface does not provide the same dependable character-level Effects workflow in every editing context. If you cannot find Subscript or cannot select part of the text for formatting, choose Open in Desktop App and apply the effect there. The workbook’s saved formatting can then be viewed again in the browser.
When sharing with other spreadsheet programs, remember that font effects are presentation formatting and may not be preserved in every export. A CSV file stores plain text values rather than Excel’s rich character formatting. If the lowered form must survive as plain text, use an appropriate Unicode character or provide a separate explanatory label, while checking that the receiving system supports it.
Frequently Asked Questions
Is there a keyboard shortcut for subscript in Excel?
There is no standard one-step Excel shortcut that applies Subscript immediately. On Windows, use Ctrl+1 to open Format Cells, then choose Font and check Subscript. On Mac, Command+1 opens the formatting dialog.
Can I subscript just one number in a cell?
Yes. Edit the cell, select just that number, open Format Cells, and turn on Subscript in the Font tab. If you select the cell without editing its text, the effect may apply to all of its contents.
Does subscript change a formula or the value?
No. Subscript is a visual font effect. It does not change the underlying text or calculation, and it does not make a formula treat a digit as a different mathematical value.
Can Excel automatically subscript part of a formula result?
Not as character-level rich-text formatting. Formula results do not automatically apply a font effect to just one returned character. For a changing label, consider a suitable Unicode subscript character or separate the label from the calculated value.
Why does subscript disappear when I export or paste?
Some destinations keep only plain text and discard Excel’s font formatting. CSV files do not preserve rich text effects. Use a Unicode subscript character if the lowered appearance needs to travel as text, and confirm that the receiving application supports that character.
Related
- Excel Borders Not Showing? Causes, Checks, and Fixes
- Border Lines in Excel: Add, Change, and Remove Them
- Excel Borders: How to Add, Change, and Remove Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Freeze Panes in Excel: Shortcut Key and How It WorksIn Excel for Microsoft 365 on Windows, the Freeze Panes shortcut is Alt, W, F, F—press the keys…
- Delete Blank Rows in Excel Quickly: Safe Ways to CleanTo delete blank rows in Excel quickly, filter a column that every valid record must contain, select the…
- Excel Dependent Drop-Down Lists: Setup and FixesYes. In Excel for Microsoft 365 on Windows, create a drop-down for the first choice, then make the…
- Excel Workbook vs Excel Binary Workbook: Key DifferencesAn Excel workbook is the general name for a spreadsheet file; an Excel Binary Workbook is one specific…
- How to Insert a Line in a Word Table: Step by StepTo insert a line as a new row in a Microsoft Word table, click a cell in the…
- Excel Power Query Background Refresh ExplainedYes, Power Query in Excel can refresh data in the background, but it is not enabled by default.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.