To subscript text in Excel for Microsoft 365 on Windows, select the character or characters you want to lower, press Ctrl+1, open the Font tab, check Subscript, and choose OK. Excel does not have a single direct keyboard shortcut that toggles subscript, but Ctrl+1 is the shortcut to the formatting dialog. For a whole cell, select the cell first; for only part of its text, edit the cell and select those characters first.
What You’ll Need
- Excel for Microsoft 365 desktop on Windows, or Excel for Mac if you are using a Mac. The steps below are for Windows unless noted.
- A cell containing text. Subscript is character formatting, so it is useful for text such as H2O or x1. If you need to format part of a formula result, see the limitations below.
- A keyboard and mouse or trackpad. The shortcut opens the formatting dialog, but you may need to use the dialog controls to apply the effect.
Step-by-Step
- Enter or locate the text. Type the text into a cell or find the existing cell you want to change. For example, enter H2O to format the 2 in a chemical formula, or x1 to format the 1 in a label. Excel will generally treat these examples as text because they contain letters. If your cell contains only digits and you need only one digit to appear as subscript, make sure the content is stored as text; character-level formatting is not a reliable option for a numeric value.
- Choose whether you are formatting one character or the whole cell. To subscript every character in a text cell, click the cell once to select it. To subscript only part of the cell, double-click the cell or select it and press F2 to edit its contents. You can also click in the formula bar to edit the text, then place the insertion point where you need it. Keep the cell in edit mode while selecting the exact characters.
- Select the characters to lower, if needed. For partial formatting, place the cursor beside the character or group you want to change. Hold Shift and use the arrow keys to extend the selection. For example, in H2O, place the cursor immediately before 2 and press Shift+Right once to select it. If you are using the mouse, drag across only the intended character while the cell is being edited. Check that the highlight does not include a neighboring letter by mistake.
- Open Format Cells with the shortcut. With the cell selected or the desired text highlighted in edit mode, press Ctrl+1 on Windows. This opens the Format Cells dialog. Ctrl+1 is the quickest keyboard route to the formatting controls; it is not, on its own, a subscript toggle. If the dialog does not appear, click the worksheet to ensure Excel has focus, then try again.
- Choose the Font tab. In Format Cells, select Font. Under Effects, find the Subscript checkbox. The exact layout can vary slightly with window size, but Subscript is a font effect in this dialog, not a number format or alignment option. If the dialog opens on another tab, click Font before changing an effect.
- Apply Subscript and confirm. Check Subscript, then click OK. If you selected part of the cell’s text, Excel applies the effect to that selection and leaves the remaining characters at their original size and position. If you selected the cell without editing its contents, the effect applies to the cell’s text as a whole. Look at the result in the worksheet and confirm that the right characters moved below the text line.
- Repeat for other characters as needed. Each separate group can be selected and formatted in turn. For example, in a longer chemical notation, apply subscript to each numeral that belongs below the baseline without selecting element letters or punctuation. You do not need to retype the cell to format another character; edit it again, select the next character, and use the same dialog steps.
- Use the Mac equivalent if you are on a Mac. In Excel for Mac, select the cell or text, then press Command+1 to open Format Cells. Choose Font, check Subscript, and confirm. The Windows Ctrl+1 shortcut does not apply on Mac. Excel for the web has a more limited formatting interface; if you cannot find character-level subscript controls, open the workbook in the desktop app and apply the formatting there.
Optional keyboard navigation: In some English-language Windows dialogs, Alt+B activates the Subscript checkbox when its access key is shown. Access keys can depend on the Excel version, language, and dialog state, so do not rely on this as a universal shortcut. If it does not select Subscript, use the checkbox with the mouse or navigate to it with Tab and the arrow keys. The reliable method is Ctrl+1 followed by choosing the Subscript control in Format Cells.
Common Mistakes
Selecting the cell instead of its characters. A single click selects a cell, not a particular letter or digit inside its text. If you want only one character to be subscript, enter edit mode first with a double-click or F2, then highlight the character. Otherwise, Excel may format the entire cell’s text.
Expecting Ctrl+1 to apply subscript by itself. Ctrl+1 opens Format Cells. You still need to choose Font, check Subscript, and confirm. Pressing the shortcut repeatedly does not switch subscript on and off as a dedicated toggle would.
Formatting the wrong part of the text. A selection that includes a letter or an extra digit will apply subscript to all of it. Zoom in or inspect the highlighted characters before opening the dialog. This matters in compact labels, chemical formulas, and strings with several numbers close together.
Trying to subscript a value that is meant to remain numeric. Excel treats numeric values as numbers, not as individually styled characters. For a label where appearance matters more than arithmetic, store the entry as text. If the value must be used in calculations, keep the numeric value separate and create a display label in another cell rather than relying on partial formatting.
Looking for a direct subscript button on the ribbon. Excel’s standard ribbon does not provide a prominent one-click subscript toggle like some word-processing apps. The Font tab in Format Cells is the dependable location. A ribbon layout or shortcut copied from Word may not work the same way in Excel.
Expecting formatting to carry through every edit or output. Pasting, replacing the cell’s contents, or generating text with a formula can change or remove character-level formatting. Check the display after editing or pasting. Do not assume that a formula-created string can have just one of its output characters individually subscripted.
Tips
For short scientific notation, keep the selection precise: in H2O, subscript the 2, not the O. For an expression such as x1, subscript the 1 only if that is the notation you intend. Excel changes how selected text looks; it does not interpret the text as a scientific formula or alter its meaning.
If you often use the same notation, make a small sample cell with the desired formatting and copy it as a visual reference. When entering a new label, check whether Excel retained the character formatting you need. If it did not, edit the new cell and format the relevant characters again rather than assuming the style transferred.
You can remove subscript by selecting the same characters, opening Format Cells with Ctrl+1 on Windows or Command+1 on Mac, clearing the Subscript checkbox, and choosing OK. This is useful if you accidentally formatted too much text. For a cell with mixed formatting, clear the effect only from the unwanted characters so the correctly formatted portions stay unchanged.
When the exact look matters in a report, consider whether the cell needs to remain editable data or is simply a visual label. Excel can handle many basic labels, but rich character formatting is less robust than keeping the underlying data in a separate cell or using a dedicated text tool. Preserve a clean numeric value for calculations and use a separate display cell for notation when practical.
Troubleshooting
Ctrl+1 does nothing: Make sure the worksheet, rather than another app or a text-entry field, has keyboard focus. Select a cell and try again. On a laptop, check whether the keyboard requires an Fn key for number-row or function-key behavior; Ctrl+1 uses the number 1, not F1.
Subscript is unavailable or greyed out: Confirm that you are in the desktop Excel app and have selected text in a cell that supports character formatting. If the contents come from a formula, Excel cannot generally apply separate font effects to only part of the calculated result. Use a manually entered text label for the displayed notation, or place the components in separate cells and format them separately.
The whole cell changed instead of one character: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Then edit the cell with F2 or a double-click, highlight only the intended characters, and repeat the formatting steps. Before choosing OK, verify that the character selection is still active.
The text looks too small or is hard to read: Subscript is deliberately smaller and lower than ordinary text. Increase the cell’s font size if appropriate, widen the column, or increase zoom to inspect the result. Avoid using subscript for a long passage because it can make the cell difficult to scan.
The formatting disappears after pasting: The source, paste method, or destination may have replaced the cell’s rich text formatting. Reapply Subscript to the relevant characters after pasting. If the label is frequently refreshed or generated from a formula, consider separating the display from the underlying data because partial character formatting may not persist reliably.
You cannot select one character in Excel for the web: Open the workbook in Excel for Microsoft 365 desktop or Excel for Mac and use the Format Cells dialog. The web app’s available controls can differ, and it may not expose the same character-level formatting workflow. After making the change in desktop Excel, save the workbook and check it again in the browser.
Frequently Asked Questions
What is the keyboard shortcut for subscript in Excel?
There is no single built-in shortcut that directly toggles subscript. On Windows, select the text and press Ctrl+1 to open Format Cells, then choose Font, check Subscript, and confirm. On Mac, use Command+1.
Can I subscript just one number in a cell?
Yes, if the cell contains text and you select that number while editing the cell. Double-click the cell or press F2, highlight only the digit, then open Format Cells and apply Subscript. A numeric value stored as a number is not suitable for individual character formatting.
Does Ctrl+1 work in Excel for Mac?
No. The usual Mac equivalent for opening Format Cells is Command+1. The dialog’s Font tab and Subscript checkbox are the controls to use on Mac.
Can I subscript part of a formula result?
Excel generally does not support applying separate character formatting to only part of text returned by a formula. If the result is a label, use a manually entered text cell for the display or keep the pieces in separate cells. Keep numeric calculation inputs separate when they must remain usable as numbers.
How do I undo subscript?
Edit the cell, select the subscripted characters, open Format Cells, clear the Subscript checkbox, and choose OK. If you just applied the effect and have not made other changes since, Ctrl+Z on Windows or Command+Z on Mac is quicker.
Will subscript work in Excel for the web?
Controls can differ from desktop Excel, and character-level formatting may not be available in the same way. If you cannot select the characters or find the Subscript effect, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac and apply it there.
Related
- How to Delete Blank Cells in Excel Without Losing Data
- How to Delete an Excel File from a SharePoint Site
- How to Delete Blank Cells in Excel Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Conditional Data Validation ExplainedYes. In Google Sheets, conditional data validation can use a custom formula to allow or reject an entry…
- How to Normalize Cell Size in Excel for a Consistent LayoutTo normalize cell size in Excel, select the rows you want to standardize and choose Home > Format…
- Conditional Formatting in Word: What Works and What Doesn’tMicrosoft Word does not have Excel-style conditional formatting that automatically changes a cell’s color or font according to…
- Quick Average in Excel: A Fast Way to Find the MeanTo get a quick average in Excel, select an empty cell and enter =AVERAGE(B2:B5), replacing B2:B5 with the…
- Hanging Indent in Word: A Step-by-Step GuideTo create a hanging indent in Microsoft Word, select the paragraph or paragraphs, open the Paragraph settings, and…
- Create a Custom Distribution List in Outlook and Use ItTo create a personal distribution list in Outlook, open People, choose New contact list in new Outlook or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.