Add Superscript and Subscript Formatting in Excel for Mac
Question details
The user wants to apply superscript or subscript formatting in Excel for Mac without dedicated Quick Access Toolbar buttons.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Format text or a value in a worksheet as superscript or subscript.
- Observed behavior
- Excel for Mac does not provide dedicated superscript and subscript buttons for the Quick Access Toolbar, and custom keyboard shortcuts may be unavailable in older versions.
Open the workbook in Excel for Mac and locate the cell you want to format. Decide whether to format the whole cell or only selected characters in its text.
Use Format Cells to Apply Superscript or Subscript
Use the Font settings in Format Cells when toolbar buttons or custom shortcuts are unavailable.
Click the cell to format its contents, or double-click a text cell and select the individual characters you want to change.
Choose Format > Cells from the menu bar, then open the Font tab.
Under Effects, select Superscript or Subscript, then click OK.

Format Spreadsheet Text with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working in WPS without changing the missing toolbar options in Excel for Mac.

Frequently Asked Questions
How do I make just one character superscript in Excel for Mac?
Double-click a text cell, select the character, and choose Format > Cells > Font. Select Superscript under Effects and click OK.
Can I add superscript and subscript buttons to the Quick Access Toolbar in Excel for Mac?
Excel for Mac does not provide dedicated Quick Access Toolbar buttons for these effects. Use Format > Cells > Font instead.
How do I remove superscript or subscript formatting?
Select the formatted cell or characters, choose Format > Cells > Font, clear the Superscript or Subscript option, and click OK.
Can I record a macro to format selected characters?
Macro recording is unavailable while Excel is in Enter or Edit mode. A macro is an alternative, but it must be written manually for that workflow.




