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

How to type subscript in excel

WBOY
Release: 2024-03-20 11:31:14
forward
1132 people have browsed it

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!

Related labels:
source:huke88.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template