In Excel, subscript places selected characters below the text baseline, while superscript places them above it. To apply either effect in Microsoft 365 for Windows, edit a text cell, select the characters, press Ctrl+1, open the Font tab, and check Subscript or Superscript under Effects; the change is visual formatting, not a calculation.
What subscript and superscript mean
A subscript is a small character set lower than the surrounding text. A superscript is set higher. Both are useful for showing notation compactly, but they communicate different things: the position of the character helps a reader interpret its role. In chemical formulas, for example, the 2 in H₂O is conventionally a subscript, indicating the number of hydrogen atoms in a molecule. In a measurement such as m², the 2 is a superscript indicating a square unit.
Excel treats these as font effects. They do not change the underlying letters or numbers, and they do not tell Excel to perform a mathematical operation. Formatting the 2 in a cell to appear as a superscript does not square a value. For a calculation, use Excel’s exponent operator in a formula, such as =A1^2; use superscript formatting when you want a label, heading, or explanatory text to look a certain way.
How to format part of a cell
For character-level formatting, the cell must contain text you can edit, and you need to select the particular characters rather than just select the cell. These steps apply to Excel for Microsoft 365 on Windows:
- Enter or locate the text in a cell. Double-click the cell, or select it and press F2, to edit its contents.
- Drag over the character or characters to format. For example, in the text H2O, select only the 2.
- Press Ctrl+1 to open the Format Cells dialog box. You can also use the small dialog box launcher at the lower-right of the Home tab’s Font group.
- On the Font tab, under Effects, select Subscript or Superscript, then choose OK.
- Press Enter, or click outside the cell, to finish editing and review the result.
The selected characters should change position while the rest of the text remains at its normal baseline. If you select the cell without entering edit mode, the Font settings apply to the whole cell’s contents instead. That can be appropriate when every character should use the effect, but it is not the way to format just one digit or letter.
In Excel for Mac, edit the cell and select the characters, then use Command+1 to open Format Cells. Choose the Font tab and the relevant Effects option. Excel for the web has fewer formatting controls and may not offer the same character-level Effects options in its interface; if you cannot find them, open the workbook in the desktop app. A workbook may display formatting created in desktop Excel even when the web app does not provide the same editing control.
Formatting a whole cell versus selected characters
Excel distinguishes the formatting of a cell from the formatting of individual characters inside a text cell. Selecting a cell and choosing a font effect generally formats all of its displayed text. To make a notation such as CO2 show only the 2 as a subscript, enter edit mode and select that one character first. The same selection principle applies to other character-level changes, such as bolding one word in a longer text entry.
Character formatting is best suited to manually entered text. A formula result is generated from the formula, so Excel does not provide a reliable way to format just one character within that result using the cell’s rich-text formatting controls. If a formula produces the text H2O, for instance, the 2 cannot simply be selected inside the result cell and styled independently. Consider keeping the calculated value in one cell and putting a separately formatted label in another.
When to use each effect
Choose the effect that matches the convention of the content, not simply the one that looks more decorative. Common uses include:
- Subscript: chemical formulas such as H₂O or CO₂, and some mathematical or scientific notation where a lower character identifies an index.
- Superscript: squared or cubed units such as m² or cm³, ordinal suffixes in some typesetting, and footnote markers such as a raised 1.
- Neither: values intended for sorting, filtering, arithmetic, or data exchange may be better kept as ordinary numbers or text in a consistent structure.
Conventions vary by subject. In algebra, a raised 2 in x² usually denotes an exponent, while a lowered 2 in x₂ often denotes an indexed variable. The formatting makes the notation easier to read, but it does not create those mathematical meanings in Excel. If a worksheet is used as a calculation model, keep the actual inputs and formulas in usable cells and treat formatted notation as presentation.
What Excel changes—and what it does not
Subscript and superscript are visual effects applied through font formatting. They do not change a cell’s stored text into a different character, convert a number to another value, or alter the result of a formula. A text cell containing CO2 still contains the same letters and digit after the 2 is displayed as a subscript. A numeric cell containing 2 remains the number 2 if its appearance is changed.
This distinction matters when you use Find, sort data, export a file, or send information to another system. Formatting is not a dependable way to encode meaning for data processing. A program may read the underlying text or value without interpreting whether a character was visually raised or lowered. If the distinction needs to be machine-readable, store it explicitly—for example, in separate fields for a symbol and its index—or use the appropriate literal characters in a text label.
Likewise, formatting a digit as superscript is not equivalent to entering an exponent in a formula. If A1 contains 5 and you want its square, enter a calculation such as =A1^2 in another cell; the result is 25. If you want a heading that visibly says x squared, type the label and format the 2 as superscript. Those two tasks may look related on a page, but one is computation and the other is typography.
Alternatives for labels and generated text
If you need raised or lowered characters inside a label that is produced by a formula, Unicode superscript or subscript characters can be an alternative. For example, the characters ² and ₂ are distinct text characters, rather than ordinary 2 characters styled by Excel. They can be useful in short labels, chart titles, or formula-generated strings when the needed character exists in Unicode.
There are trade-offs. Unicode does not provide a matching raised or lowered version of every letter and digit, and the appearance can vary with the chosen font or the software that opens the workbook. These characters may also behave differently in search, text comparison, and data exchange from ordinary digits. Use them for display text when appropriate, not as a substitute for numeric values in calculations. For a worksheet that needs both an accurate calculation and a polished label, keep the value and the label separate.
Common problems and fixes
- The whole cell changed. You probably selected the cell but not its text. Edit the cell with F2 or a double-click, select only the intended characters, and apply the effect again.
- The Effects checkboxes are unavailable or do not affect the result. Check whether you are editing a formula result, a number, or content in Excel for the web. Character-level formatting is intended for selected text in a cell; use a text label or the desktop app where needed.
- The character is difficult to read. A raised or lowered character may be less legible at small display sizes. Increase the cell’s font size or column width, or use a plain-text alternative in dense tables.
- The content no longer behaves like data. If you typed a chemical formula or unit as text, it is a label, not a numeric value. Keep a separate numeric cell for calculations and use the formatted text for display.
- The formatting is hard to spot later. Reopen Format Cells while editing the text and inspect the Font tab’s Effects settings. You can also remove the effect by selecting the same characters and clearing the relevant checkbox.
Frequently Asked Questions
Is there a keyboard shortcut for subscript or superscript in Excel?
Excel for Windows does not provide the familiar one-key subscript or superscript toggle found in some word processors. Use Ctrl+1 to open Format Cells, then choose the effect on the Font tab. On Mac, Command+1 opens Format Cells.
Can I make only one number in a cell superscript?
Yes, when the cell contains editable text. Enter edit mode, select the number itself, and apply Superscript through Format Cells. This is character formatting, not a way to change a numeric value or formula result.
Does superscript formatting calculate an exponent?
No. It changes how selected text appears. For a calculation, use the caret operator in a formula, such as =A1^2, which squares the value in A1. Keep the formula and the formatted label conceptually separate.
Can Excel make the 2 in H2O a subscript automatically?
Excel does not automatically apply subscript formatting based on chemical meaning. Select the 2 in a text cell and use the Subscript effect, or use a Unicode character such as ₂ in a display label.
Can a formula return text with one character formatted as superscript?
A formula can return text, but its result does not support reliable rich-text formatting of just one character through the normal cell formatting controls. Use a Unicode superscript character when suitable, or place the formatted label in a separate manually formatted text cell.
Choosing the right approach
Use Excel’s Subscript or Superscript effect when you need a selected character in a manually entered text cell to sit lower or higher than the baseline. Use an actual formula when you need Excel to calculate a power, and use Unicode only when you need a literal raised or lowered character in generated display text and accept its limits. Keeping presentation separate from calculation makes worksheets easier to read, search, maintain, and share.
Related
- Sample Customer List Excel: Fields, Template, and Setup
- Sales Order Tracking Excel Template: Setup and Tips
- RSVP List Template Excel: Build and Track Guest Replies
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Keyboard Shortcut to Insert a Line in WordIn Microsoft Word, press Shift+Enter to insert a line break without starting a new paragraph. If you mean…
- Clothing Inventory Spreadsheet Template: Setup & TipsA clothing inventory spreadsheet template should track each sellable variation—such as a particular shirt in size M and…
- How to Create Multiple Address Labels in Microsoft WordTo create multiple address labels in Word, set up a recipient list, choose the label stock you have,…
- How to Double Space in Word Using Your KeyboardTo double-space text in Microsoft Word on Windows, select the text or place the cursor in the paragraph,…
- How to Hide Columns in Excel: A Step-by-Step GuideTo hide columns in Excel for Microsoft 365 on Windows, select one or more column headers, right-click the…
- Free Excel Meal Plan Template: Build a Weekly PlannerYes—free Excel meal plan templates are available, and you can also build a simple weekly planner in a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.