In Excel for Microsoft 365 on Windows, there is no dedicated one-key shortcut that toggles subscript. To apply it, select the character or text in the cell, press Ctrl+1 to open Format Cells, choose the Font tab, check Subscript, and click OK. Ctrl+1 is the shortcut to the formatting dialog; you still need to select the Subscript option there.
Subscript lowers text slightly below the normal writing line, as in H₂O or CO₂. It changes how characters look, not what Excel stores or calculates. For partial formatting, the cell must contain text you can edit directly; formula results cannot have only selected characters formatted as subscript.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a desktop version of Excel with the Format Cells dialog.
- A cell containing text or a number that you want to format. To subscript just part of the entry, you need to select those characters while editing the cell.
- A keyboard and mouse or trackpad. The dialog shortcut is Ctrl+1 on Windows; Excel for Mac uses Command+1 to open Format Cells.
Step-by-Step
- Enter the text in a cell. For example, type H2O in A1 and press Enter. Keep the entry as ordinary text if you intend to format only one character. If Excel treats an entry as a number or a formula, partial rich-text formatting may not be available in the way you expect.
- Reopen the cell for editing. Click the cell and press F2, or double-click it. You can also click in the formula bar to edit the cell’s contents. The insertion point or selection must be inside the text; simply selecting the cell formats the whole cell rather than a particular character.
- Select the characters to lower. In H2O, drag across just the 2. If you prefer the keyboard, place the cursor next to the character and use Shift with the arrow keys to select it. Check that only the intended character is highlighted. If you have a longer string, such as CO2, select only the final 2.
- Open the Format Cells dialog. While the character selection is active, press Ctrl+1 on Windows. If you are using the mouse, right-click the selected text and choose Format Cells when that option is available. The keyboard route is usually quicker. On Mac, use Command+1; keyboard details can differ by keyboard layout and Excel release.
- Open the Font tab. In Format Cells, select Font if it is not already active. Under Effects, find the Subscript checkbox. Do not choose Superscript, which raises characters above the text line.
- Apply the effect. Check Subscript, then click OK. Excel returns you to the cell, and the selected character should appear smaller and lower than the surrounding text. Press Enter or click another cell to finish editing if you are still in edit mode.
- Verify the result. Confirm that the right character changed and that the rest of the entry stayed at its normal baseline. For H2O, the 2 should be lowered while the H and O remain unchanged. If the entire text moved, undo with Ctrl+Z and repeat the selection step more carefully.
- Repeat for other characters as needed. To format several separate digits, you can select and format each one individually. If adjacent characters should all be subscript, select the complete run before opening Format Cells. You do not need to retype the cell contents.
To subscript an entire cell rather than only part of its contents, select the cell normally, press Ctrl+1, open Font, check Subscript, and click OK. This applies the effect to the cell’s displayed text. It is usually not what you want for a chemical formula such as H2O, because H and O would be lowered along with the 2.
Common Mistakes
- Expecting Ctrl+1 to apply subscript immediately. Ctrl+1 opens Format Cells; it does not turn subscript on by itself. You must choose the Font tab, check Subscript, and confirm.
- Selecting the cell instead of selecting its characters. A normal cell selection tells Excel to format the cell’s contents as a whole. To change only one digit, enter edit mode with F2 or double-click, then highlight the digit.
- Choosing Superscript by mistake. Superscript raises characters, as in x². Subscript lowers them, as in H₂O. Both options are in the Font tab’s Effects area, so check the label before applying.
- Trying to format only part of a formula result. Excel cannot apply a character-level font effect to just one portion of text returned by a formula. Formatting the cell affects the result as a whole, and a recalculation can replace the displayed string. Use manually entered text, separate cells, or an appropriate Unicode character instead.
- Assuming the stored value changes. Subscript is character formatting. It does not change a digit into a different numeric value or alter calculations. A cell that contains the number 2 still contains 2 even if it is displayed with subscript formatting.
- Using the wrong shortcut for your computer. Ctrl+1 is the Windows shortcut. On Mac, the corresponding Format Cells shortcut is generally Command+1. If a laptop’s function-key settings affect your editing workflow, use double-click or the formula bar as an alternative to F2.
Tips
- Use a simple test entry first. Try H2O in an empty cell and format only the 2. This makes it easy to see whether you are selecting characters or applying a cell-wide effect.
- Use the formula bar when in-cell selection is awkward. Click the cell, then click within its text in the formula bar and select the characters there. This can be easier for long entries or narrow columns. Make sure you are editing the cell’s actual text, not just selecting the cell.
- Keep the underlying text easy to edit. For labels and chemical notation that do not need to calculate, enter them as text and apply character formatting. For a text value that Excel might interpret as a number or date, entering an apostrophe first can force text entry; the apostrophe is not displayed as part of the cell value.
- Use Unicode subscripts when text must travel elsewhere. Characters such as ₂ and ₃ are actual Unicode characters, so they can remain lowered when copied into many other applications. However, the available subscript characters are limited, their appearance depends on the font, and not every letter has a matching subscript form. They are characters, not Excel’s Subscript effect.
- Use separate cells for calculated labels. If a formula builds a changing label, splitting the normal text and subscript portion across adjacent cells can be more maintainable than trying to format part of a formula result. You can adjust column widths, alignment, and borders to make the pieces look like one label.
- Remember that copying can preserve formatting. Copying a manually formatted cell generally carries its character formatting with it. If you want only the text in another location, use Paste Special options such as Values where appropriate, then check whether the destination’s formatting is what you intended.
Troubleshooting
Ctrl+1 does nothing: First make sure Excel has focus and that you are not typing into another application or a dialog. Select the cell, enter edit mode, select the characters, and try Ctrl+1 again. You can also open the Format Cells dialog from the cell’s context menu or use the Font dialog launcher on the Home tab. On a Mac, try Command+1 instead.
The whole cell becomes subscript: You likely selected the cell without selecting text inside it. Undo the change, then press F2 or double-click the cell. Highlight only the character or run of characters to change before opening Format Cells. If text selection is difficult, use the formula bar.
The Subscript checkbox is unavailable or the change does not stick: Check whether you are working in Excel for the web, a protected worksheet, or a cell whose content is generated by a formula. Excel for the web has fewer character-level formatting controls than the desktop app, and formula output cannot be selectively formatted character by character. Open the workbook in the desktop Excel app and try with a manually entered text cell. If the sheet is protected, ask the workbook owner for permission to edit or format the cell.
The result looks too low, too small, or different from another computer: Subscript appearance depends on the font and display scaling. Try a font with broad Unicode and typography support, increase the font size slightly, or use a Unicode subscript character if preserving the appearance outside Excel is more important than keeping the text as ordinary editable characters. Avoid combining a Unicode subscript digit with Excel’s Subscript effect unless you specifically want it lowered a second time.
The formatting disappears after an update: If the cell’s text comes from a formula, a refresh, or a data import, Excel may replace the contents and discard character-level formatting. Apply the formatting to a stable, manually maintained text entry, create a separate display label, or use appropriate Unicode characters. Cell-level formatting alone cannot preserve a different style for one character in every changing formula result.
Frequently Asked Questions
Is there a direct keyboard shortcut for subscript in Excel?
No dedicated keyboard shortcut directly toggles subscript in Excel for Windows. Ctrl+1 opens the Format Cells dialog; choose Font, check Subscript, and click OK. On Mac, Command+1 generally opens the equivalent dialog.
Can I subscript just one number in a cell?
Yes, when the cell contains editable text. Enter edit mode with F2 or a double-click, select the number, open Format Cells with Ctrl+1, then use Font > Subscript. Selecting the cell without selecting its text applies formatting to the whole cell.
Can Excel subscript text returned by a formula?
Not selectively. Excel can format the formula result as a whole, but it cannot assign subscript to just one character within the formula’s returned text. Use separate cells, manually entered text, or a suitable Unicode subscript character for a changing label.
Does subscript change the value or affect calculations?
No. Subscript changes appearance only. It does not alter the cell’s underlying value, the characters stored in the cell, or the result of a calculation.
How do I remove subscript formatting?
Edit the cell and select the subscripted characters, press Ctrl+1, open Font, clear the Subscript checkbox, and click OK. If the whole cell is subscripted, select the cell normally and clear the same checkbox.
Can I use the same steps in Excel for the web?
Excel for the web may not provide the same character-level Format Cells controls as desktop Excel. For reliable formatting of selected characters, open the workbook in the Excel desktop app. Unicode subscript characters can be an alternative for short labels, subject to font support.
Related
- Split Cells in Excel: Shortcut Key and Text to Columns
- How to Split an Excel Page into Separate Panes
- How to Split an Excel Row in Half
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 Freeze More Than the Top Row in ExcelTo freeze more than the top row in Excel, select the cell directly below the rows you want…
- Apply a Dropdown to an Entire Column in Google SheetsTo apply a dropdown to a whole column in Google Sheets, select the column or enter its range…
- Combine Excel Files: Practical Methods and StepsTo combine Excel files with the same column layout, put them in one folder, then in Excel for…
- Create a Signature in Outlook 365: Step-by-Step GuideTo create an email signature in Outlook 365, open the signature settings for your version of Outlook, write…
- Excel Care Center? Where to Find Microsoft Excel HelpMicrosoft Excel does not have a built-in feature officially called a “Care Center.” If you need help with…
- Close Version History in Excel Without Losing DataTo close Version History in Excel for Microsoft 365 on Windows, open the Version History pane and select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.