How to Format Subscript Numbers in Microsoft Excel

How-to basics · Updated November 20, 2026

To make a number subscript in Excel for Microsoft 365 on Windows, edit a text cell, select only the digit, press Ctrl+1, open the Font tab, check Subscript under Effects, and choose OK. This changes how the selected character looks; it does not change a number’s value or make it suitable for calculation. For a label such as H₂O, the cell needs to contain text, not a formula result.

Subscript is useful for chemical formulas, mathematical labels, and footnote-style notation. Excel applies it to selected characters in text stored directly in a cell. The steps below explain how to select the right character, format it, and handle situations where the option is unavailable.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The desktop Excel app is best for formatting individual characters in a cell.
  • A cell containing text, such as H2O or x2. If you need a number such as 10 to display as text, enter an apostrophe before it: ’10. Excel displays 10 and treats it as text.
  • A keyboard and mouse or trackpad so you can select just the digit to format.

The apostrophe is only a way to tell Excel to store an entry as text; it is not displayed in the cell. If the cell contains a formula, or if Excel has recognized the entry as a numeric value, partial-character formatting may not be available. Use text for notation that is meant to be read, rather than used in calculations.

Step-by-Step

  1. Enter the text in a cell. Click a blank cell and type the label you need, for example H2O. For a digit-only label such as 10, type ’10 so Excel stores it as text. Press Enter. You can also use text already in a cell, provided it is not the result of a formula.
  2. Open the cell for editing. Click the cell, then press F2 on a Windows keyboard. Alternatively, double-click the cell. You should see the text cursor inside the cell. If the cell is narrow, you can edit in the formula bar above the worksheet instead.
  3. Select only the digit or digits. Use the mouse to drag across the character you want to lower. In H2O, select the 2, not the H or O. You can also place the cursor beside the character and use Shift with the arrow keys to select it. Check the highlight carefully: formatting applies to what is selected, and selecting the whole cell’s contents will affect all the text.
  4. Open Format Cells. While the cell is in edit mode and the character is selected, press Ctrl+1. The Format Cells dialog opens. You can also right-click the selection or cell and choose Format Cells, or use the small dialog box launcher in the Font group on the Home tab.
  5. Choose the subscript effect. In Format Cells, open the Font tab. In the Effects area, select the Subscript checkbox. Confirm that you have not selected Superscript by mistake. Click OK to apply the formatting to the selected character.
  6. Finish editing and check the result. Press Enter, or click the check mark beside the formula bar, to finish editing. The selected digit should appear lower than the surrounding letters. For example, H2O should look like H₂O. The underlying cell text remains H2O; only the appearance of the 2 changes.
  7. Repeat for other characters as needed. To format a second digit, edit the cell again, select that character, and repeat the Format Cells steps. You can select a run of adjacent characters together, but select only those that should be subscripted.

On a Mac, use Command+1 to open Format Cells, then select Subscript on the Font tab and click OK. The editing and character-selection steps are otherwise similar. If your keyboard or Excel settings do not respond to that shortcut, open Format Cells from the cell’s context menu instead.

Excel for the web has fewer rich-text editing capabilities than the desktop app, and character-level subscript formatting may not be available for the cell you are editing. If you cannot select part of the text or find the Subscript effect, open the workbook in the desktop Excel app. The same limitation applies to many formula-generated labels: Excel cannot apply a different character style to only part of a formula’s result using ordinary cell formatting.

Common Mistakes

  • Formatting the entire cell instead of one character. If all of H2O is selected, the whole label becomes subscript. Enter edit mode and highlight only the 2 before opening Format Cells.
  • Trying to subscript a calculated result. Excel’s normal font settings apply to the whole formula result, not selectively to characters produced by the formula. If the label must have mixed formatting, enter it as a text constant and format it directly, or use Unicode subscripts where appropriate.
  • Leaving a digit as a number when the entry should be text. A numeric value is intended for arithmetic, while a notation label is usually text. For a digit-only label, type an apostrophe before the digits when entering them. This is especially important if the Subscript option is unavailable for the numeric entry.
  • Choosing Superscript instead. Superscript raises characters above the baseline; subscript lowers them. Both options are in the Font tab, so verify the checkbox name before clicking OK.
  • Expecting subscript to change the value. Subscript is character formatting, not a calculation or number format. It does not convert a number to a different numeric value, nor does it make an entry more precise.
  • Using a custom number format for partial formatting. Custom number formats can change how a value is displayed, but they do not provide a general way to lower one chosen digit inside a number. Use rich-text formatting on text or a suitable Unicode character instead.

