Can You Type Subscript in Excel? Methods and Limits

How-to basics · Updated November 21, 2026

Yes, you can type subscript in Excel. In the Microsoft 365 desktop app for Windows, select the characters in a text cell, open Format Cells with Ctrl+1, then choose Font > Effects > Subscript; for formula-generated text, use Unicode subscript characters instead.

What subscript means in Excel

Subscript is a character-formatting effect that places selected text slightly below the normal writing line and usually makes it look smaller. It is useful for chemical formulas such as H₂O, mathematical notation, and labels such as x₁. Excel can apply this appearance to part of a text cell, but the effect is different from changing the underlying characters.

For example, a cell may contain the ordinary text H2O, with only the 2 displayed as subscript. The stored text remains H2O; Excel records the appearance as character formatting. By contrast, H₂O contains the actual Unicode subscript-two character. Those two approaches can look alike on screen, but they behave differently when edited, searched, copied, or processed by formulas.

Subscript is not the same as a cell’s number format. A custom number format can control how an entire number appears, but it cannot turn just one digit in that number into a subscript. The character-level Font effect is for text, not a way to change the mathematical value of a number.

Format selected characters in desktop Excel

To make only part of a text entry subscript in Excel for Microsoft 365 on Windows, enter the text first, then select the specific character or characters while editing the cell. The steps are:

  1. Enter a text value, such as H2O, in a cell.
  2. Double-click the cell, or select it and press F2, to edit its contents.
  3. Select only the character to change. For H2O, select the 2—not the entire cell entry.
  4. Press Ctrl+1 to open the Format Cells dialog.
  5. On the Font tab, under Effects, check Subscript, then select OK.

The selected character should now sit lower than the surrounding text. You can use the same dialog to remove the effect: select the formatted character again, open Format Cells, and clear Subscript. If the whole cell is selected instead of a character within it, Excel may apply the effect to all of the cell’s text, so check the selection before confirming.

When selecting characters is awkward, use the formula bar or the in-cell editing cursor to position the selection precisely. The formula bar is especially useful for a long label, although the same principle applies: select the characters themselves before changing their font effect. Do not expect a special subscript key on the ribbon to convert an entire entry automatically.

Use Unicode when text is generated or reused

Unicode provides separate subscript characters, including ₀, ₁, ₂, ₃, ₄, ₅, ₆, ₇, ₈, and ₉. Because these are characters rather than a formatting effect, they can be included in text assembled by a formula, copied into other applications, or stored as the visible text in a cell. Support is not complete for every letter or symbol, and the appearance can depend on the font.

For a simple label, you can paste a character such as ₂ directly into a cell. To generate it in a formula, UNICHAR returns the character associated with a Unicode number. In any target cell, with no input cells needed, enter ="H"&UNICHAR(8322)&"O". The result is H₂O: Unicode decimal 8322 is the subscript-two character. The formula returns text, not a numeric value that Excel can use as a chemical quantity.

Unicode is often the more practical choice when a formula builds a label from other cells, or when you need the subscript character to survive plain-text export. It also avoids manually formatting individual characters. However, changing the formula’s text later may require editing its formula rather than selecting a displayed character, and searching for ordinary 2 may not find the distinct character ₂.

Insert a subscript character with Symbol

If you want to insert a Unicode character without copying it from another source, use Excel’s symbol picker in the desktop app. Select the destination cell, go to Insert > Symbol, choose a font that contains the character, and look for the needed subscript in the available symbols. Select it and insert it into the text. The precise contents of the dialog depend on the selected font and character subset.

The symbol picker inserts a character; it does not apply Excel’s Subscript font effect to an existing character. For example, inserting ₂ into H₂O creates a string with a distinct Unicode character. Applying the Subscript effect to the ordinary digit in H2O instead preserves the digit 2 and changes only its appearance. Pick the method based on whether character identity or visual formatting matters more.

How subscripts behave in formulas and data

