To add subscript in Excel for Microsoft 365 on Windows, edit a text cell, select the characters to lower, press Ctrl+Shift+F to open the Font tab, choose Subscript, and press Enter. In the English Windows dialog, Alt+B can check Subscript once that tab is active. Excel does not have a single key that instantly applies subscript, so you first need to select the characters you want to format.
What You’ll Need
- Excel for Microsoft 365 on Windows, or another desktop version with the Format Cells dialog.
- A cell containing text that you can edit. Partial-character formatting is intended for text constants, not formula results.
- The exact letters or numbers you want to lower. Subscript changes their appearance; it does not change a cell’s underlying value or perform a calculation.
If you are using Excel for the web, its editing and character-formatting options may differ from desktop Excel. Open the workbook in the desktop app if you cannot select and format individual characters in the browser. On a Mac, use the Mac-specific notes in the steps below; the Windows Alt access key is not the Mac equivalent.
Step-by-Step
- Enter the text in a cell. For example, type H2O as ordinary text if you want the 2 to appear lower, or type CO2 for a carbon dioxide label. Press Enter to commit the entry, then select the cell. If Excel treats an entry as a number or a formula, partial-character formatting may not be available; a text label is the appropriate starting point for a visual label.
- Open the cell for editing. Press F2 with the cell selected. The insertion point appears within the cell’s text. You can also double-click the cell, or select the cell and click in the formula bar. If the cell is wide or its text is difficult to see, the formula bar can make it easier to locate the right characters.
- Select only the characters to subscript. Move the insertion point to one side of the characters, then hold Shift while pressing the arrow keys to select them. For H2O, select just the 2; leave H and O unselected. If you use the mouse, drag across the characters while the cell is in edit mode. Check the selection before proceeding: formatting applies to the selected text, and selecting the whole entry will lower the whole entry.
- Open the Font tab with the keyboard. With the characters still selected, press Ctrl+Shift+F. In desktop Excel for Windows, this opens the Format Cells dialog on its Font tab. If this shortcut does not open the dialog on your keyboard or in your Excel setup, press Ctrl+1 instead, then use the mouse to select the Font tab. The dialog may open on a different tab when you use Ctrl+1.
- Turn on Subscript. On the Font tab, find the Effects area and select the Subscript checkbox. If the English dialog has focus on the Font tab, pressing Alt+B usually selects that checkbox. The access key can depend on the dialog’s language, so use the checkbox itself if Alt+B does something else. Do not select Superscript by mistake: that raises characters rather than lowering them.
- Apply the formatting. Press Enter to confirm the Format Cells dialog. If Enter does not confirm it in your situation, use Tab to move to the OK button and press Enter, or click OK. Excel returns to the worksheet with the selected characters formatted. Press Enter again if you are still in cell-edit mode and want to finish editing the entry.
- Check the result in the cell. The selected characters should sit lower than the surrounding text and often appear slightly smaller. In the example H2O, only the 2 should be lowered. Widen the column or adjust zoom if the characters are difficult to inspect; changing the display scale does not change the formatting.
- Use the dialog on a Mac if needed. On Excel for Mac, select the text while editing the cell, press Command+1 to open Format Cells, then choose the Font tab and Subscript option. The Windows sequence Alt+B is not a Mac shortcut. Depending on your keyboard settings, you may need to use the dialog controls with the mouse. Close the dialog with OK and verify the result in the cell.
The key sequence is useful because it avoids searching through the ribbon, but it is not a universal one-keystroke toggle. The character selection is the important first step. If no characters are selected while you are editing, the dialog may apply formatting to subsequent text or to a broader selection than you intended. Reopen the cell and confirm that the target characters are highlighted before applying the effect.
Common Mistakes
Trying to format a cell without editing its text: Selecting a cell and using the dialog can change formatting for the whole cell. It does not necessarily target one character. Press F2 or click in the formula bar, then select the characters inside the text before opening Format Cells.
Looking for a dedicated subscript toggle: Excel does not provide a standard direct shortcut that works like a one-key bold toggle for subscript. The dialog-based route is the reliable Windows method. A shortcut that opens the font dialog still requires you to enable the Subscript effect.
Formatting a formula result: A value displayed by a formula is not editable as individual characters in the same way as a text constant. You can format the result cell as a whole, but Excel does not provide rich-text formatting of just one character generated by a formula. If you need a fixed, manually formatted label, enter it as text; if the value must remain dynamic, consider a text display that does not depend on partial formatting.
Using number formatting for a chemical label: Number formats can change how numeric values display, but they are not a general method for lowering one character in text such as H2O. Do not replace a needed numeric value with a text label if other calculations rely on that value.
Selecting Superscript or the wrong characters: Superscript raises text, and formatting the whole string can make the label hard to read. Inspect the selection and the checkbox before confirming the dialog.
Tips
Keep the cell’s meaning separate from its appearance. Subscript is character formatting; it does not turn the 2 in a label into a special numeric operator or change a formula’s calculation. A cell that contains a text label remains text even when one character is lowered. If a value is used in arithmetic, keep the numeric data in its own cell and use a separate display label when partial text formatting is required.
For repeated labels, format one correctly and copy the cell when the wording is identical. If you change the characters afterward, inspect the new label because copied formatting can extend to a different part of the text than you intended. For a range of cells that all need the same whole-cell formatting, select the range first; for partial-character formatting, work on each text entry and select its characters deliberately.
Use subscript for conventional notation such as the 2 in H2O or CO2. Use superscript for raised notation such as an exponent or a footnote marker. Excel’s subscript effect is a visual treatment, not a scientific validation feature, so check spelling, capitalization, and the intended notation separately.
If you frequently need to create a new label, type the complete text first and apply the formatting afterward. This is usually simpler than trying to change font effects in the middle of typing. When you need to edit a formatted label later, select only the characters that should change; adding or deleting text next to a formatted character can make it less obvious where the formatting starts and ends.
Troubleshooting
The shortcut opens a different tab or does nothing. Press Ctrl+Shift+F on Windows to try opening the Font tab. If the key combination is intercepted by your keyboard, remote desktop, or another application, press Ctrl+1 and click Font in the Format Cells dialog. On a Mac, use Command+1 and select Font manually.
Alt+B does not select Subscript. Make sure the Format Cells dialog is open and the Font tab is active. Keyboard access keys may vary with Excel’s display language, and some keyboard layouts require different key handling. Click the Subscript checkbox directly, then confirm with OK. If Alt+B selects a different control, do not keep pressing it; use the visible checkbox.
The whole cell changes instead of one character. Close the dialog, reopen the text for editing with F2, and select the exact characters. A cell border around the cell is not the same as a highlighted character selection. Confirm that the individual characters are selected within the text before applying the effect.
The text looks unchanged after you click OK. Re-enter edit mode and check whether Subscript is actually enabled for the selected characters. The effect can be subtle at small font sizes. Increase the zoom temporarily or make the column wider to inspect it, then restore your preferred view. Also check that you did not choose Superscript or format a different part of the entry.
You cannot select part of the displayed text. Check whether the cell contains a formula, a number, or text. Formula results cannot be partially formatted as rich text in the usual way, and numbers are not a dependable basis for individual-character formatting. For a fixed label, enter text in a separate cell; for formula-driven content, use a design that does not rely on lowering one generated character.
The subscript is difficult to read or clips in the cell. Increase the font size or row height, widen the column, or adjust alignment. Subscript sits lower and may be smaller, so a row with very little height can make it appear cut off. These layout changes affect visibility, not the stored text.
Frequently Asked Questions
What is the keyboard shortcut for subscript in Excel?
There is no single direct subscript toggle. On Windows, select the characters while editing the cell, press Ctrl+Shift+F, enable Subscript on the Font tab, and confirm. In the English dialog, Alt+B can select the checkbox.
Can I subscript just one number in a cell?
Yes, when the cell contains an editable text constant. Enter edit mode, select that digit, and apply Subscript. If the displayed content comes from a formula, Excel cannot usually apply rich-text formatting to just one character of the formula result.
Does subscript change the cell value?
No. It changes how selected characters look, not their underlying text or numeric meaning. Do not rely on visual subscript formatting to alter calculations or make a value behave differently.
Can I use the same Windows shortcut on a Mac?
No. The Windows Alt access key does not carry over. In Excel for Mac, select the characters, open Format Cells with Command+1, and choose Subscript on the Font tab.
How do I remove subscript?
Edit the cell, select the affected characters, reopen the Font tab, and clear the Subscript checkbox. Confirm the change with OK. If you select the entire entry instead, you may remove subscript from more characters than intended.
Will subscript work in Excel for the web?
Browser editing features can differ from desktop Excel, especially for selecting and formatting individual characters. If the browser does not expose the needed text-formatting control, open the workbook in desktop Excel and use the Format Cells steps above.
Related
- Resize a Picture in an Excel Header: Step-by-Step
- Repair Excel in Windows 11: Practical Fixes and Steps
- How to Replace a Picture in an Excel Header
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Outlook Cache: Safe Steps and What They RemoveYes—clear an Outlook cache when it is causing a specific problem, but first identify which cache you mean.…
- Excel Cell Text Limit: Characters, Display, and FixesIn Microsoft Excel for Microsoft 365 on Windows, a cell can contain up to 32,767 characters, including spaces…
- Excel Text to Columns: Split Names, Dates, and Other DataIn Excel for Microsoft 365 on Windows, select the cells in one column, then choose Data > Text…
- Compare Two Excel Sheets and Find Duplicate Rows EasilyTo compare two Excel sheets and find duplicates, put the records in the same workbook and use a…
- Rename a Sheet in Excel Without a MouseIn Excel for Microsoft 365 on Windows, select the worksheet you want to rename, then press Alt, H,…
- Can You Password Protect a Sheet in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, go to Review > Protect Sheet, choose which actions users…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.