Tips

  • Keep calculation data separate from display labels. Store a true number in one cell if you need to calculate with it, and create a separate text label for the subscripted notation. That avoids turning useful numeric data into text just to change its appearance.
  • Use Unicode subscripts for simple, portable labels. Characters such as ₂ and ₃ are actual text characters, not Excel’s Subscript effect. You can paste them into a cell or insert them using your operating system’s character picker. This is convenient for short labels, but the available subscript characters are limited and their appearance can vary by font.
  • Check how the label looks after changing fonts. Character-level formatting generally travels with the text in the workbook, but a different font or application can render the lowered character differently. Review important labels when printing or sharing the file.
  • Copy the formatted cell when reusing the same notation. Copying a cell can preserve its rich-text formatting. If you only want its text, use Paste Special or edit the copied text carefully; a paste may also carry other cell formatting.
  • Use subscript for appearance, not accessibility or data meaning. Screen readers and other software may interpret styled text differently from actual Unicode subscript characters. For a label whose meaning must be machine-readable, consider keeping a plain-text version in a nearby cell or adding a clear accessible description.
  • Consider readability at small sizes. A subscript sits lower and is often visually smaller than the surrounding text. If it is difficult to read, increase the cell’s font size or column width rather than applying the effect to more characters than necessary.

Troubleshooting

The Subscript checkbox is disabled or does not affect the digit. Confirm that you are editing a text constant and have selected characters inside it, not merely selected the cell border. Press F2, highlight the digit, and reopen Format Cells. If the cell contains a formula or a number Excel is treating as numeric, make a separate text label or enter a text version in another cell.

The whole label changed. Undo with Ctrl+Z on Windows (Command+Z on Mac), edit the cell again, and select only the intended characters. A common cause is selecting the cell with a single click rather than entering edit mode and highlighting part of its contents.

The character looks too low, small, or clipped. Subscript changes the character’s position and can make it appear smaller. Try a larger font size or a different font, and check the cell at normal zoom and in Print Preview. Adjust row height if the cell’s text is visibly cut off.

The subscript disappears after pasting or exporting. Some destinations preserve rich-text formatting and others do not. Try pasting with source formatting, or use a Unicode subscript character if it suits the label. Before sharing a PDF or printed copy, inspect the exported result rather than assuming the formatting carried over.

You cannot select a character in Excel for the web. Save or ensure the workbook is saved, then open it in the desktop Excel app and use the Font tab in Format Cells. If you are already in desktop Excel and editing is restricted, check whether the worksheet is protected or the workbook is open in read-only mode.

Frequently Asked Questions

Can I subscript only one number in an Excel cell?
Yes, when the cell contains editable text. Enter edit mode, select the digit itself, and apply Subscript from Format Cells. The rest of the text remains at its normal baseline.

Can I use a keyboard shortcut to apply subscript?
There is no standard direct subscript shortcut in Excel for Windows. Use Ctrl+1 to open Format Cells, then choose Subscript on the Font tab. On Mac, Command+1 opens the dialog in supported Excel desktop versions.

Can I subscript a number and still use it in calculations?
Subscript changes appearance, not numeric value. However, partial-character styling is intended for text, and a text label such as ’10 will not behave like the numeric value 10 in calculations. Keep a separate numeric cell for arithmetic.

Can Excel subscript digits returned by a formula?
Not with ordinary cell formatting applied to just part of the formula result. You can use Unicode subscript characters in a text-building approach for a label, but the result is text and the available characters are limited. Keep calculation results separate from presentation labels.

Why is my subscript option missing in Excel for the web?
The web app does not expose every rich-text formatting feature available in desktop Excel, and support can depend on what is selected. Open the workbook in desktop Excel and select the character inside the cell before opening Format Cells.

Will subscript formatting print?
Yes, Excel’s character formatting normally appears in printouts and PDFs. Check Print Preview because small fonts, substituted fonts, or narrow row heights can make a lowered character hard to read or appear clipped.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.