Excel does not have a single keyboard shortcut that directly turns text into subscript. In Excel for Microsoft 365 on Windows, press Ctrl+1, open the Font tab, select Subscript, and choose OK. To format just a few characters, select those characters while editing the cell before opening Format Cells.
Is there a direct keyboard shortcut?
Unlike bold, which you can toggle with Ctrl+B, subscript has no default one-step shortcut in Excel for Windows. Ctrl+1 is a keyboard shortcut for the Format Cells dialog, not a subscript toggle. From there, you need to select the Subscript effect. This distinction matters: searching for a key combination such as Ctrl plus a letter may lead to shortcuts that work in another Office app but do not apply subscript in Excel.
You can still use the keyboard for most of the operation. After opening Format Cells, use Ctrl+Tab to move among the dialog tabs until Font is active, then use Tab to move through the controls. When the Subscript checkbox has focus, press Space to toggle it, then move to OK and press Enter. The number of Tab presses depends on the dialog’s current focus and version, so watch the focus indicator rather than relying on a fixed count. Clicking the Font tab and checkbox is often faster if you do not need a keyboard-only workflow.
Apply subscript to a whole cell
If every character in a cell should be subscript, select the cell and open Format Cells with Ctrl+1. Choose the Font tab, check Subscript in the Effects area, and click OK. This changes the visual formatting of the cell’s contents. You can select several cells first to apply the same effect to all of them, although applying it to a cell containing a number may make the number appear lower and smaller than surrounding text.
To remove the effect, select the formatted cell or text, return to Format Cells > Font, clear Subscript, and confirm. The checkbox reflects the formatting of the current selection. If a selection contains a mixture of regular and subscript characters, the control may show a mixed state; changing it can make the selected characters consistent. Check the result after applying a change, especially when multiple cells or mixed formatting are selected.
Format only part of a cell
For a chemical formula such as H₂O, you may want only the 2 to sit below the baseline. Excel supports character-level formatting in a cell containing text, but you must select the character itself—not just the cell—before applying the effect.
- Select the cell and enter edit mode by pressing F2, or double-click the cell.
- Highlight the character or characters to format. You can select text in the cell or in the formula bar while editing.
- Press Ctrl+1, choose the Font tab, check Subscript, and click OK.
- Press Enter if you are still editing, then confirm that only the intended characters have changed.
For example, type H2O as ordinary text, enter edit mode, select only the 2, and apply Subscript. The result looks like H₂O, while the H and O remain on the baseline. If you simply select the cell without selecting its characters, Excel applies the font effect to the entire cell’s contents instead. Selecting a character can take practice: use the arrow keys with Shift while editing, or drag across the character in the formula bar.
What subscript formatting changes—and what it does not
Subscript is a font effect. It changes where selected text appears relative to the baseline and typically makes it smaller. It does not change the underlying characters, calculate a value, or give a number a special mathematical meaning. For instance, formatting the 2 in H2O does not turn the cell into a chemical data type; it remains text with character formatting.
That difference is important for calculations and sorting. A cell containing the text H2O is not a numeric quantity that Excel can use in arithmetic. Likewise, making a digit appear as a subscript does not alter the value stored in a numeric cell. The effect is for presentation, not a substitute for a formula, unit conversion, or data structure. If a symbol must be recognized consistently by another system, check whether that system expects plain text, Unicode characters, or a particular data format.
There is another practical limit: a formula returns a value, but Excel generally cannot use a formula to apply different font effects to individual characters of that changing result. You can format the displayed text manually, but if the formula result changes, that manual character-level formatting may not correspond to the new characters. For dynamic labels, consider using Unicode subscript characters where appropriate or assembling the display in a way that does not depend on selective rich-text formatting.
Useful examples and when to use them
Subscript is useful when positioning is part of the notation. Common examples include the 2 in H₂O, the 2 and 4 in SO₄²⁻, and an index in a label such as x₁. In a worksheet used for teaching, documentation, or a report, this can make a formula easier to read without changing the cell’s meaning. For a small amount of static text, character-level formatting keeps the notation in one cell and allows the surrounding letters to remain normal size.
Use it selectively. If a worksheet will be searched, exported, copied into another application, or processed by a script, the underlying text may still be H2O even though it looks like H₂O. A colleague searching for the Unicode character ₂ may not find an ordinary 2 with subscript formatting, and a plain-text export may lose the visual effect. Add a note or use a consistent data convention if the distinction matters beyond appearance.
Windows, Mac, and Excel for the web
The steps above are for Excel for Microsoft 365 on Windows. On a Mac, Command+1 opens Format Cells; then use the Font settings to select Subscript. The exact dialog layout and keyboard navigation can differ between Windows and Mac, but the key idea is the same: select the text, open its font settings, and enable the Subscript effect. Excel for the web may not expose the same character-level font controls as the desktop app. If you cannot find Subscript in the web interface, open the workbook in the desktop version of Excel to apply the formatting.
When using a shared workbook, remember that visual formatting and the text itself are separate. Other people may see the rich-text effect in Excel while a plain-text copy or an application that does not preserve rich formatting may show ordinary characters. If exact appearance is essential in a document or presentation, check the output after copying or exporting rather than assuming the formatting will travel intact.
Common problems and fixes
- The entire cell changed. You selected the cell rather than individual characters. Edit the cell, highlight only the intended text, and apply Subscript again.
- Nothing appears to happen. Confirm that the Subscript checkbox was selected and that the text is not too small to make the lower position obvious. Increase the zoom temporarily or inspect the Font tab again.
- The displayed formula result will not format one character. Formula results do not provide the same dependable character-by-character editing as static text. Use a suitable Unicode character or revise the way the label is displayed.
- The appearance changes after copying. Some destinations preserve rich-text formatting and others retain only the characters. Test the destination, or use Unicode subscripts when portability is more important than keeping plain underlying digits.
- The character looks clipped. Row height, font choice, and zoom can affect how a lowered character appears. Try adjusting row height or using a font with clear subscript forms; do not assume the character itself is missing.
Also check whether the cell is protected or the worksheet is protected if Excel will not let you edit it. Formatting restrictions can prevent changes even when the Format Cells dialog opens. If only some of the text is protected by a workflow or template, make a copy and confirm the workbook’s rules before changing shared or official material.
Unicode subscripts as an alternative
Unicode contains separate subscript characters, including digits such as ₀, ₁, ₂, and ₃. You can paste one directly into a cell—for example, type H, insert ₂, and type O—to create H₂O as text. This is convenient for short labels that need to survive plain-text copying, because the lowered digit is an actual character rather than a font effect. The set of available subscript letters and symbols is limited, however, and support or appearance can vary by font and destination.
Choose between the methods based on the job. Use Excel’s Subscript font effect when you want normal underlying characters and need to control exactly which characters are formatted. Use Unicode when portability of the visible character is more important and the required symbol exists. Neither option makes a notation into a numeric value or guarantees that every external program will interpret it the same way.
Frequently Asked Questions
What is the keyboard shortcut for subscript in Excel?
Excel has no dedicated one-key subscript shortcut. On Windows, Ctrl+1 opens Format Cells; select the Font tab and turn on Subscript. On Mac, use Command+1 to open the formatting dialog.
Can I make only one number in a cell subscript?
Yes, if the cell contains editable text. Enter edit mode, select just the number, open Format Cells, and enable Subscript. Selecting the cell without highlighting its characters affects the whole cell’s text instead.
Does subscript change a cell’s value?
No. Subscript is visual formatting, so it does not change the underlying characters or numeric value. It also does not make a text label usable as a number in a calculation.
Can I use subscript in an Excel formula result?
Excel does not reliably apply character-level formatting to parts of a changing formula result. For a dynamic label, consider a suitable Unicode subscript character or a different display approach.
Why can’t I find Subscript in Excel for the web?
The web version may not provide the same character-level font controls as desktop Excel. Open the workbook in Excel for Microsoft 365 on Windows or Mac and use the Font tab in Format Cells if the option is unavailable online.
Related
- How to Transpose Names in an Excel Column to a Row
- How to Transpose in Excel: Turn Rows Into Columns Easily
- Transpose in Excel Without Pasting: 3 Practical Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Archive Years of Emails in OutlookTo archive years of email in Outlook, search for messages older than a chosen date, review the results,…
- How to Add a Date Stamp to a Checkbox in ExcelTo add an automatic date stamp to an Excel checkbox, place the checkbox in column B, use the…
- How to Keep Track of Bills in ExcelTo keep track of bills in Excel, create a list with one row per bill due, record its…
- Microsoft Excel: How to Open the App and FilesTo open Microsoft Excel on a Windows PC, select Start, type Excel, and choose the Excel app in…
- Excel Keyboard Shortcut to Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (Control plus the semicolon key) to insert today’s date…
- Autofit Images in Excel Cells: A Step-by-Step GuideTo autofit an image in an Excel cell, insert it with Insert > Pictures > Place in Cell…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.