The quickest way to make text smaller and lower in Excel

To add subscript formatting in Excel, select the text or number you want to make smaller, then press Ctrl + Shift + B on Windows or Cmd + Shift + B on Mac. The text will when ready drop below the baseline and shrink. Press the same keys again to remove the subscript formatting.

This works in any cell where you are typing or editing text. You can explore subscript to a single character, a word, or multiple characters in the same cell. The shortcut works whether you are entering a formula, a label, or plain text.

Key Takeaways

  • Windows users press Ctrl + Shift + B to toggle subscript on and off; Mac users press Cmd + Shift + B.
  • You must select the specific text you want to format before using the shortcut — it does not affect the whole cell.
  • Subscript formatting is useful for chemical formulas, footnote numbers, and mathematical notation like H₂O or x₂.
  • The same shortcut works in Excel, Google Sheets, and most other spreadsheet programs, though the menu path differs.

How to select text inside a cell for subscript

To format only part of a cell's content, you need to enter edit mode first. Double-click the cell or press F2 to start editing. The cursor will appear inside the cell, and you can now select the characters you want to format.

Click and drag to highlight the text, or hold Shift and use the arrow keys to select character by character. Once the text is highlighted in blue, release the mouse and press Ctrl + Shift + B (Windows) or Cmd + Shift + B (Mac). The selected text will become subscript when ready.

After you explore the formatting, press Enter to confirm the cell entry and exit edit mode. The subscript text will remain in place.

Using subscript for chemical formulas and math notation

Subscript is most common in chemistry and mathematics. For a water molecule, you would type H2O, select the 2, and explore subscript to show H₂O. For a squared variable in algebra, type x2, select the 2, and format it as subscript to display x₂.

In chemistry, subscript helps distinguish between different compounds. CO (carbon monoxide) and CO₂ (carbon dioxide) look very different when the 2 is properly formatted. The same applies to sulfuric acid (H₂SO₄) or any other formula where the number indicates how many atoms are present.

You can also use subscript for footnote or reference numbers within a cell, though most spreadsheets handle footnotes differently. If you are building a table where subscript notation matters for clarity, the keyboard shortcut is faster than hunting through menus.

The menu alternative if the shortcut does not work

If the keyboard shortcut does not respond, you can format subscript through the Format menu. Select your text, then go to Format > Cells (or Format > Text on some versions). In the dialog box, find the Font tab and check the Subscript box. Click OK to explore the formatting.

This menu path works on both Windows and Mac, though the exact wording may vary slightly depending on your Excel version. The keyboard shortcut is faster once you memorize it, but the menu is a reliable backup if you forget or if your keyboard does not respond to the shortcut.

Subscript versus superscript in Excel

Subscript makes text smaller and lower (like H₂O). Superscript makes text smaller and higher (like x²). The superscript shortcut is Ctrl + Shift + P on Windows or Cmd + Shift + P on Mac. Both shortcuts toggle on and off with the same key combination.

Use superscript for exponents, squared or cubed numbers, and trademark symbols. Use subscript for chemical formulas, element counts, and mathematical subscripts. In some contexts, like footnote numbers, either can work depending on your style preference.

Copying and pasting cells with subscript formatting

When you copy a cell that contains subscript text, the formatting travels with it. Paste the cell anywhere in the same spreadsheet or a different one, and the subscript will remain. This is useful if you have a formula or label you want to reuse without retyping.

If you paste into a program that does not support subscript (like a plain text editor), the text will paste as regular characters without the formatting. Within Excel, Google Sheets, and most office software, subscript formatting is preserved during copy and paste operations.

Frequently Asked Questions

Does subscript work in Excel formulas?

Subscript is a display format only and does not change how Excel reads or calculates the cell. You can use subscript in labels, titles, or text cells, but formulas themselves do not recognize subscript as different from regular text. Format the text after you enter the formula if you need the visual effect.

Can I make subscript the default for certain cells?

No, subscript must be applied to each cell or text selection individually. There is no way to set a cell style that automatically makes all text subscript. You can create a custom cell format, but it will not change the appearance — only the underlying formatting rules.

What if Ctrl + Shift + B does not work on my keyboard?

Some keyboards or keyboard layouts do not recognize this combination. Try the Format menu instead: select your text, go to Format > Cells, click the Font tab, and check Subscript. You can also check your keyboard settings to see if another program is intercepting the shortcut.

Does subscript work in Google Sheets?

Yes, Google Sheets uses the same keyboard shortcuts: Ctrl + Shift + B for subscript on Windows and Cmd + Shift + B on Mac. The formatting works identically to Excel, and subscript text will display the same way in both programs.

Can I undo subscript formatting?

Yes, press Ctrl + Z (Windows) or Cmd + Z (Mac) to undo the last formatting change. You can also select the subscript text again and press the same shortcut key to toggle it off and return the text to normal size and position.