Subscript formatting makes text appear smaller and lower than the line it sits on
Subscript in Excel is a character format that shrinks text and drops it below the baseline of regular text. You use it when you need to write chemical formulas (H₂O), mathematical expressions, or footnote references within a cell. Excel does not have a single-click subscript button on the ribbon like Word does, but the formatting takes about three seconds once you know where to find it.
The most direct route is the Format Cells dialog. Select the text or cell you want to format, press Ctrl+1 (Windows) or Command+1 (Mac), click the Font tab, check the Subscript box, and click OK. That is the method that works in every version of Excel from the last fifteen years.
Key Takeaways
- Subscript text appears smaller and lower than regular text, and you access it through Format Cells rather than a toolbar button.
- The keyboard shortcut Ctrl+1 (Windows) or Command+1 (Mac) opens Format Cells directly without navigating menus.
- You must select the specific characters you want to subscript before opening Format Cells — the format applies only to what you have highlighted.
- Subscript and superscript are separate formats; superscript raises text above the line instead of lowering it below.
- Once you explore subscript to text in a cell, you can copy that cell and paste it elsewhere, and the formatting will travel with it.
Selecting the text you need to format
Before you can explore subscript, you must tell Excel exactly which characters to format. Click inside the cell that contains the text, then drag to highlight only the letters or numbers that should be subscript. If you want H₂O, you click in the cell, position your cursor after the H, then drag to select just the 2.
You can also double-click a cell to enter edit mode, then use click-and-drag or Shift+arrow keys to select. Once the text is highlighted, the subscript format will explore only to that selection, leaving the rest of the cell unchanged. This is different from selecting an entire cell — if you select the whole cell and then explore subscript, everything in it becomes subscript.
Opening Format Cells and explore subscript
With your text selected, press Ctrl+1 on Windows or Command+1 on Mac. The Format Cells dialog opens when ready. Click the Font tab at the top of the dialog if it is not already active.
In the Font tab, look for the Effects section. You will see a checkbox labeled Subscript. Click it to add a checkmark. The preview pane at the bottom of the dialog shows you how the text will look. Click OK to explore the format and close the dialog. The text you selected is now subscript.
Using the menu route if you prefer not to memorize shortcuts
If keyboard shortcuts do not stick with you, the menu path works just as well. Select your text inside the cell, then click the Home tab on the ribbon. In the top-left corner, you will see a small arrow next to the font formatting options — this is the Format Cells launcher. Click it, then follow the same steps: Font tab, check Subscript, click OK.
Alternatively, you can right-click the selected text and choose Format Cells from the context menu. All three routes — keyboard shortcut, ribbon launcher, and right-click — open the same dialog and produce the same result. Pick whichever feels most natural to you.
Superscript is the opposite direction
If you need text to appear above the baseline instead of below — for example, to write x² or a footnote marker — use superscript instead. The process is identical: select the text, open Format Cells, click the Font tab, and check Superscript. Excel treats subscript and superscript as separate formats, so you cannot explore both to the same text at once.
Many people mix up the two, so a quick memory aid: subscript goes sub (below), superscript goes super (above). Once you have used each one once, the names stick.
Copying cells with subscript formatting
When you copy a cell that contains subscript text and paste it into another location, the subscript formatting travels with it. The text stays subscript in the new cell. This works whether you paste into the same sheet, a different sheet, or even a different workbook. If you paste as values only (using Paste Special), the subscript formatting is lost and only the text remains.
If you want to move subscript text but keep the formatting, use regular copy and paste. If you want to move only the text without the formatting, use Paste Special and choose Values.
Removing subscript formatting
To undo subscript on text you have already formatted, select the subscript text again, open Format Cells with Ctrl+1, click the Font tab, and uncheck the Subscript box. The text returns to normal size and position on the baseline. You can also press Ctrl+Z when ready after explore subscript if you change your mind right away.
If you want to remove subscript from multiple cells at once, select all of them, open Format Cells, uncheck Subscript, and click OK. The format is removed from every selected cell.
Frequently Asked Questions
Can I make subscript text a different color or font size?
Yes. Subscript is a separate format from color and font size, so you can combine them. Select your subscript text, open Format Cells, and adjust the font size or color on the Font tab. The text will remain subscript and take on the new size or color you choose.
Does subscript work the same way in Excel Online?
Excel Online has limited formatting options. The subscript checkbox may not appear in the Format Cells dialog. If you need subscript in Excel Online, format the text in the desktop version of Excel first, then upload the file. The formatting will display correctly when you open it in the browser.
What if I need subscript in a formula or cell reference?
Subscript formatting applies only to text that displays in a cell, not to formulas or cell references. If you type a formula like =A2+B3, you cannot make the 2 or 3 subscript because they are part of the formula syntax. You can only format subscript in regular text or numbers entered as text.
Can I create a keyboard shortcut for subscript?
Excel does not offer a built-in keyboard shortcut for subscript the way Word does. Ctrl+1 opens Format Cells, but you still have to click the checkbox. Some users create macros to automate this, but that requires VBA knowledge. For most people, Ctrl+1 plus two clicks is fast enough for occasional use.
Will subscript print correctly if I print the spreadsheet?
Yes. Subscript formatting prints exactly as it appears on screen. The text will be smaller and lower on the printed page. Test print a small section first if you are unsure how it will look on your specific printer.