How to Type Subscript in Excel: Every Method That Actually Works

Subscript in Excel is one of those tiny formatting tricks that feels easy until you actually need it. You type H2O for a chemistry worksheet, stare at the screen, and realise the 2 is sitting there at full size — not the tucked-under little number you wanted. Word does it in two clicks. Why does Excel make you work for it? The short answer: Excel treats text inside a cell as plain data first, formatting second. That changes how you apply subscript, where you click, and which shortcuts actually work.

If you write chemical formulas, footnotes, isotope notation, or math like x₁ + x₂, you need a method you can repeat without thinking. This guide walks through every reliable way to type subscript in Excel — the built-in Format Cells dialog, a one-click Quick Access Toolbar button, the Equation editor for true mathematical notation, Unicode subscript characters, and the strange edge cases that trip people up when they copy-paste between Word and Excel. You will leave knowing which method fits your situation and which keyboard shortcut you should add to muscle memory.

Quick reality check before we start. Excel has no single global keyboard shortcut for subscript the way Word has Ctrl+= built in. Microsoft added Ctrl+Shift+F5 and a Quick Access Toolbar button in Excel 365 and Excel 2019, but earlier versions still rely on the Format Cells dialog. So the method you pick depends partly on which version you run — we will flag that as we go.

Here is the thing nobody tells you. In Excel, formatting like bold, italic, or subscript can only be applied to text inside a cell — never to numbers being used as numbers, and never to the result of a formula. If your cell contains =SUM(A1:A10), you cannot subscript part of the result. The workaround is to convert numbers to text when you need formatting, or to live with the limitation. This is the single biggest source of frustration for new Excel users trying to format scientific notation.

What you can do: select individual characters inside a text cell and format them differently from the rest. So in a cell containing the text H2O, you double-click the cell to enter edit mode, highlight just the 2, and apply subscript. The 2 shrinks and drops. The H and O stay normal. That selective formatting is the foundation of every method below.

One more quirk worth knowing. Once you have applied subscript inside a cell, the formatting belongs to that cell's display layer — it does not carry over if you reference the cell in a formula. Type =A1 in another cell and you get H2O without the subscript. For most worksheets that is fine. For scientific reports being pulled across sheets, you may need to copy and paste-special as values to preserve the look.

Method one is the Format Cells dialog. It is the most reliable route because it works in every version of Excel ever shipped with the Subscript checkbox — Excel 2007, 2010, 2013, 2016, 2019, 2021, 365, and the Mac equivalents. Click into the cell that holds your text. Double-click to enter edit mode, or press F2. Drag to highlight the specific character you want to lower — say, the 2 in H2O. Then press Ctrl+1 (the universal shortcut for Format Cells), or right-click and choose Format Cells from the menu.

The Format Cells dialog opens. You will be on the Number tab by default — that is not what you need. Click the Font tab at the top of the dialog. Look for the Effects section near the bottom: three checkboxes for Strikethrough, Superscript, and Subscript. Tick Subscript. Click OK. Your highlighted character shrinks and drops below the baseline. Press Enter to commit the cell edit.

That sequence — F2, highlight, Ctrl+1, Font tab, Subscript, OK, Enter — is what every Excel power user has burned into muscle memory. It takes about three seconds once you have done it twenty times. If you only need subscript occasionally, that is plenty fast. If you need it constantly, the next method cuts it down to one click.

Method two — the Quick Access Toolbar — is the upgrade you give yourself when you realise you have opened Format Cells fifty times this week. The QAT is that tiny strip of icons sitting above (or below) the ribbon at the top of Excel. By default it shows Save, Undo, and Redo. You can add anything to it, including the Subscript command. Once it is there, applying subscript is a single click.

Adding the button takes thirty seconds. Click the small down-arrow at the right end of the QAT (it says "Customize Quick Access Toolbar" on hover). Choose More Commands. In the dialog, change the Choose commands from dropdown to All Commands. Scroll down — they are alphabetical — until you find Subscript. Click Add. Click OK. A new Subscript icon (looks like X with a tiny 2 below) now lives on your QAT.

Workflow becomes: F2 to edit the cell, drag-select the character, click the QAT subscript button, Enter to commit. You can also assign keyboard shortcuts to QAT buttons by their position — Alt+1 hits the first QAT button, Alt+2 the second, and so on. Put Subscript in position 4 and you have Alt+4 as your shortcut. Power-user move.

While you are in there, add the Superscript button too. You will need it for footnotes, exponents, ordinal numbers (1^st, 2^nd), and citations. The two commands sit right next to each other in the All Commands list. Adding both takes the same thirty seconds.

Method three — the Equation editor — is the right choice when you need real mathematical typography rather than cell-level formatting. Think x² + 2x + 1 in the middle of a chart caption, or a chemical equation with subscripts, superscripts, and arrows all in one block. Equation editor in Excel works the same way it does in Word: it inserts a floating equation object on top of the worksheet, separate from any cell.

Go to Insert on the ribbon. On the right side you will see Symbols, and inside that, Equation. Click it. Excel inserts a small dotted-bordered equation box wherever your cursor sat. The ribbon switches to a special Equation design tab full of structures: fractions, scripts, radicals, integrals, large operators, brackets, functions, accents, limits and logs, operators, and matrix. The Script group is where you find subscript, superscript, and combined sub-and-superscript templates.

