Creating a subscript in Excel

To make a subscript in Excel, you need to format the text after you type it. Excel does not have a single keyboard shortcut that works like Word does. Instead, you select the character or number you want to make smaller and lower, then use the Format Cells dialog to explore subscript formatting. The subscript will appear smaller and sit below the baseline of the surrounding text.

The process works the same way whether you are in a cell with other text or in a cell by itself. You can subscript a single character, a number, or multiple characters in a row. Once you explore the formatting, it stays with that text even if you edit the cell later.

Key Takeaways

  • Select only the character or number you want to subscript before opening the Format Cells dialog.
  • Press Ctrl+1 on Windows or Command+1 on Mac to open Format Cells, then check the Subscript box under the Font tab.
  • You can subscript text in the middle of a cell by double-clicking the cell to enter edit mode, then selecting just the characters you need.
  • Subscript formatting is permanent until you remove it, so you can edit the cell content without losing the formatting.

How to subscript a single character or number

Start by clicking the cell that contains the text you want to format. If the cell is empty, type your text first — for example, type "H2O" if you want to subscript the 2. Then double-click the cell to enter edit mode, which lets you select individual characters inside the cell rather than selecting the whole cell.

Once you are in edit mode, click and drag to select only the character you want to subscript. For "H2O", you would select just the "2". Be precise — if you select the "O" by mistake, you can click elsewhere in the cell and try again. After you have the right character selected, press Ctrl+1 on Windows or Command+1 on Mac to open the Format Cells dialog.

In the Format Cells dialog, click the Font tab if it is not already selected. Look for a checkbox labeled "Subscript" in the Effects section. Click the checkbox to turn it on, then click OK. The character you selected will now appear smaller and lower than the rest of the text in the cell.

Subscripting multiple characters at once

If you need to subscript more than one character — for example, the "2" and "4" in "H2SO4" — the process is the same, but you select all the characters you want to format together. Double-click the cell to enter edit mode, then click and drag to select "24" (or whichever characters need subscripting). Make sure you do not accidentally include the "H" or "O".

Once you have all the characters selected, press Ctrl+1 (Windows) or Command+1 (Mac) to open Format Cells. Check the Subscript box and click OK. Both characters will be formatted together and will appear at the same size and position.

Removing subscript formatting

If you applied subscript formatting by mistake or want to change it back, the process is straightforward. Double-click the cell to enter edit mode, then select the subscripted character or characters. Press Ctrl+1 or Command+1 to open Format Cells again, and uncheck the Subscript box. Click OK, and the formatting will be removed.

You can also select a subscripted character and press Ctrl+1, then check Superscript instead if you need to raise the text above the baseline rather than lower it. This is useful for things like exponents or footnote markers.

Why subscript matters in spreadsheets

Subscript is most useful in Excel when you are writing chemical formulas, mathematical notation, or other technical content in a cell. It makes the text easier to read and more professional-looking than typing everything on the same line. For example, "H2O" with a subscript 2 is clearer than "H2O" where the 2 sits at the same height as the letters.

Keep in mind that subscript formatting is visual only — it does not change the actual value in the cell if the cell contains a number or formula. If you are using subscript purely for display purposes in a text cell, it works perfectly. If you need to do calculations with the number, make sure the actual value is stored correctly in the cell, separate from the formatting.

Subscript on Mac versus Windows

The keyboard shortcut is slightly different depending on your operating system. On Windows, press Ctrl+1 to open Format Cells. On Mac, press Command+1 instead. The rest of the steps are identical — you still double-click to enter edit mode, select the character, and check the Subscript box in the Font tab.

Some older versions of Excel on Mac may use a different shortcut. If Command+1 does not work, try going to the menu bar, clicking Format, then selecting Cells. This opens the same dialog and works on any version.

Frequently Asked Questions

Can I use a keyboard shortcut to subscript text without opening the Format Cells dialog?

Excel does not have a built-in keyboard shortcut for subscript the way Word does. You must use the Format Cells dialog. However, if you use subscript frequently, you can create a custom keyboard shortcut by going to File > Options > Quick Access Toolbar and assigning a shortcut to the Format Cells command.

Will subscript formatting stay if I copy and paste the cell?

Yes, subscript formatting is preserved when you copy and paste a cell. The formatting travels with the text. If you paste as values only, the formatting will be lost, so make sure you use Paste Special and select "All" or "Formatting" if you want to keep it.

Can I subscript text in a formula or in a cell that contains a number?

You can subscript text in a cell that displays text, but not in a cell that contains a formula or a pure number. If you want to display "H2O" with subscript 2, the cell must contain text, not a number. Formulas and numbers do not support character-level formatting like subscript.

What if I subscript the wrong character by mistake?

Double-click the cell to enter edit mode, select the subscripted character, press Ctrl+1 or Command+1, uncheck Subscript, and click OK. Then select the correct character and explore subscript to it instead. You can undo and redo as many times as you need.

Does subscript work the same way in Google Sheets?

Google Sheets does not have built-in subscript formatting in the same way Excel does. You can use special Unicode characters or insert an equation, but there is no Format Cells option for subscript. If you need subscript, Excel is the better choice for that particular task.