How to input when Excel superscript and superscript are displayed at the same time?

Hello, everyone! I have been seriously messing with Excel's Yali recently.

Last night, just as Pear was getting ready to pack up and get off work, the boss suddenly showed up and threw out a task:

Pear, don't rush to get off work, you change all the superscripts and subscript in this form and send it to me.

Mm-hmm. Huh?!

But the square superscript. I remember it was Alt+17... Well, what's the number again?

Xiao E: there is too much code to remember. Here are a few ways to help you.

Pear: MMM!

Come to Kangkang ~ 👇👇👇 together

Method one begins with the simplest method:

Directly select the "superscript" text, then press [Alt+1] to pop up the pop-up window for formatting the cell. In "Special effects", check the superscript and subscript, and click "OK".

So you can set the superscript.

Method 2 this method only needs to poke the button and it can be easily done.

Click "File"-"options", select "Quick access Toolbar", add "superscript" and "subscript", and click "OK"

In this way, we can select the text that needs "superscript" or "subscript", and then directly on the Quick access Toolbar, click the shortcut button we have set, and then we can set the superscript and subscript.

Is it simple and convenient?

Method 3 this method is probably the most commonly used-copy and paste.

We can collect the commonly used superscripts and subscript into a document in advance and copy and paste them directly when needed.

PS. Do you like copying and pasting? You are never alone! (Hey, hey)

Method 4 finally talks about a more special case, that is, there are both superscripts and subscript.

❶ first enter the subscript, and then click the "subscript" button above (set it using method 2)

❷, select the subscript text, click "start"-"Font"-"Pinyin", and select "Edit Pinyin"

❸ then enters the required superscript text, and finally clicks on [Show Pinyin Field], and the effect comes out.

Isn't it amazing? Whisper to tell you (actually super loud): you can also set the font of "Pinyin"!

❶, click "start"-"Font"-"text", and select "Pinyin Settings"

❷ then click [Font] in the pop-up window to set the style you like. Don't forget to click the [OK] button.

Pear: wow, it's so easy to add superscripts!

Xiao E: yes, hurry up @ the friends around you to learn ~

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Yalizi, editor: Xiaoyin, Zhu Lan