Home

Superscript and Subscript ribbon buttons

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

@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.

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

@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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies