Superscript in Google Sheets

Superscript and subscript both are the smaller characters of the normal characters. Superscript positioned slightly higher and Subscript positioned slightly lower in comparison of normal text.Generally we use Superscript in mathematical terms, in other hand Subscript use for chemical elements.

For Example:

  • 2 is Superscript in x2
  • 2 is Subscript in O2

We can use Subscript in Google Sheet using 3 ways which are as follows;

Using Formulas

Using the CHAR() Function

The CHAR () function is the in-built function of Google sheets. It give the characters value corresponding to a given decimal value. 

There are numerical values (called ASCII codes) corresponding to each characters.

For example, the decimal value of the character A is 65.

If you type following CHAR function into a cell and press the Enter / Return key, you will get the letter A as a result of the function.

=CHAR(65)


In the same way, there are the numerical value corresponding to Subscripts and Superscripts from 0 to 9, as well as mathematical symbol like (),+,- and +.
Numerical value to alphabets are also available but not for all. So make the template file of the characters by using same formula which can be useful in future whenever you to add Subscript and Superscript in Google Sheet. 

Copying from Subscript and Superscript Table on this Page

It will be difficult to remember these numbers for each Subscript and Superscript to use with CHAR always. So we can follow another steps.
copy the required character form the below table and paste it Google sheets as below.


Subscript and Superscript in Google Sheets by Copying from Template
Whenever you want to use Subscript and Superscript in Google Sheets open the previous file which was saved as a template file. Copy the required character from A to D and paste Special whenever you want to use.






Leave a Comment

Your email address will not be published. Required fields are marked *