Subscript in Google Sheets

Subscript both is the smaller characters of the normal characters. Subscript positioned slightly lower in comparison of normal text. Subscript use for chemical elements.For Example: 2 is Subscript in O

Subscripts and superscripts are available in Word, Excel as well as in Google Docs, But it is not available in Google Sheet now. So we found another solution to use Subscript and Superscript in Google Docs easily. We can use Subscript in Google Sheet using 3 ways which are as follows;

1. 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. 

2. Copying from Subscript Table on Working 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.


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 *