Home >Software Tutorial >Office Software >How to type subscript in excel

How to type subscript in excel

WBOY
WBOYforward
2024-03-20 11:31:141145browse

In Excel, subscripts usually refer to the coordinates of cells, such as A1, B2, etc. To type subscripts in Excel, you can use the following two methods. First, you can use special characters, such as subscript numbers in the Unicode character set. Secondly, the subscript effect can be achieved by inserting equations. For specific operations, please refer to the Excel help document, which details how to type subscripts in Excel. Hope the above method can help you!

1. Superscript method:

1. First, enter a3 (3 is superscript) in Excel.

How to type subscript in excel

#2. Select the number "3", right-click and select "Format Cells".

How to type subscript in excel

3. Click "Superscript" and then "OK".

How to type subscript in excel

4. Look, the effect is like this.

How to type subscript in excel

2. Subscript method:

1. Similar to the superscript setting method, enter "ln310" in the cell (3 is the subscript) , select the number "3", right-click and select "Format Cells".

How to type subscript in excel

#2. Check "Subscript" and click "OK".

How to type subscript in excel

How to type subscript in excel

3. Superscript and subscript methods without letters:

1. If the input content does not contain letters , for example, enter "33" (the second 3 is a superscript)". According to the above method, there is no way to set the superscript and subscript.

First, you must select the entire cell, right-click and set the cell format to "Text".

How to type subscript in excel

#2. Then select the second "3", right-click and set the cell format to "Superscript". Subscripts can also be set in the same way.

How to type subscript in excel

How to type subscript in excel

3. Finally, what we need to note is that we must set the cell format to text format before we can set the superscript and subscript, otherwise If so, the superscript and subscript may disappear after the settings are completed.

The above is the detailed content of How to type subscript in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:huke88.com. If there is any infringement, please contact admin@php.cn delete