In Excel document cells, how do I set the character superscripts and subscripts?

Unlike Word, there is no command to directly set the font format in the "format" menu of Excel, and the format settings exist in the "cell format" dialog box. The setting of up and down objects in cells also needs to be done in this dialog box. The following is a brief introduction.

1. Select the top and bottom characters in the selected cell, right-click the selected characters, and select the "set cell format" option in the menu.

2. In this mode, only the "font" tab is displayed in the "cell format" dialog box, in the "special effect" area at the bottom left of the tab, there are two complex options: "superscript" and "subscript". Select one of them.

 

3. Click "OK". The selected character becomes the specified superscript or subscript.

Note that text characters can be set as needed. However, for numeric characters, setting up or downgrading does not work. You must first set the cell format to text or after setting up or downgrading (editing) add a single quotation mark at the beginning of the cell character to complete normal settings.

In addition, the value of the number after the upper limit is set does not change. For example, if the second side of 10 is not calculated as "100", it is still calculated as "102.