Character formatting affects how text appears, not what an ordinary character means to Excel. Formatting the 2 in a text label as subscript does not make it a different character for formula calculations. In contrast, replacing it with the Unicode character ₂ changes the text itself. That difference matters if you compare strings, search for labels, or import the result into another system that expects plain digits.

Excel formulas return values and do not provide a standard worksheet function for applying rich-text formatting to only part of a formula result. If a formula must construct a label with a subscript, use an available Unicode character in the formula. If you need the appearance-only Font effect on selected text, apply it to a literal text cell in the desktop app.

Copying and exporting can also affect the result. A rich-text subscript may look right when pasted into another spreadsheet, but a destination that strips character formatting can display the original baseline character. Unicode usually preserves the character through plain-text copying, although a program or font without support may show a box or substitute glyph. For data that will be searched or exchanged, decide whether the recipient needs readable notation, consistent plain text, or a value suitable for calculation.

Excel for the web and Mac

Excel for the web has a more limited set of formatting controls than the desktop app, and character-level formatting options can depend on the current web interface. If you do not see a Subscript option for selected characters, open the workbook in the desktop version of Excel and use Format Cells. Unicode characters can still be entered or pasted in a web workbook, subject to font and browser rendering.

On Excel for Mac, the Format Cells dialog also provides font effects, though the dialog’s appearance and ribbon layout differ from Windows. Select the characters in the cell and use Command+1 to open Format Cells, then look on the Font tab for Subscript. Menu and shortcut behavior can vary with the Mac keyboard configuration; if the shortcut does not open the dialog, use the Format Cells command from Excel’s formatting menus.

Choose the method that fits the workbook

There is no single best method for every subscript. Think about how the entry will be used after it is formatted, not just how it looks in the current cell. These distinctions are useful:

  • Use the Font Subscript effect when you want normal text characters with carefully controlled appearance, such as a manually entered chemical formula in a report.
  • Use Unicode when a formula needs to build a label or when the actual subscript character should remain in plain text after copying.
  • Use ordinary baseline text when systems that receive the data may not support subscript characters or when the entry must be easy to type and compare.

Consider accessibility and consistency as well. A visual effect may not be conveyed clearly by every screen reader or downstream application, and Unicode glyphs can look different across fonts. If a workbook is shared, use one approach consistently and explain unusual notation in a nearby heading or note when readers might mistake the characters for data values.

Common problems and fixes

  • The entire entry becomes subscript: the whole cell was selected. Edit the cell and select only the intended characters before opening Format Cells.
  • The Subscript option is unavailable or has no effect: confirm that you are editing text in the desktop app and that actual characters are selected. If the cell contains a formula, use Unicode in the formula output or format a separate literal-text label.
  • The subscript looks like a missing box: try another font with broader Unicode coverage, or use the formatting effect on ordinary text if the text is not formula-generated.
  • A search or comparison misses the entry: ordinary 2 and Unicode ₂ are different characters. Decide on a consistent representation before building searches or comparisons around the text.

Frequently Asked Questions

Is there a keyboard shortcut to type subscript in Excel?
There is no universal one-keystroke shortcut that converts selected text to subscript. In Windows desktop Excel, Ctrl+1 opens Format Cells; select the characters first, then choose Subscript on the Font tab. On Mac, Command+1 opens the corresponding dialog.

Can I make only one number in a cell subscript?
Yes, if the cell contains editable text. Enter or edit the text, select only the digit, and apply the Subscript effect in Format Cells. This changes its appearance, not its value or identity.

Can a formula create subscript text?
Yes. A formula can join ordinary text with Unicode subscript characters, for example using UNICHAR for a supported character. A worksheet formula does not apply the rich-text Subscript effect to only part of its returned text.

Can I use subscript in Excel for the web?
You can enter or paste Unicode subscript characters in a web workbook. Character-level font formatting options may be limited or vary in the web interface, so use desktop Excel if you cannot find a Subscript control.

Does subscript formatting change a number?
No. The Font Subscript effect changes appearance only, and it is intended for selected text characters. It does not change a number’s value or make a digit a different character.

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.