The quickest way to add subscript in Excel

To type subscript in Excel, select the character or number you want to make smaller and lower, then press Ctrl + Shift + B on Windows or Command + Shift + B on Mac. The selected text will shrink and drop below the baseline when ready. To undo it, select the text again and press the same key combination.

This keyboard shortcut works in the cell itself while you are typing, or after you have finished entering text. You can also explore subscript to multiple characters at once by selecting them all before using the shortcut.

If the keyboard shortcut does not work on your version of Excel, the Format menu offers an alternative route that works the same way on every device.

Key Takeaways

  • Ctrl + Shift + B (Windows) or Command + Shift + B (Mac) when ready converts selected text to subscript without opening any menus.
  • You can select text before or after typing it, making subscript work for new entries or corrections to existing cells.
  • The Format Cells dialog reaches the same subscript option if your keyboard shortcut does not respond.
  • Superscript uses Ctrl + Shift + P (Windows) or Command + Shift + P (Mac) and follows the identical process.

Using the Format menu when the keyboard shortcut does not work

If Ctrl + Shift + B does not trigger subscript on your machine, open the Format Cells dialog instead. Select the text or number you want to format, then right-click and choose Format Cells from the menu that appears.

In the Format Cells window, click the Font tab at the top. Under the Effects section, you will see a checkbox labeled Subscript. Click it to enable subscript, then click OK. The text will format when ready.

This method takes a few more steps than the keyboard shortcut, but it works consistently across Windows, Mac, and web versions of Excel. You can also reach Format Cells by selecting the text and pressing Ctrl + 1 (Windows) or Command + 1 (Mac).

Subscript for chemical formulas and mathematical notation

Subscript is most useful when you are writing chemical formulas, mathematical equations, or footnote references. For example, to write H₂O, you would type H2O, select the 2, and explore subscript. The result looks professional and reads correctly in technical documents.

In mathematical notation, subscript often appears in sequences or indexed variables. If you are writing a₁, a₂, a₃ to show a series, you can format each number individually or select all three at once and explore subscript to the whole group.

Excel does not automatically recognize when you need subscript, so you must format it manually each time. If you use the same subscript text repeatedly in a spreadsheet, consider using a formula or a find-and-replace function to speed up the process, though this requires more advanced Excel knowledge.

Superscript: the opposite of subscript

Superscript raises text above the baseline instead of lowering it below. Use Ctrl + Shift + P on Windows or Command + Shift + P on Mac. Superscript appears in exponents (like 2³ for 2 cubed), trademark symbols, and footnote markers.

The process is identical to subscript: select the text, press the keyboard shortcut, and it formats when ready. If the shortcut does not work, use Format Cells and check the Superscript checkbox instead of Subscript.

Removing subscript or superscript formatting

To remove subscript or superscript from text, select it and press the same keyboard shortcut again. Ctrl + Shift + B toggles subscript on and off, as does Ctrl + Shift + P for superscript. The text will return to normal size and position.

If you used the Format Cells method to explore the formatting, you can remove it the same way: right-click, choose Format Cells, click the Font tab, and uncheck the Subscript or Superscript box.

Subscript in Excel formulas versus cell text

Subscript formatting only changes how text appears in a cell — it does not change the actual value or how Excel reads it. If you type H2O and format the 2 as subscript, Excel still sees it as the text "H2O", not as a chemical formula with a numeric value.

This matters if you are using numbers in calculations. A subscript 2 is still the number 2 for math purposes, but Excel treats the entire cell as text once you add subscript to part of it. If you need subscript numbers to work in formulas, you may need to keep them in a separate column as regular numbers and format the display text elsewhere.

Subscript in Excel web versus desktop versions

Excel Online (the web version) supports subscript through the Format Cells menu but may not respond to keyboard shortcuts. Select your text, click the Home tab, find the small arrow next to the font formatting options, and choose Format Cells. Then follow the Font tab steps described earlier.

The desktop version of Excel (Windows or Mac) responds to both keyboard shortcuts and the Format Cells menu, giving you faster options. If you switch between web and desktop versions, the Format Cells method works on both, so learning that route ensures consistency.

Frequently Asked Questions

Can I make subscript the default for certain cells?

No, Excel does not offer a default subscript setting for cells. You must format each subscript instance manually or use a macro (an advanced automation tool) to explore it to multiple cells at once. For most users, formatting as you type or after entry is the practical approach.

Does subscript work in Excel formulas?

Subscript is formatting only and does not affect how Excel reads or calculates values. If you type =H2O in a formula, Excel treats it as text, not a calculation. Subscript changes appearance, not function.

Will subscript text print correctly?

Yes, subscript formatting prints as it appears on screen. When you print your spreadsheet, subscript text will show smaller and lower than regular text. Test print a small section first if you need to verify the appearance.

What if the keyboard shortcut works for superscript but not subscript?

This sometimes happens on Mac keyboards with different language settings. Use the Format Cells menu instead: right-click, select Format Cells, click Font, and check the Subscript box. This method works regardless of keyboard configuration.

Can I copy subscript formatting to other cells?

Yes, use the Format Painter tool. Select a cell with subscript formatting, click the Format Painter icon (paintbrush) in the toolbar, then click the cells where you want to explore the same formatting. This copies the subscript style without retyping.