Inserting Subscript in Excel

What this does

Superscript raises characters above the baseline (m², 2nd, x³) and subscript drops them below it (H₂O, CO₂). Both are font effects applied to a selection of characters INSIDE the cell, which is why you have to enter edit mode first: applying the effect with the cell merely selected raises or lowers everything in it. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “inserting subscript in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Type m2 in A1, double-click the cell, drag over just the 2, press Ctrl+1, tick Superscript and press Enter — the cell reads m². To produce the same character from a formula instead, ="Area: "&B2&" m"&UNICHAR(178) returns Area: 24 m² without any font effect at all. Units, footnote markers and chemical formulae read as sloppy when they sit on the baseline, and the cheap fix — typing them as separate characters — is the one that breaks arithmetic. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. The short version of “inserting subscript in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

Common mistakes

• Selecting the cell instead of the characters, which raises the whole entry including the part that should stay on the baseline.
• Formatting part of a numeric entry: the moment mixed formatting is applied the cell becomes text and stops being counted by SUM.
• Trying to superscript the result of a formula — the effect cannot apply to part of a calculated value, so use UNICHAR or CHAR to build the character instead.
• Assuming it survives a copy into another application; many editors drop the character-level effect on paste.

Frequently asked questions