When you are working with statistical data inside Google Sheets, you may need to use subscripts and superscripts.
If you’ve never tried using these before, you may be wondering how to enter them into your spreadsheet.
In this tutorial, I will show you a few ways to add subscript and superscript in Google Sheets
Table of Contents
What are Subscript and Superscript?
Subscripts are characters that are smaller than standard text that is positioned slightly lower.
For example, the 5 in X5 is a Subscript.
Superscript is similar to subscript in that they are also smaller than standard text but these are positioned higher
For example, the 3 x3 is a Superscript.
Both subscript and superscript are useful in mathematical formulas and equations for a number of reasons.
Subscript is commonly used when writing chemical formulas or when showing different versions of a variable in a mathematical sequence.
Superscript is commonly used when raising variables to a certain power (x3) or for other more common uses like showing temperatures 100°F.
In Google Docs it is very easy to enter subscripts and superscripts, but in Google Sheets, there is not a built-in feature yet for this. Luckily there are still a few methods you can use to enter them into your spreadsheet that we will cover below.
How to Enter Subscript and Superscript
Copy and Paste Unicode Characters
The easiest way to add subscript or superscript to your Google Sheet is to use Unicode Symbols.
The best way to get Unicode Symbols into your spreadsheet is to copy and paste them from a website where you can look up the desired Unicode Symbols that you want.
For example, if you go to Unicode-Table.com you can copy any subscript and superscript numbers, symbols, or letters that you want and paste them into your spreadsheet.
The CHAR function is a formula in Google Sheets that you can use to enter certain characters into your spreadsheet.
Each character has a number that is called an ASCII code. When you use that number with the character function it will return your desired symbol.
You can use this to enter subscript and superscript into your file.
The syntax of the CHAR function is:
Below is an example of how to use this formula. You simply enter the character code of the superscript or subscript value that you are trying to return within the CHAR function.
After using the function to get your character you can paste your formula as values so you just have the symbol.
Subcript CHAR Code Numbers
Superscript CHAR Code Numbers
Copy and Paste from Another Program
Another option is to create your superscript and subscript numbers or symbols in another program and just copy and paste them into your spreadsheet.
Google docs has the ability to enter superscript and subscript, so you can always enter them there first and then copy and paste them into your sheet.
For your convenience, we have also put common ones below that you can copy and paste into your sheet.
Common Math Superscripts:
⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾
Common Math Subscripts:
₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎
More Google Sheets Tutorials:
How to Do Basic Math Formulas
Scientific Notation in Google Sheets
How to Insert Special Characters