Home

Superscript and Subscript ribbon buttons

Highlighted
Lenoire77
Occasional Visitor

Is there any way of getting the Subscript & Superscript buttons into Excel 2013 the same as they are in Word 2013?

 

When you have a lot of text in hundreds of cells which includes m2 and m3 it's not particularly efficient.

3 Replies
Highlighted

@Lenoire77 

This does not directly answer your question but may be relevant.  Although the formatting of Excel text to introduce superscript/subscript is laborious, it is possible to introduce Unicode subscript characters e.g.

m₂ , m₃

Not only can they be used as text strings, they are also valid as names, unlike M2 or M3 that are cell references.

Highlighted
If you want to add superscript 2 or superscript 3, you may use:
=“m”&CHAR(178)
=“m”&CHAR(179)
Highlighted

@Twifoo 

To continue your post, given a sufficiently up to date version of Excel,

= "m"&UNICHAR(unicode)

will produce m₀ to m₉ as Unicode takes values from 8320 to 8329

Related Conversations
Some edit options are grayed on the ribbon.
Maciej Kukułka in SharePoint on
0 Replies
Excel's Ribbon irregularly dissapears/greys out!?
WesselTelco in Excel on
2 Replies
Superscript in Forms Description
Amani24 in Microsoft Forms on
2 Replies
Excel Online Ribbon not visible on SP2016 xlsx file
Stefaan De Vreese in Excel on
3 Replies