Subscript in Google Sheets: Methods That Work

How-to basics · Updated November 20, 2026

To show subscript in Google Sheets, paste subscript Unicode characters such as the ₂ in H₂O; Sheets does not provide a built-in subscript text-formatting control. For recurring entries, you can also use a formula to convert ordinary digits into subscript characters. These methods change how text is represented, so keep ordinary numbers in separate cells when you need to calculate with them.

What You’ll Need

  • An editable Google Sheets spreadsheet open in a web browser.
  • The text or number you want to display with subscripts.
  • For the copy-and-paste method, a source for the required Unicode characters. You can copy the examples in this guide.
  • For the formula method, a spare column for the converted text so the original value can remain unchanged.

Step-by-Step

  1. Decide whether you need visual notation or a number for calculations. Subscript-style digits are characters in text, not ordinary numeric digits with special formatting. A cell containing ₂ is not the same as a cell containing the number 2. If you need to calculate, sort numerically, or use the value in another formula, keep the numeric value in its own cell and create a separate display label.
  2. Choose the characters you need. Here are the common subscript digits: ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉. Some lowercase letters also have Unicode subscript forms, including ₐ ₑ ₕ ₖ ₗ ₘ ₙ ₒ ₚ ₛ ₜ and ₓ. Availability is limited: there is not a matching subscript character for every letter, symbol, or language.
  3. Copy the subscript character or example. Select the character in this page and copy it. For instance, copy the ₂ from H₂O if you need a subscript 2. On Windows, use Ctrl+C and Ctrl+V; on a Mac, use Command+C and Command+V. You can copy a complete example such as CO₂ and edit the other letters as needed.
  4. Enter or edit the cell in Sheets. Click the destination cell and paste the complete text, or double-click an existing cell to place the insertion point within its text and paste just the subscript character. You can also select a cell and edit its contents in the formula bar. If you paste into a cell that already contains text while it is not in edit mode, Sheets may replace the entire cell rather than insert a character into the existing text.
  5. Check the displayed result. Press Enter to finish editing, then confirm the character appears at the intended position. For example, the chemical formula should read H₂O, with the 2 after H. If you are making a mathematical label, a display such as x₁ can identify a variable with an index. The subscript glyph may look slightly different depending on the font and browser, but it should sit lower than the ordinary character.
  6. For repeated digit conversion, put the source text in a cell. For example, enter H2O in A2 and leave the original value there. Select B2 for the converted display. With the source text in A2, enter this formula in B2: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"0","₀"),"1","₁"),"2","₂"),"3","₃"),"4","₄"),"5","₅"),"6","₆"),"7","₇"),"8","₈"),"9","₉"). The result for H2O is H₂O. This formula replaces every ordinary digit from 0 through 9 in A2, not just a digit at the end of a chemical formula.
  7. Apply the conversion to more rows if useful. If A3, A4, and later cells contain similar source text, copy B2 down using the fill handle at the lower-right corner of the selected cell. Sheets adjusts the reference for each row. Review the converted results, especially if the source text contains dates, product codes, or digits that should remain at normal height.

The paste method is usually simplest for a one-off label, chemical formula, or indexed variable. The formula method is useful when source text changes or you have a list to convert, but it converts every digit in each referenced cell. Both methods produce text containing Unicode characters; neither adds native subscript formatting to a cell.

Common Mistakes

  • Looking for a subscript button in the Sheets menus. Google Sheets does not offer a native Format > Text > Subscript command for cell text. Instructions for Google Docs or Microsoft Word may describe controls that are not available for formatting text in Sheets cells. Use Unicode characters instead.
  • Assuming the subscript remains a normal number. A displayed ₂ is text. It will not behave like numeric 2 in arithmetic, and a formula that expects a number may not accept it. Preserve the numeric value separately if calculations matter.
  • Replacing the whole cell by accident. Pasting while a cell is selected generally replaces its contents. To insert one character in the middle of existing text, enter cell-editing mode first by double-clicking the cell or using the formula bar, then place the cursor and paste.
  • Expecting every letter to have a Unicode subscript. The character set is incomplete. Some commonly used lowercase letters have subscript forms, but uppercase letters and many other symbols do not. A plain letter beside a subscript digit may therefore be the most readable option.
  • Converting digits that should stay ordinary. The example formula changes all digits in the source text. If a label contains both an index and an ordinary number, consider typing or pasting the desired characters manually, or adjust the source layout so only the intended part is converted.
  • Confusing a font effect with a subscript character. Changing font size or alignment can make text look smaller or lower, but it does not create consistent subscript formatting. It can also affect the whole cell and may not display consistently for other people.

