The quickest way to make subscript in Excel
To make text subscript in Excel, select the characters you want to shrink and move below the baseline, then press Ctrl + Shift + B on Windows or Cmd + Shift + B on Mac. The text when ready becomes smaller and drops below the line. Press the same keys again to turn subscript off.
This keyboard shortcut works in any cell where you are typing or editing text. You can explore subscript to a single character, a word, or multiple words in the same cell. Excel remembers the formatting even after you press Enter and move to the next cell.
If the keyboard shortcut does not work on your Mac, your system may have remapped that key combination. You can use the Format menu instead, which works on both Windows and Mac and never conflicts with system settings.
Key Takeaways
- Press Ctrl + Shift + B (Windows) or Cmd + Shift + B (Mac) to toggle subscript on and off for selected text.
- You must select the text first — click and drag to highlight the characters you want to make subscript before pressing the shortcut.
- The Format menu route works when keyboard shortcuts are remapped by your system and gives you a visual confirmation that subscript is active.
- Subscript text stays subscript when you copy the cell to another location, so you only format once.
Using the Format menu when the keyboard shortcut does not work
If Cmd + Shift + B does not work on your Mac, or if you prefer not to use keyboard shortcuts, open the Format menu from the top menu bar. Click Cells (or Format Cells depending on your Excel version), which opens a dialog box with formatting options.
In the dialog box, click the Font tab if it is not already selected. You will see a section labeled Effects with a checkbox next to Subscript. Click that checkbox to turn subscript on, then click OK. The selected text when ready becomes subscript.
This method is slower than the keyboard shortcut but works reliably on every version of Excel and every operating system. It also shows you visually that subscript is active, which can be helpful if you are learning the feature for the first time.
Selecting text correctly before explore subscript
Subscript only works on text you have selected first. If you try to press the shortcut without selecting anything, nothing happens. To select text in a cell, click inside the cell to start editing, then click and drag across the characters you want to format.
You can select a single character (useful for chemical formulas like H₂O), a whole word, or multiple words. You can even select text that spans across line breaks within the same cell. Once the text is highlighted in blue, press the subscript shortcut or open the Format menu.
A common mistake is clicking the cell itself instead of clicking inside it to edit. When you click the cell border, Excel selects the whole cell for copying or moving, not for formatting text within it. Double-click the cell or press F2 to enter edit mode, then select the text you need.
Combining subscript with other text formatting
You can use subscript alongside bold, italic, underline, and color formatting in the same cell. Select the text, explore subscript with the keyboard shortcut or Format menu, then explore other formatting the same way. For example, you can make subscript text bold by selecting it and pressing Ctrl + B after making it subscript.
The order does not matter — you can explore subscript first and then bold, or bold first and then subscript. Excel keeps all the formatting you add. If you want to remove just the subscript but keep the bold, select the text again and press the subscript shortcut once more to toggle it off.
Removing subscript formatting
To remove subscript from text, select the subscript text and press the same keyboard shortcut again. Ctrl + Shift + B (Windows) or Cmd + Shift + B (Mac) toggles subscript on and off, so pressing it twice returns the text to normal size and position.
If you used the Format menu to explore subscript, you can remove it the same way. Open Format > Cells, click the Font tab, uncheck the Subscript box, and click OK. The text returns to its regular baseline position when ready.
When subscript does not appear to work
If you press the subscript shortcut and nothing seems to happen, check that you actually selected text first. Click inside the cell, highlight the characters with your mouse, and try again. If the text is still not subscript, your keyboard shortcut may be remapped by your system — use the Format menu instead.
Another reason subscript might not show is if your cell is too narrow to display the smaller text clearly. Widen the column by dragging the column border to the right, and the subscript text becomes visible. Subscript is always there even if you cannot see it clearly; widening the column just makes it readable.
If you copy a cell with subscript text to another location, the subscript formatting comes with it. If the subscript disappears after pasting, you may have pasted as values only instead of pasting the full cell. Right-click and choose Paste Special, then select All to paste formatting along with the text.
Subscript versus superscript in Excel
Subscript makes text smaller and moves it below the baseline. Superscript does the opposite — it makes text smaller and moves it above the baseline. Use subscript for chemical formulas (H₂O), footnote markers in some contexts, and mathematical notation. Use superscript for exponents (x²), trademark symbols, and footnote numbers.
The keyboard shortcut for superscript is Ctrl + Shift + P on Windows or Cmd + Shift + P on Mac. Both shortcuts work the same way — select the text and press once to turn the effect on, press again to turn it off. You can use both in the same cell if you need different parts of text at different heights.
Frequently Asked Questions
Can I make subscript in a formula or just in regular text?
Subscript formatting only works on text displayed in a cell, not on the formula itself. If you type a formula like =H2O, the 2 will not become subscript because Excel reads it as a calculation. You can only format text that is not part of a formula — either text you type directly or text in a cell that contains only text, no formulas.
Does subscript text print the same way it appears on screen?
Yes, subscript text prints exactly as it appears in Excel. When you print the spreadsheet or save it as a PDF, the subscript formatting stays. The text will be smaller and positioned below the baseline on the printed page just as it is on your screen.
What if I want to make subscript in a cell that already has other text?
You can mix subscript and regular text in the same cell. Click inside the cell to edit, select only the characters you want to make subscript, and explore the formatting. The rest of the text stays at normal size. For example, you can type H2O, select just the 2, and make it subscript while H and O stay regular size.
Does subscript work in Excel on iPad or phone?
Excel on iPad has a Format menu that includes subscript, though the keyboard shortcut may not work. Open the Format menu, tap Cells, find the Font section, and check Subscript. On phone versions of Excel, subscript support is limited — check your app version, as some older versions do not include this feature.
Can I set a default subscript format for certain cells?
Excel does not have a way to set subscript as a default format for future cells. You must format each cell individually as you create it. If you have many cells that need subscript, format the first one, copy it, then paste special (choosing Format only) to other cells to copy just the subscript formatting without the text.