I’m back with another unique Google Sheet tutorial. This time we can learn how to use Subscript and Superscript numbers in Google Spreadsheets, a missing Google Sheets feature. Here we will learn how to apply both these features with numbers. Anyway we are not discussing how to Superscript and Subscript characters here.
With our unique trick, we can get all the numbers in Superscript and Subscript form and we can increase the font size also.
Meaning of Superscript and Subscript
These are characters printed above the line or below the line. We require this format in certain occasions like while entering a chemical formula, units etc. to make our spreadsheet more readable and correct.
Superscript and Subscript are not new to many of you. This format is available in Excel, Word and Google Doc. But sadly missing in Google Sheets now. We can overcome this as below.
How to Easily Get Subscript and Superscript Numbers in Google Spreadsheets
There are 20 numbers to convert to Character String. Then only we can get 10 digits from 0 to 9 each for Subscript and Superscript.
Here in this tutorial we are using the Character function “Chr()” which will bring the Character String representation of a given Decimal Value.
First create a Google Sheet file like the one below. It contains some numeric value and we applied “char()” function to get its Character String. It will give you Superscript and Subscript characters from 0 to 9 in the formula applied ranges.
It’s difficult to remember the 20 numbers, 10 each for Superscript and Subscript to use with the function always, right?. So do one thing! Copy the entire data and in a new sheet or a blank cell in the same sheet, paste it. Not just paste. Then? Go to Edit>Paste Special>Paste Values.
Whenever you want Superscript and Subscript in Google Spreadsheet, open this Google Sheet file and copy paste the characters.
Hope you enjoyed this tutorial. If yes don’t forget to check our eBook and Paperback titled Google Sheets : 20 proven tricks to boost your productivity on amazon also take a look at our DOWNLOAD section.