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. 🙂
Table of Contents
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.
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.
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. 🙂