Click the Script dropdown. Pick the first template — it shows a small box with another box subscripted below it. The equation box now shows two placeholders. Type your base character in the larger box, click into the smaller box, type your subscript. Click outside the equation when finished. The drawback: equation objects float on the worksheet rather than living inside cells. They do not sort, filter, or get referenced by formulas. They are visual annotations.

Use the equation editor when you are building reports, dashboards, or training material where mathematical clarity matters more than data manipulation. For straight worksheet labels — H₂O in a list of compounds — stick with the Format Cells approach.

Method four — Unicode subscript characters — is the trick for situations where formatting will not survive. File names, JSON exports, CSV files, and pivot table field names all strip out formatting. If you label a chart series "H₂O" using Format Cells subscript, the chart legend shows H2O — flat. Same problem if you export the workbook to CSV. The fix is to use actual Unicode characters that look like subscripts but are their own letters underneath the hood.

The basic Unicode subscript digits are ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ — that is zero through nine in subscript form. There are also subscript letters for a few characters: ₐ (a), ₑ (e), ₒ (o), ₓ (x), ₕ (h), ₖ (k), ₗ (l), ₘ (m), ₙ (n), ₚ (p), ₛ (s), ₜ (t). Unfortunately, common letters like b, c, d, f, g, q, w, y, z have no subscript Unicode equivalents. That is why this method works for chemical formulas (H₂O, CO₂, C₆H₁₂O₆) but breaks down for general mathematical notation.

Easiest way to insert them: copy from this article and paste into your cell. Or use Insert > Symbol on the ribbon, change the Subset to "Superscripts and Subscripts", and pick the character you need. Some keyboards on Windows let you type Alt+8322 (the Unicode codepoint for subscript 2, 2082 in hex = 8322 decimal) using the numeric keypad — niche but useful for hardcore typists.

The advantage of Unicode is that the character survives everywhere. Copy it to Word, paste it back to Excel, export to PDF, save as CSV, share on Slack — H₂O stays H₂O. The disadvantage is the limited character set. You will not write Einstein's field equations with Unicode subscripts.

Now for the part that wastes more time than the actual formatting: copy-pasting subscript between Excel and other apps. Most people assume it should just work. It mostly does, with a handful of caveats that catch you out at exactly the worst moment.

Excel to Word: pastes cleanly. The subscript formatting transfers because Word and Excel share the same Office formatting model. You can paste as rich text or embed the table — either way the subscript survives. Word to Excel: also works, with a quirk — Word subscript characters paste into Excel as character-level formatted text. If you paste into a cell that already had subscript applied, you can get nested formatting that displays oddly. Best practice: paste into an empty cell first, then move it where you need it.

Excel to PowerPoint: pastes correctly as a picture or as embedded text. If you paste as text, you may lose the subscript depending on the paste option you choose (Match Destination Formatting strips it). Use Keep Source Formatting to preserve subscript. Excel to email (Outlook): pastes correctly into HTML emails. Plain-text emails strip the formatting completely.

Excel to Google Sheets: tricky. Google Sheets supports subscript via Format > Text > Subscript, but the rendering differs slightly from Excel. Copy-pasting between the two often works but occasionally garbles the formatting. Safer to use Unicode characters when working across the two platforms. Excel to a web form or database: never works — those destinations are plain text and strip every formatting layer.

If chemistry, physics, or engineering is your daily worksheet content, build yourself a small reference template. Create a workbook with the common formulas you reuse: H₂O, CO₂, NaHCO₃, C₆H₁₂O₆, H₂SO₄, NH₃, NaCl, CaCO₃. Each in its own cell with subscript already applied. When you need one in a new workbook, copy-paste from the template. Saves you the highlighting dance every time.

For isotope notation in physics — say uranium-235 written as ²³⁵U or carbon-14 as ¹⁴C — you need both superscript and subscript on the same letter. The trick is to apply them to separate characters and let them stack visually. Type 235U, highlight the 235, apply superscript via Format Cells. For full isotope notation like ₆¹²C (subscript proton number plus superscript mass number), you usually want Unicode or the Equation editor.

For variable indexing in math worksheets — x₁, x₂, x₃ as column headers — the Format Cells approach is cleanest. Type each header, highlight the digit, apply subscript. If you have twenty of them, build them once and use Excel's series fill to extend the pattern. The formatting carries over to the auto-filled cells.

A final practical tip. When you share workbooks with colleagues who may not realise the formatting is there, add a comment to one cell explaining that subscript is used for chemical notation. Otherwise, anyone who pastes the data into a different system and loses the formatting will report it as an error. Documentation prevents support tickets.

Wrapping up. The four methods cover every realistic situation. Format Cells (Ctrl+1, Font tab, Subscript) is the workhorse — universal, reliable, free. Quick Access Toolbar makes it one click for daily users. Equation editor handles real mathematical typography. Unicode characters survive exports and rough handling. Pick the one that matches what you are doing, then commit it to muscle memory.

Subscript looks like a minor formatting feature until you need it twenty times in an afternoon. Then the difference between a five-second Format Cells dance and a one-click QAT button adds up to real minutes. Customise the toolbar, learn the shortcut, and the next chemistry, physics, or footnote-heavy worksheet stops being annoying. The same trick applies to superscript — set them up together and you are done.

One last note worth saying out loud. Excel will keep adding features, and Microsoft has hinted that direct subscript shortcuts may eventually ship as a default keyboard binding. Until that day, the methods above are what works in every version on every platform. Save this page if you share workbooks with anyone who keeps asking how you got the little 2 in H₂O.