How To Add A Subscript In Google Sheets

When working with statistical data in Google Sheets, you may sometimes need to employ and show mathematical formulae. Or this could be for your next math grade (if you're a teacher)

And this oftentimes requires the use of subscripts or superscripts in Google Sheets.

In this tutorial, I will show you some easy means to add subscript and superscript in Google Sheets.

• What are Subscripts and Superscripts?
• When and Why We Demand Superscript and Subscript in Google Sheets
• iii Ways to Get Subscript and Superscript in Google Sheets
  • Using the CHAR() role
• Using Unicode Symbols

What are Subscripts and Superscripts?

Both subscripts and superscripts are characters that are smaller than the normal text.

Subscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the normal text.

For case:

• The two in O _ii is a Subscript
• The ii x ² is a Superscript

When and Why We Demand Superscript and Subscript in Google Sheets

You might need subscripts while writing chemical formulae or notation. You may likewise need to utilise subscripts in mathematics, when you are trying to announce dissimilar versions of the same variable or to refer to a member of a sequence, for example – a₀, a₁ , a₂…

Superscripts, on the other hand, are often used to raise a number or variable to a certain power (eg: ten²). It is also used to correspond temperatures in degrees. For instance, v°C.

Using subscripts and superscripts is fairly like shooting fish in a barrel on Google Docs, but this feature has not withal been implemented on Google Sheets. And information technology'due south understandable since Google Sheets was built to piece of work with numbers and is non a word processor.

But a lot of people do demand to brandish data that comes in the grade of fractions or formulae in spreadsheets besides (this is also one of the mutual queries I get from people).

Fortunately, there are ways to add subscripts and superscript in Google Sheets.

iii Ways to Get Subscript and Superscript in Google Sheets

Here are iii ways you can utilise superscripts and subscripts in Google Sheets.

Using the CHAR() function

The CHAR() function is one of the in-built functions of Google sheets. Information technology gives the character value respective to a given decimal value.

There are numerical values (called ASCII codes) corresponding to each graphic symbol.

For example, the decimal value for the character A is 67.

So if y'all type the following CHAR function into a cell and press the Enter/Render fundamental, you will become the alphabetic character 'A' as a result of the function.

=CHAR(65)

In the same mode, at that place are numerical values corresponding to subscript and superscript numbers 0 to nine, besides as mathematical symbols similar (), +, – and =.

Numerical values for subscript and superscript alphabets are also bachelor, merely not for all of them.

For your convenience, I have created a Google Canvass containing lists of ASCII codes along with the subscript/superscript character they represent. All you need to practice is make a copy of this, salve it on your own Google Bulldoze and use the codes whenever required.

Click here to access the canvass that has the subscript and superscripts (you volition have to make a copy to utilise it)

Here's how you tin employ the codes in the Sheet.

1. Make a copy of my crook sheet and save it in your own Google Drive. Keep this for future use.
2. You will notice that it contains two split sheets. One named 'Subscript Characters' and another called 'Superscript Characters'.
3. Each canvass has tables for numbers, symbols, and alphabets. The first column has the character you lot need, the second ane has the respective ASCII code and the third one has the CHAR() office to display the corresponding subscript/ superscript.
4. Whenever you need to use a subscript or superscript, simply open this saved file, select the corresponding sheet and find the grapheme that you lot need from the list. Say you want to type the annotation x². Y'all tin then look for the note corresponding to the number 2.
5. Select the jail cell in the corresponding part column and press Ctrl+C on your keyboard. If you look at the contents of this cell, you will discover that it is actually the consequence of a char() function.
6. Go to the file where yous need to put the superscript/subscript. Right-click on the required cell, and from the popup menu, click on Paste Special and and then click on Paste values Simply.

This will paste your required superscript/ subscript symbol in place. You can then cull to conform the size as required.

Using Unicode Symbols

The second and easier way to comprise subscripts/ superscripts in Google Sheets is by using Unicode Symbols.

Unicode symbols are a lot like emojis, but you can use them as role of your text. All you need to exercise is re-create and paste the symbol into your cell wherever needed.

There's a complete set of superscript and subscript Unicode symbols available, that can exist easily Googled, copied and pasted.

Alternatively, you can visit Compart.com and wait up your subscript of selection by searching the word 'subscript' or 'superscript', followed by the number you are looking for in words. For example, if yous are looking for the superscript form of the number 7, you can blazon 'Superscript vii' (or just type superscript and then select 7 from the list).

This will requite you the Unicode symbol for the number 7 in superscript form equally shown below. Y'all can simply copy this symbol and paste to your Google Sheet.

Unicode symbols are available for superscripts and subscripts of all numbers from 0 to 9, a few Greek symbols as well equally mathematical symbols like +, – , = and ().

Also available are superscript symbols for all lowercase alphabets (except the letter of the alphabet q), and subscript symbols for some lowercase alphabets. There are some superscript symbols for uppercase alphabets as well but at that place are no subscript symbols for the aforementioned.

To make things easier for you, hither are all the available superscript and subscript Unicode symbols in ane place.

Instead of going through the pain of searching, you can just copy all the below symbols onto a google sheet somewhere (or a Google Doc) and and so apply them equally and when needed.

Mathematical Symbol Superscripts:

⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾

Mathematical Symbol Subscripts:

₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎

Greek Letter Superscripts:

ᵅ ᵝ ᵞ ᵟ ᵋ ᶿ ᶥ ᶲ ᵠ ᵡ

Greek Letter Subscripts:

ᵦ ᵧ ᵨ ᵩ ᵪ

Lowercase Alphabet Superscripts:

          ᵃ ᵇ ᶜ ᵈ ᵉ ᶠ ᵍ ʰ ⁱ ʲ ᵏ ˡ ᵐ ⁿ ᵒ ᵖ ʳ ˢ ᵗ ᵘ ᵛ ʷ ˣ ʸ ᶻ

Lowercase Alphabet Subscripts:

          ₐ ₑ ᵢ ⱼ ₒ ᵣ ᵤ ᵥ ₓ

Majuscule Alphabet Superscripts:

ᴬ ᴮ ᴰ ᴱ ᴳ ᴴ ᴵ ᴶ ᴷ ᴸ ᴹ ᴺ ᴼ ᴾ ᴿ ᵀ ᵁ ⱽ ᵂ

Note that the positions of these symbols in relation to your text may vary depending on the font used.

Using 3rd Political party Sites/Add together-ons

At that place are a number of tertiary-party add-ons that permit y'all to generate subscript or superscripts forms of numbers, messages, and some symbols.

For example, you lot can use the Subscript Generator or Superscript Generator, created by Lingojam.

1. Simply blazon in the value for which you demand a superscript/ subscript on the left-hand side and you will get the corresponding superscript/subscript on the right-manus side.
2. After that, y'all tin can but copy this and paste it into your Google Sheet.

It might not exist long before Google implements tools to directly apply superscripts and subscripts in Google sheets too. But until so, you lot tin effort to brand do with the higher up techniques.

If you have used MS Excel, you might know that in that location is an inbuilt format that allows yous to apace convert any text to subscript or subscript. I hope this is likewise implemented soon in Google Sheets.

I hope you found this Google sheets tutorial useful. If you are wanting to learn more than about superscripts and other primal features of Google Sheets we highly recommend Spreadsheet Fundamentals by DataCamp Form!

I would love to know if at that place are other techniques to add superscript and subscript in Google Sheets that are easier than the above.

You may too like the post-obit Google Sheets tutorials:

• How to Insert a Degree Symbol (°) in Google Sheets
• How to Zoom-In and Zoom-Out in Google Sheets
• How to Indent Text in Google Sheets
• How to Insert BULLET POINTS in Google Sheets
• How to change the default font in Google Sheets
• How to Insert the Euro Symbol (€) in Google Sheets

Source: https://spreadsheetpoint.com/subscript-and-superscript-in-google-sheets/

Share this post