How to Get Subscript and Superscript Values in Google Sheets

subscript and superscript numbers in Google Sheets
3 Ways to Get Subscript and Superscript Numbers in Google Sheets – Sheetaki

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. 

To start using Unicode symbols as your subscript and superscript in your Google Sheets, simply google the “subscript/superscript <your number> Unicode”.

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

 

subscript and superscript numbers in Google Sheets
Just copy-paste the subscript/superscript number.

 

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.

subscript and superscript numbers in Google Sheets

 

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:

subscript and superscript numbers in Google Sheets

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

 

Get emails from us about Google Sheets.

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.

 

0 Shares:
3 comments
  1. This is really great info, thank you!
    Used the copy and paste in a Moodle question where other ways of getting superscript wouldn’t work and solved the problem – a great help.

Leave a Reply

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

You May Also Like