How to Get Subscript and Superscript Values in Google Sheets

A few days back I was making some changes and adding data into a Google Sheet as part of my work with statistical data analysis.

It was surprising yet frustrating to me that Google had not implemented the feature to provide subscripts and superscripts for the Google Sheets since so many of us deal with data that come in the form of mathematical fractions/multiples and chemical formulas.

If you’re a teacher, an engineer, or a student, you’ll understand how tedious and complicated this is. 😕

I have since then tried a few things and spent some time finding ways on how to get subscripts and superscripts into Google Sheets and this guide is the result of all that research.

This guide is for you if you’re looking to get subscripts or superscripts into your Google Sheets as it contains tried and tested ways of getting it.

As always let me know if any of them doesn’t work so that I can update this article with newer ways. 🙂

` `

1. Using Unicode Symbols.

The easiest way to get Subscript and Superscript in Google Sheets is by using the Unicode symbols for them.

Unicode symbols work similarly to emojis but Unicode symbols are a form of the text itself.

Sites like Compart.com are good sources of Unicode characters that we can copy-paste into our Google Sheets for use.

If you’re looking for letters which are either subscript or superscript, then you can enter the letter into the Subscript Generator or Superscript Generator provided by Lingojam.

Once you’ve got your subscript or superscript, simply copy-paste it like how you would copy-paste text, right into your Google Sheets.

2. Using the Sheetaki Collection of Subscripts and Superscripts.

Recently I had come across a guide on this similar topic written over at InfoInspired.com and with all due credit, the guide was a good take on how to get subscripts and superscripts in Google Sheets.

The tutorial shows how to use certain formulas like the CHAR function to obtain the subscripts and superscript of numbers. However, this is too cumbersome and for convenience, I have created my spreadsheet using functions like the CHAR function and a few others to extract the subscripts and superscripts.

You can view and use the spreadsheet to copy-paste subscript/superscript values to whatever you need it for.

You can access the Sheetaki Subscripts & Superscripts Collection below:

The spreadsheet contains everything from numbers, alphabets to even fractions all in either subscripts or superscripts.

Give it a try and let me know if it helps.

3. Else just copy-paste this 👉

If you would something quick and easy to use right away, you can also just copy-paste the subscript or superscript numbers from below into your Google Sheets.

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

This is only limited to numbers as of right now. If you need alphabets, functions, symbols, then you can use the Sheetaki Collection above from Number 2.

That’s pretty much it. You can now use subscript and superscript numbers in Google Sheets together with the other numerous Google Sheets formulas to create even more powerful formulas. 🙂

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content.

How to Use WORKDAY Function in Google Sheets

The WORKDAY function in Google Sheets is useful if you want to get a date that is the…

How To Make a Boxplot in Google Sheets

The boxplot in Google Sheets is useful when you need to visualize the distribution of data in a…

How to Use the ERF.PRECISE Function in Google Sheets

The ERF.PRECISE function in Google Sheets calculates for the Gauss error function integrated between 0 and a given…

How To Use ISNONTEXT Function in Google Sheets

The ISNONTEXT function in Google Sheets is used when you need to determine whether the value of a…