Tips

  • Keep source and display values separate. Store a real measurement or index as a number in one column, then use a neighboring cell for its reader-friendly label. This makes it easier to calculate, sort, and validate data without losing the subscript appearance in headings or notes.
  • Use a small reference list for frequent symbols. Put commonly needed characters such as ₀, ₁, ₂, ₃, ₄, and ₅ in a separate reference area of the sheet. You can copy them when needed rather than searching for them each time.
  • Choose the method based on how often data changes. For a fixed label such as H₂O, pasting the complete text is quick and clear. For a changing list of digit-based labels, a formula can keep the display synchronized with the source cell.
  • Check how labels appear to other users. Unicode characters usually travel with the cell content, but their exact appearance can vary with device, font, or application. If a precise typographic layout is essential for publication, create the final equation or notation in an application with dedicated subscript formatting.
  • Remember the formula’s scope. The sample formula changes every digit in its input. For example, if A2 contains Item 12, the output will be Item ₁₂. It does not identify which digits are chemical counts, mathematical indices, or ordinary identifiers.

Troubleshooting

The character pastes as a square or question mark. The font or viewing environment may not support that Unicode glyph. Try a different font available in Sheets, test the cell in another browser, or use a simpler notation such as H2O if the intended readers cannot see the character. Avoid relying on a rare subscript letter until you have checked its display on the devices that matter.

The character appears at normal height. Make sure you pasted the actual Unicode character, such as ₂, rather than an ordinary 2. A regular digit does not become subscript just because it follows a letter. Replace it with the matching subscript character and check the display again.

The formula reports an error. Confirm that the formula is entered in B2 and that the source text is in A2. Check that the quotes and parentheses are present and that the cell does not contain a pasted curly quote in place of a straight quote. Some spreadsheet locales use semicolons between formula arguments; if Sheets rejects a comma-separated formula, use the separator expected by your locale. The formula’s replacement text must remain in quotation marks.

The formula changes too many digits. That is expected: the example replaces every 0–9 character in the referenced cell. Keep a clean source value, use manual Unicode for mixed-purpose text, or build a more targeted conversion for the exact pattern in your data. Always compare the output with the original before filling the formula down a long column.

You cannot edit the cell. Check that you have edit access rather than view-only access and that the sheet or range is not protected. If the file is open in a mobile app, the controls and editing experience may differ; the steps here are for Sheets in a desktop web browser.

Frequently Asked Questions

Can I apply subscript to only one character in a Google Sheets cell?
Not with a built-in subscript formatting control. Paste the matching Unicode character, such as ₂, into the text. It is a different character, not a formatting style applied to an ordinary digit.

Does Google Sheets have a keyboard shortcut for subscript?
No native Sheets shortcut applies subscript formatting to selected cell text. You can use the regular copy-and-paste shortcuts for Unicode characters: Ctrl+C and Ctrl+V on Windows, or Command+C and Command+V on Mac.

Can I use subscript digits in formulas or calculations?
They are text characters, not numeric values. Keep ordinary numbers in cells for calculations and use a separate display cell for a subscript-style label.

Will the formula convert subscript letters as well as digits?
No. The example formula converts only ordinary digits 0 through 9. It leaves letters unchanged. Paste supported subscript letters manually when available, or use a different notation for letters that do not have Unicode subscript forms.

Will my subscripts appear in Excel?
Unicode subscript characters generally display as text in other spreadsheet programs, including Excel, if the font supports them. Their appearance can vary, and they remain text rather than native subscript formatting there as well.

Can I create subscript in Google Docs instead?
Google Docs has text-formatting options for subscript, unlike Sheets cell text. If the notation needs typographic formatting rather than a Unicode character, Docs or an equation editor may be a better place to prepare it before sharing or publishing.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.