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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies