Excel Subscript: How to Change Text to Subscript

How-to basics · Updated November 20, 2026

To change part of a cell’s text to subscript in Excel for Microsoft 365 on Windows, edit the cell, select the characters, press Ctrl+1, choose Font, check Subscript under Effects, and select OK. This applies visual formatting to selected characters, such as the 2 in H2O. You need Excel’s desktop app for the most reliable character-level formatting; a formula result or a numeric value cannot generally have just some of its characters formatted this way.

What You’ll Need

  • A workbook open in the Excel desktop app, preferably saved before you make formatting changes.
  • A cell containing text you can edit, such as H2O or CO2. The method is for text entries, not for changing a number’s value.
  • A keyboard and mouse or trackpad so you can enter edit mode and select just the characters to format.

On a Mac, Excel uses Command in place of the Windows Ctrl shortcut described below. Excel for the web may not provide the same character-level Font effects controls. If you cannot find Subscript there, open the workbook in the desktop app.

Step-by-Step

  1. Choose the cell and check what it contains. Click the cell with the text you want to change. This method works on text typed directly into a cell, including a mixture of letters and digits. It does not change a cell’s value or calculate a chemical formula; it changes how selected characters look. If the cell begins with an apostrophe to keep an entry as text, that apostrophe is not displayed in the cell.
  2. Enter edit mode. Double-click the cell, or click it once and press F2 on Windows. On a Mac, double-click the cell or use the keyboard’s edit-cell shortcut if configured; the mouse method works regardless of shortcut settings. You can also click in the formula bar and edit the cell’s text there. A blinking insertion point or a text selection indicates that you are editing the cell rather than merely selecting the whole cell.
  3. Select only the characters to lower. Drag across the characters in the cell or formula bar, or position the insertion point and use Shift with the arrow keys. For H2O, select just the 2, not the letters H and O. For CO2, select the 2. Take care not to include a neighboring space or punctuation unless you intend to format that character too. If selection is difficult in the narrow cell, use the formula bar, where the full entry is easier to see.
  4. Open the Format Cells dialog. Keep the characters selected and press Ctrl+1 on Windows. On a Mac, press Command+1. You can also use the small dialog launcher in the Home tab’s Font group if it is visible. Do not click another cell before opening the dialog, because that can end the text selection and apply formatting to a different selection.
  5. Find the subscript setting. In the Format Cells dialog, open the Font tab. Under Effects, select the Subscript check box. Confirm that you have not also selected Superscript; these are separate effects. The preview can help you check the appearance, though the lowered position may be subtle at small font sizes.
  6. Apply the change. Select OK. Excel returns you to the cell, and the chosen characters should appear lower and usually slightly smaller than the surrounding text. If you are still in edit mode, press Enter to finish editing. Click elsewhere and inspect the result at a readable zoom level.
  7. Repeat for other characters if needed. To format a different part of the same entry, edit the cell again, select the next character or group, and repeat the Font-tab steps. You can apply subscript to more than one separate character, but each selection must be formatted. For example, in a longer notation, select each digit that should appear lowered rather than applying the effect to the entire cell.
  8. Save the workbook. Press Ctrl+S on Windows or Command+S on Mac. Character formatting is saved with the workbook, but confirm the file is in a format that preserves Excel formatting, such as .xlsx. If you export to plain text or CSV, rich-text styling is not retained.

For a quick example, enter H2O as text, edit the cell, select only the 2, open Format Cells, and check Subscript. The displayed result reads like the chemical notation H₂O, while the underlying entry remains the characters H, 2, and O. That distinction matters: subscript is presentation, not a mathematical operation or a conversion of the digit into a different value.

Common Mistakes

  • Formatting the whole cell instead of the characters: Clicking a cell once selects the cell, not a portion of its text. If you choose Subscript without entering edit mode and selecting characters, Excel may apply the effect to the whole cell’s text. Edit the entry first and check that the intended characters are highlighted.
  • Leaving the selection in the wrong place: Selecting the whole entry, an adjacent letter, or a space can make the result look incorrect. Zoom in or select the text in the formula bar to improve precision. If the wrong characters change, undo with Ctrl+Z on Windows or Command+Z on Mac, then repeat carefully.
  • Expecting a formula result to support partial formatting: A formula cell displays a calculated result, and Excel does not let you apply rich-text formatting to only part of that result in the same way as directly entered text. Formatting the cell affects the result as a whole. If the output is only for display, consider using a manually entered text label or separate cells, while keeping calculations in their own cells.
  • Using number formatting for a character effect: The Number formats on the Home tab change how a value is displayed as a whole, such as a date or percentage. They do not lower one digit within a value. Subscript is a Font effect applied to selected text, not a custom number format.
  • Looking for a permanent subscript key: Excel does not provide a standard keyboard shortcut that directly toggles selected characters to subscript. Ctrl+1 opens Format Cells; you still need to select the Font tab and check Subscript.
  • Saving as CSV and expecting the styling to remain: CSV stores plain text values, not Excel’s rich-text formatting. Keep an .xlsx copy if you need the lowered characters to remain visually formatted.

