How to Add Subscript and Superscript in Google Sheets

Google Sheets is a powerful and versatile tool where you can work with all types of data. However, when it comes to formatting text, you may miss some of the basic features of word processors, like the ability to add indentation, bullet points, or subscripts and superscripts. Fortunately, even though there’s no built-in tool for this, there are several ways to do it.

In this guide, you will learn three different ways of adding subscripts and superscripts in Google Sheets. The first method involves copying and pasting from an external source, while the second method involves the use of the CHAR function. However, the third method will speed things up considerably if you need to use subscripts and superscripts frequently, the third method will speed things up considerably. You will learn how to import the Unicode subscript and superscript characters using IMPORTHTML so you can copy and paste them easily.

How to Add Subscript in Google Sheets?

Below, you have two methods for adding subscripts in Google Sheets: copy & paste and the CHAR function.

Insert Subscript with Copy & Paste

Follow the steps below to copy the subscript character and paste it into a cell in Google Sheets. For this example, I will use the Wiktionary Appendix on Unicode subscripts and superscripts.

1. 1. Go to the website and select the subscript you want to use. In this case, I want to add the subscript ‘x’ to the word ‘total’.
   

1. 2. Copy the subscript.
   

1. 3. In Google Sheets, double-click on the cell where you want to add the subscript and place the cursor where you want it.

1. 4. Right-click or use the shortcut to paste: Ctrl + v (Windows) Cmd + v (Mac).

Insert Subscript with CHAR Function

Follow the steps below to write a formula to concatenate text and subscripts using the ampersand (&) and the CHAR function. You can use the same page as in the previous section to find the code for the superscript character. The decimal code is between parentheses in the first column. The code for lowercase x is 8339.

1. 1. In an empty cell, type the equal sign. Between quotation marks, type the letter or word that requires the subscript.
   

1. 2. Add an ampersand (&), followed by the CHAR function.
   

1. 3. The code you use for the CHAR function depends on which subscript character you want. In this case, a lowercase x has the following decimal code: 8339.
   

1. 4. Close the parenthesis and press ‘Enter’ to see the result.
   

How to Add Superscript in Google Sheets?

Below, you have two methods for adding superscripts in Google Sheets: copy & paste and the CHAR function.

Insert Superscript with Copy & Paste

Follow the steps below to copy the subscript character and paste it into a cell in Google Sheets. For this example, I will use the number 2 superscript. Unfortunately, the superscripts for 1, 2, and 3 are listed on a separate table.

1. 1. Go to the website and find the superscript you want on the table.

1. 2. In Google Sheets, double-click on the cell where you want to add the superscript and place the cursor where you want it.
   

1. 3. Double-click on the cell you want to edit.

1. 4. Right-click or use the shortcut to paste: Ctrl + v (Windows) Cmd + v (Mac).

Insert Superscript with CHAR Function

Follow the steps below to write a formula to concatenate text and superscripts using the ampersand (&) and the CHAR function.

1. 1. In an empty cell, type the equal sign. Between quotation marks, type the letter or word that requires the superscript.
   

1. 2. Add an ampersand (&), followed by the CHAR function.
   

1. 3. The code you use for the CHAR function depends on which superscript character you want. In this case, the superscript of the number 2 has the following decimal code: 178.
   

1. 4. Close the parenthesis and press ‘Enter’ to see the result.
   

Import Unicode Subscripts & Superscripts

If you plan to use subscripts and superscripts frequently, consider importing the main subscript and superscript Unicode characters to make it easier on yourself. Once imported, you can use either of the abovementioned methods without leaving your spreadsheet. I will import the table from the Wiktionary Appendix on Unicode subscripts and superscripts. However, you can use whatever source you prefer.

1. 1. In separate cells, type the URL and the HTML element.
   

1. 2. In another cell, type the IMPORTHTML function and select the cell containing the URL.
   

1. 3. Add a comma and select the cell containing the HTML element.
   

1. 4. Add another comma and type the index of the table you want. In this case, it’s table 2.
   

1. 5. Close the parenthesis and press ‘Enter’ to import the table.
   

1. 6. Now that you have imported the table, you can easily use the copy & paste method to add subscripts and superscripts in your cells.
   

Conclusion

Google Sheets doesn’t have a built-in tool to add subscripts and superscripts, but there are several ways to do it. You know how to copy & paste subscripts or superscripts from an external source, like a web page or Google Docs. You also know how to use the CHAR function to add subscripts and superscripts with a formula.

However, if you plan to use them frequently, the third method can save you a lot of time. You can import the Unicode subscript and superscript characters to your spreadsheet using IMPORTHTML, so you can easily add them to your text using copy & paste. If you prefer to use the CHAR function, the imported table also includes the decimal codes.

To learn more about formatting text in Google Sheets, check out our guides on:

• How to Indent in Google Sheets (+ Examples)
• How to Add Bullet Points in Google Sheets (4 Ways)
• How to Insert a New Line in a Cell in Google Sheets
• TEXTJOIN in Google Sheets (Easy Guide)