How to add subscripts and superscripts in Google Sheets

Learn the basics of this important function of Google Sheets. This information will help you better navigate through the various facets of the program.

Table of Contents

If you came from a technical field such as science and engineering, you would be very familiar with subscripts and superscripts. In fact, we often use a shorthand when typing subscripts and superscripts:

Left:  What you want to type. Right: The shorthand when you cannot add superscript and subscripts. 
Left:  What you want to type. Right: The shorthand when you cannot add superscript and subscripts. 


Google Sheets doesn’t have a setting for changing the characters to superscripts or subscripts, but there is a workaround. You can stick with the notation shown above, or use a set of Unicode number subscripts and superscripts.

You can check the Wikipedia page for the Unicode table:

https://en.wikipedia.org/wiki/Unicode_subscripts_and_superscripts

We have nonetheless added them for you here so you can copy-paste them:

X⁺⁻⁰¹²³⁴⁵⁶⁷⁸⁹ x₊₋₀₁₂₃₄₅₆₇₈₉

As an example:

The Unicode superscript and subscript numbers added in Google Sheets.
The Unicode superscript and subscript numbers added in Google Sheets.


Another option is to use unicode superscript/subscript generators. Lingojam hosts one for each type:

Superscript Generator ― LingoJam

Subscript Generator ― LingoJam

These are excellent when you are entering numbers such as superscripts and/or subscripts. However, Unicode still does not have the whole alphabet available in superscript and subscript form, so you might want to think twice when you want to add whole words with it. 

For now, you can use this workaround to add superscript and subscript numbers to your Google Sheets.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

April 1, 2021

How to add subscripts and superscripts in Google Sheets

Chart with arrows pointing up and down

If you came from a technical field such as science and engineering, you would be very familiar with subscripts and superscripts. In fact, we often use a shorthand when typing subscripts and superscripts:

Left:  What you want to type. Right: The shorthand when you cannot add superscript and subscripts. 
Left:  What you want to type. Right: The shorthand when you cannot add superscript and subscripts. 


Google Sheets doesn’t have a setting for changing the characters to superscripts or subscripts, but there is a workaround. You can stick with the notation shown above, or use a set of Unicode number subscripts and superscripts.

You can check the Wikipedia page for the Unicode table:

https://en.wikipedia.org/wiki/Unicode_subscripts_and_superscripts

We have nonetheless added them for you here so you can copy-paste them:

X⁺⁻⁰¹²³⁴⁵⁶⁷⁸⁹ x₊₋₀₁₂₃₄₅₆₇₈₉

As an example:

The Unicode superscript and subscript numbers added in Google Sheets.
The Unicode superscript and subscript numbers added in Google Sheets.


Another option is to use unicode superscript/subscript generators. Lingojam hosts one for each type:

Superscript Generator ― LingoJam

Subscript Generator ― LingoJam

These are excellent when you are entering numbers such as superscripts and/or subscripts. However, Unicode still does not have the whole alphabet available in superscript and subscript form, so you might want to think twice when you want to add whole words with it. 

For now, you can use this workaround to add superscript and subscript numbers to your Google Sheets.

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.