Tips

  • Use a text cell for notation. If you need a label such as H2O, type it as text. If Excel interprets an entry as a number or changes it into a date, start the entry with an apostrophe to store it as text; the apostrophe itself will not show in the cell.
  • Separate appearance from calculation. Keep numeric inputs and formulas in dedicated cells, then use a separate text label for a display such as a chemical formula. This avoids relying on rich-text styling inside a calculated result and makes the workbook easier to maintain.
  • Use Unicode subscripts only when suitable. Characters such as ₂ and ₃ are distinct Unicode characters, not ordinary digits with Excel formatting. They can be convenient for fixed labels and can display in web pages or plain-text exports, but not every digit has a matching subscript character, and fonts may render them differently. They also change the stored text itself.
  • Apply the effect consistently. In technical labels, use subscript only for the intended index or notation. If several cells need similar treatment, format each text entry deliberately. Avoid assuming that copying a formula or applying a number format will create character-level subscript throughout a range.
  • Check readability and accessibility. Subscript can become hard to read in small cells or at low zoom. Widen the column, increase the font size, or add a clear text label nearby if the notation is important. Do not rely on visual position alone to communicate essential information.
  • Copy formatted text carefully. Copying a rich-text cell within Excel usually carries its formatting, but pasting into another app may keep only the text or may substitute formatting. Check the destination before assuming the subscript appearance has transferred.

Troubleshooting

The Subscript option is unavailable or has no effect. Confirm that you are using the desktop app and that you selected characters inside editable text rather than selecting a whole formula result. Enter edit mode, highlight the characters, and reopen Format Cells with Ctrl+1 on Windows or Command+1 on Mac. If the cell is calculated, create a separate text label for the display instead of trying to format part of the result.

The whole entry moved down. You probably applied the effect while the cell itself was selected, rather than while only some characters were selected. Undo, enter edit mode, highlight the precise characters, and apply Subscript again. Check the formula bar selection if the cell is too narrow.

The text appears unchanged. Make sure the Subscript box is checked on the Font tab, then select OK. Increase the zoom or font size to check; a single lowered digit can be difficult to notice. Also verify that the selected text was not overwritten when you exited edit mode. If you are in Excel for the web and cannot access the needed effect, choose Open in Desktop App and repeat the steps there.

The text looks right but changes when exported. The styling is rich-text formatting and may be dropped when you save as CSV or paste into a plain-text destination. Keep an .xlsx version for the formatted workbook. If the destination must preserve the character’s appearance as plain text, consider using an appropriate Unicode subscript character instead, and verify that it is supported by the destination font.

The shortcut opens a different window or does nothing. Click inside the text and make sure the characters remain selected, then try the Font dialog launcher on the Home tab. On Windows the dialog shortcut is Ctrl+1; on Mac it is Command+1. Laptop function-key settings can affect F2, so double-clicking the cell is a straightforward way to enter edit mode.

Frequently Asked Questions

Can I make only one number in a cell subscript?
Yes, if the cell contains editable text typed directly into Excel. Enter edit mode, select that number, and apply the Subscript effect from Format Cells. You cannot use the same method to format just part of a formula’s calculated result.

Is there a keyboard shortcut for subscript in Excel?
There is no standard direct shortcut to toggle subscript. Ctrl+1 on Windows or Command+1 on Mac opens Format Cells; then choose Font and check Subscript.

Can I subscript text in Excel for the web?
Character-level formatting options can differ in the web app. If you cannot select individual characters or find the Subscript effect, open the workbook in Excel for Windows or Mac and apply it there.

Does subscript change the value in the cell?
No. It changes the appearance of selected text, not its meaning or numeric value. For calculations, keep the underlying numbers and formulas separate from display-only notation.

Will subscript formatting remain in a CSV file?
No. CSV does not preserve Excel’s rich-text formatting. Keep an .xlsx copy for the formatted version, or use Unicode subscript characters in the text if a plain-text representation is required and the destination supports them.

How do I remove subscript?
Edit the cell, select the characters that are lowered, press Ctrl+1 on Windows or Command+1 on Mac, clear the Subscript check box on the Font tab, and select OK. If you applied it to the whole cell, select the cell and clear the effect for the full entry.

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.