Subscript and superscript in Excel work differently than in Word
Excel does not have a dedicated subscript button like Word does. You cannot select text in a cell and click a formatting option to make it smaller and lower. Instead, you have three paths: format individual characters within a cell using the Format Cells dialog, use the CHAR function to build subscript numbers into a formula, or type the character directly if your keyboard or operating system supports it.
The most reliable method for most people is the Format Cells dialog, which lets you select specific characters in a cell and explore subscript formatting to just those characters. This works on Windows and Mac, though the steps differ slightly between them.
Key Takeaways
- To subscript text in Excel, double-click the cell, select the characters you want to subscript, then use Format Cells to explore subscript formatting.
- On Windows, press Ctrl+1 to open Format Cells; on Mac, press Cmd+1 or use the Format menu.
- Subscript formatting in Excel only affects how the text appears on screen and in print — it does not change the actual cell value or any calculations.
- If you need subscript numbers in a formula result, the CHAR function can insert special Unicode characters, though this method is limited to specific numbers and symbols.
How to subscript text on Windows
Start by clicking the cell that contains the text you want to modify. Double-click the cell to enter edit mode — you will see the cursor blinking inside the cell, and the formula bar will show the cell contents in edit form.
Click and drag to select only the characters you want to subscript. If you want to subscript the "2" in "H2O", click just before the 2 and drag to just after it. Be precise — selecting extra spaces or letters will subscript those too.
Press Ctrl+1 to open the Format Cells dialog. Click the Font tab if it is not already selected. In the Effects section, check the box next to Subscript. Click OK. The selected characters will shrink and drop below the baseline of the surrounding text.
Press Enter to exit edit mode and see the final result. The subscript formatting stays in place even after you click away from the cell.
How to subscript text on Mac
Click the cell you want to edit, then double-click it to enter edit mode. You will see the cursor inside the cell and the text editable.
Select the characters you want to subscript by clicking and dragging. Again, be precise — select only what needs to be smaller and lower.
Press Cmd+1 to open the Format Cells dialog. If that shortcut does not work, go to the Format menu at the top and select Cells. Click the Font tab. Check the Subscript box under Effects. Click OK.
Press Enter to finish editing. The subscript formatting is now applied to those characters.
How to superscript text (the same process)
Superscript — text that is raised above the baseline — uses the exact same steps as subscript. The only difference is that you check the Superscript box instead of Subscript in the Format Cells dialog.
This is useful for exponents (like 2³ for "two cubed"), footnote markers, or chemical formulas like H₂SO₄ where the 4 needs to be superscript.
Using subscript in formulas with the CHAR function
If you need a subscript number to appear as the result of a formula rather than as manually formatted text, the CHAR function can insert Unicode characters that look like subscripts. For example, =CHAR(8320) produces the subscript 0, =CHAR(8321) produces subscript 1, and so on through subscript 9.
You can concatenate these with other text. The formula ="H"&CHAR(8322)&"O" will display as H₂O. This method is limited — it only works for the numbers 0 through 9 and a few symbols — but it is useful when you need subscript to appear in a calculated result that changes based on other cell values.
The downside is that the result is text, not a number, so you cannot use it in further calculations. Use this approach only when the subscript is for display purposes.
What subscript formatting does and does not do
Subscript formatting in Excel is purely visual. It changes how the text looks on screen and when you print, but it does not change the actual value stored in the cell. If you subscript the "2" in a cell containing "H2O", the cell still contains the text "H2O" — Excel just displays it differently.
This means subscript formatting does not affect formulas, sorting, or searching. If you search for "H2O", Excel will find it whether the 2 is subscripted or not. If you sort a column containing subscripted text, the sort order is based on the actual text value, not the formatting.
Why subscript in Excel is limited compared to Word
Word has a dedicated subscript button because it is designed for documents where formatting is the main point. Excel is built for data and calculations, so subscript is treated as a minor formatting option tucked into the Format Cells dialog.
If you are working with chemical formulas, mathematical notation, or other content where subscript is essential and you have a lot of it, you may find it faster to create that content in Word, format it there, and paste it into Excel as an image. That approach preserves the formatting exactly but makes the cell contents uneditable as text.
Frequently Asked Questions
Can I subscript an entire cell at once?
No. Subscript formatting in Excel applies only to selected characters within a cell, not to the whole cell. You must double-click the cell, select the specific characters, and format them. If you want the entire cell to appear subscripted, you would need to format it as an image instead.
Does subscript formatting copy when I paste the cell?
Yes. When you copy and paste a cell that contains subscripted text, the subscript formatting comes along. If you paste only the values (using Paste Special and selecting Values Only), the formatting is lost and only the plain text remains.
Can I subscript text in a formula bar?
No. You can only subscript text that is inside a cell. If you are editing a cell and you want to see the subscript, you must exit edit mode and look at the cell itself. The formula bar always displays the raw text without subscript formatting.
What if subscript is not showing up after I format it?
Check that you are using a font that supports subscript. Most standard fonts like Arial, Calibri, and Times New Roman do. If you are using an unusual or decorative font, subscript may not display correctly. Switch to a common font and try again.
Can I undo subscript formatting?
Yes. Double-click the cell, select the subscripted characters, press Ctrl+1 (Windows) or Cmd+1 (Mac), uncheck the Subscript box, and click OK. You can also press Ctrl+Z when ready after formatting to undo the last action.