Subscript formatting makes text appear smaller and lower than the baseline

In Excel, subscript is a formatting option that shrinks text and positions it below the line of regular text. It's useful for chemical formulas (H₂O), mathematical notation, footnote references, or any situation where you need smaller text positioned lower. Excel does not have a single-click subscript button in the main toolbar, but the feature is accessible through the Format menu or a keyboard shortcut.

The process takes seconds once you know where to find it. You select the text you want to format, then use either the Format Cells dialog or a keyboard combination to apply subscript. The formatting stays with that text even if you edit the cell later.

Key Takeaways

  • Select the specific characters you want as subscript by clicking and dragging within the cell or formula bar, not the entire cell.
  • Press Ctrl+= (Windows) or Cmd+= (Mac) to apply subscript formatting to selected text.
  • You can also reach subscript through Format > Cells > Font tab > Effects section and check the Subscript box.
  • Subscript formatting works in cell content, formulas, and text within cells, but the text size and position are controlled by Excel's default subscript settings.

Using the keyboard shortcut for subscript

The fastest way to apply subscript is the keyboard shortcut. On Windows, select the text you want to format and press Ctrl+= (Ctrl and the equals sign). On Mac, use Cmd+= (Command and the equals sign). The text immediately shrinks and drops below the baseline.

To undo subscript formatting, select the text again and press the same shortcut a second time. The text returns to normal size and position. This toggle behavior means you can apply and remove subscript without opening any menus.

Selecting text within a cell for subscript

The key step most people miss is selecting only the characters you want as subscript, not the entire cell. If you click a cell and press Ctrl+=, nothing happens because Excel needs you to specify which characters to format.

Double-click the cell to enter edit mode, then click and drag to highlight only the characters that should be subscript. For example, in the cell "H2O", you would select only the "2". Once those characters are highlighted, press Ctrl+= to apply subscript formatting. The "2" shrinks and moves below the line while "H" and "O" stay normal.

You can also select text in the formula bar at the top of the screen. Click in the formula bar, highlight the characters you need, and press Ctrl+=. This method works the same way as editing within the cell.

Using the Format Cells dialog

If the keyboard shortcut does not work on your computer or you prefer using menus, the Format Cells dialog offers the same subscript option. Select the text within the cell (using the method described above), then right-click and choose Format Cells from the menu.

In the Format Cells dialog, click the Font tab. In the Effects section, you will see a checkbox labeled Subscript. Check that box and click OK. The selected text becomes subscript. To remove subscript later, open Format Cells again, uncheck the Subscript box, and click OK.

On Mac, the menu path is slightly different. Select the text, then go to Format > Cells in the menu bar. The Font tab and Subscript checkbox are in the same location.

Subscript in formulas and cell references

Subscript formatting works in formulas and cell references, but it is purely visual—it does not change how Excel calculates or reads the formula. If you type a formula like =A1+B2 and make the "1" and "2" subscript, the formula still works exactly the same way. The subscript is only how it appears on screen.

This is useful when you are documenting a spreadsheet and want mathematical notation to look professional. You can format variable names or reference numbers as subscript to match standard mathematical writing, while the underlying formulas remain unchanged.

Superscript as an alternative

Excel also offers superscript formatting, which raises text above the baseline instead of lowering it. Superscript is useful for exponents (x²), ordinal numbers (1st, 2nd), or trademark symbols. The process is identical to subscript: select the text and press Ctrl+Shift+= (Windows) or Cmd+Shift+= (Mac). You can also use Format Cells and check the Superscript box instead of Subscript.

Some spreadsheets use both subscript and superscript in the same document. For example, a chemistry spreadsheet might show H₂SO₄ with subscript numbers and a physics spreadsheet might show E=mc² with a superscript 2. Each is applied the same way to different text within the same cell.

Troubleshooting subscript that does not appear

If you apply subscript formatting and the text does not look smaller or lower, check whether you actually selected the text before pressing the shortcut. A common mistake is clicking the cell and pressing Ctrl+= without entering edit mode first. The shortcut only works when you have highlighted specific characters.

Another reason subscript might not be visible is font size. If the cell text is very small already, subscript text becomes nearly invisible. Try increasing the overall cell font size first, then applying subscript to see the effect more clearly. You can also check the Format Cells dialog to confirm the Subscript checkbox is actually checked.

If you are working in a shared spreadsheet or a file that has been edited in multiple programs, some formatting may not transfer correctly. Reapplying subscript formatting usually fixes this. Select the text again and press Ctrl+= to ensure the formatting is active in your current version of Excel.

Frequently Asked Questions

Can I make subscript text a different size than Excel's default?

Excel controls subscript size automatically based on the cell font size, and you cannot adjust it independently. If you need subscript text to be larger or smaller, change the overall cell font size first, then apply subscript. Some users create subscript manually by typing smaller text in a separate cell or using special Unicode characters, but standard subscript formatting does not offer size control.

Does subscript formatting work in all versions of Excel?

Subscript is available in Excel for Windows, Excel for Mac, and Excel Online. The keyboard shortcuts and menu paths are the same across versions. If you are using a very old version of Excel (pre-2007), the menu structure may differ slightly, but the Format Cells dialog still contains the subscript option.

Will subscript formatting print correctly?

Yes. Subscript text prints exactly as it appears on screen. When you print the spreadsheet or save it as a PDF, subscript formatting is preserved. The text remains smaller and positioned below the baseline in the printed output.

Can I apply subscript to an entire column or row at once?

No. Subscript formatting must be applied to specific characters within cells, not to whole columns or rows. You select the text character by character and apply the formatting. If you need subscript in many cells, you can copy a cell with subscript formatting and paste it into other cells, but the text itself must be selected individually.

What is the difference between subscript and just making text smaller?

Subscript not only shrinks the text but also positions it below the baseline of regular text. If you only make text smaller without subscript, it stays on the same line as regular text. Subscript moves it down, which is why it looks correct for chemical formulas and mathematical notation.