A simple way to set character superscript and subscript in Excel

Unlike Word, the Format menu of Excel does not have a command to format fonts directly, and the formatting exists in the Format Cells dialog box. The settings for the subscript in the cell also need to be done in this dialog box, and here's a brief introduction:

1. Select the characters in the cell that you want to set to superscript, right-click on the selected characters, and select Format Cells on the shortcut menu, as shown in Figure 1.

Formatting cells

2. This way open the Cell Format dialog box, only the "Font" one tab, in its lower left of the "special effects" area, there are "superscript", "subscript" two options, choose one, such as Figure 2.

"Superscript", "subscript"

3. Click the OK button and the selected character changes to the specified superscript or subscript.

Note: For text characters, you can set this method at will. For numeric characters, however, setting up and down labels does not work, you must first format the cell as text, or you can complete the normal setting by adding a half-width single quotation mark to the front of the cell character after you set up the superscript (edit state). In addition, the numeric size of the number after the superscript is set does not change, for example, 10 of two times, the calculation will not act as "100", and will still be calculated as "102". As shown in Figure 3.

The numeric size of a number does not change after the superscript is set

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join