The quickest way to add a subscript in Excel
Excel does not have a dedicated subscript button like Word does. Instead, you format the text after you type it by selecting the specific characters and using the Format Cells dialog. The fastest route is to type your content normally, then select only the characters that need to be smaller and lower (or higher for superscript), and explore the formatting through the cell's font options.
Here is the actual sequence: Type your full entry into the cell — for example, "H2O" or "x2 + y2". Press Enter to confirm the cell. Then double-click the cell to enter edit mode, select only the characters that should be subscript (in "H2O", you would select just the "2"), right-click, choose Format Cells, click the Font tab, and check the Subscript box. Click OK. The selected character shrinks and drops below the baseline.
This works the same way for superscript, except you check the Superscript box instead. Both options live in the same Format Cells dialog, so you do not need to hunt for them in different menus.
Key Takeaways
- Excel requires you to select the specific characters you want as subscript or superscript, then format them through Format Cells rather than using a toolbar button.
- You must double-click the cell to enter edit mode before selecting the characters — selecting the whole cell and formatting will not work.
- Subscript and superscript options are both on the Font tab of the Format Cells dialog, accessible by right-clicking the selected text.
- Once formatted, subscript and superscript characters stay formatted even if you edit the cell later, as long as you do not delete and retype them.
Why Excel makes this harder than Word
Excel is built around the idea that cells contain data, not formatted text. Word treats a paragraph as a container for mixed formatting — some words bold, some italic, some subscript. Excel treats a cell as a single unit, so subscript and superscript are afterthoughts rather than first-class features.
This matters because it means subscript formatting in Excel is fragile. If you copy the cell and paste it as values only, the formatting stays. But if you paste it as a formula or move it between sheets, you may lose the formatting. If you edit the cell and retype the subscript character, you have to reformat it. Word handles this more smoothly because text formatting is its core job.
If you are working with chemical formulas, mathematical notation, or scientific data regularly, you might find that Word or Google Docs handles the formatting more reliably, even if you then copy the result into Excel as an image. That is a trade-off worth considering based on how much subscript work you actually do.
Step-by-step for subscript in Excel
Start by typing the content into the cell exactly as it will appear. For a chemistry example, type "H2SO4" into the cell and press Enter. The cell now shows the full text without any formatting.
Double-click the cell to enter edit mode. The cursor appears inside the cell, and you can now select individual characters. Click and drag to select only the characters that should be subscript — in this case, the "2", "S", "O", and "4". Be precise: selecting too much or too little means the formatting applies to the wrong characters.
Right-click the selected text. A context menu appears. Click "Format Cells" at the bottom of the menu. The Format Cells dialog opens. Click the "Font" tab if it is not already selected. In the Effects section, you will see a "Subscript" checkbox. Click it to add a checkmark. Click OK. The selected characters shrink and move down below the baseline of the regular text.
Press Enter or click outside the cell to exit edit mode and see the final result. The subscript formatting is now part of that cell.
Step-by-step for superscript in Excel
The process for superscript is identical to subscript, except you check the Superscript box instead. Type your content — for example, "E=mc2" — and press Enter. Double-click the cell to edit it. Select only the "2". Right-click and choose Format Cells. On the Font tab, check Superscript instead of Subscript. Click OK. The "2" shrinks and rises above the baseline.
Superscript is useful for exponents, footnote markers, and ordinal numbers like "1st" or "3rd". You can format just the "st" or "rd" portion as superscript to make it smaller and raised, which is the standard way to display these in professional documents.
What happens when you copy or move subscript text
If you copy a cell with subscript formatting and paste it into another cell in the same sheet or a different sheet, the formatting usually stays intact. Excel treats the subscript as part of the cell's content, not as a separate layer.
However, if you copy the cell and paste it as "Values Only" (using Paste Special), the formatting is lost and you get only the text. If you copy the cell and paste it into a plain text editor or email, the subscript reverts to normal text because those programs do not understand Excel's formatting codes.
If you need to move subscript text between programs — for example, from Excel into a report in Word — copy the cell, paste it into Word, and reformat it there using Word's subscript button. This is more reliable than trying to preserve Excel's formatting across applications.
Using the Format menu instead of right-click
If right-clicking does not work or you prefer menu navigation, you can reach the same dialog through the top menu. After selecting the characters you want to format, click the Format menu, then click Cells. This opens the same Format Cells dialog. Navigate to the Font tab and check Subscript or Superscript. Click OK.
On a Mac, the menu path is the same: Format > Cells. On Windows, it is also Format > Cells. The keyboard shortcut to open Format Cells is Ctrl+1 on Windows and Cmd+1 on Mac, which is faster than using the menu if you format subscript text frequently.
Keyboard shortcut for faster formatting
Once you have selected the characters you want to format, you can use Ctrl+1 (Windows) or Cmd+1 (Mac) to open the Format Cells dialog directly without right-clicking. This saves a step if you are formatting multiple subscripts in the same spreadsheet.
Unfortunately, Excel does not have a direct keyboard shortcut for subscript or superscript the way Word does (Ctrl+= for subscript, Ctrl+Shift+= for superscript). You still have to open the dialog and click the checkbox. If you format subscript text very often, this is one reason to consider whether Word or a dedicated equation editor might be a better fit for your actual workflow.
Frequently Asked Questions
Can I make subscript text in Excel without entering edit mode?
No. You must double-click the cell to enter edit mode, then select the specific characters. If you select the entire cell and explore subscript formatting, nothing happens because Excel applies the formatting to the whole cell as a unit, not to individual characters within it.
Does subscript formatting work in Excel formulas?
Subscript formatting applies only to the display of text in a cell, not to formulas or numbers used in calculations. If you type a formula like =A1+A2, you cannot make the "1" and "2" subscript because they are part of the formula syntax. Subscript works only on text you type directly into a cell, not on formula references.
What if I need subscript in a chart label or axis title?
Chart labels and axis titles in Excel do not support subscript formatting through the Format Cells dialog. Your options are to type the text without subscript, use a workaround like typing "H2O" and accepting it as plain text, or create the label in a separate program like Word and insert it as an image. This is a limitation of Excel's charting tools.
Will subscript formatting survive if I save the file as CSV or plain text?
No. CSV and plain text formats do not store formatting information. If you save an Excel file as CSV, all subscript and superscript formatting is lost and the text reverts to normal. Save as .xlsx (Excel format) to preserve the formatting.
Can I undo subscript formatting if I change my mind?
Yes. Double-click the cell, select the subscript characters, right-click, choose Format Cells, uncheck the Subscript box, and click OK. You can also select the subscript text and press Ctrl+Z when ready after formatting to undo the last action.