When we are working with Google Sheets, we might need to add chemical formulas or statistical data for some or other purposes. However, adding subscript or superscripts in Google Sheets is not frequent since we don’t use this feature regularly. Though this is not a commonly used feature, we might fall under circumstances where we might need to add Subscript or Superscript.
As Google Sheets doesn’t have an inbuilt feature of inserting subscript or superscript, we can simply get this done using mathematical formulas. On this page let us understand everything about how to add subscript and superscript with the help of Google Sheets Tips. Read further to find more.
What are Subscript and Superscript?
Subscripts and superscripts are smaller characters than the body of the book. Superscripts are placed above the normal text, whereas subscripts are placed below the normal text.
Example of Subscript and Superscript:
- CH3 is a superscript
- 4² is a superscript
Using Google Sheets CHAR() Function To Add Subscript and Superscript
We can simply add subscript and superscripts in Google Sheets using the Character function. By incorporating ASCII code with the CHAR function, we can simply create subscript or superscript. Let us understand how to do this in the below section.
- How to Strikethrough in Google Sheets: 3 Easy Shortcut Methods
- How to Insert Bullets in Google Sheets: Adding Bullets in MAC, IOS, Android
- How To Highlight Blank or Errors in Google Sheets? (Using Conditional Formatting)
How To Add Subscript in Google Sheets?
Let us say, we need to add generate a subscript text as CH3 in Google Sheets. The steps to get this done are as follows:
- 1st Step: Open the Google Spreadsheet.
- 2nd Step: Now on the homepage, move to the cell where you need to create a subscript text – CH3.
- 3rd Step: Here type CH normally.
- 4th Step: To add 3 as a subscript, we need the ASCII code of 3. The subscript code of 3 is 8323.
- 5th Step: Now type the formula as =char(8323).
- 6th Step: To get the formula CH3 in the cell, type the formula =”H”&”H”&CHAR(8323).
That’s it, The subscript has been generated.
ASCII Codes To Add Subscript In Google Sheets
To add numbers as a subscript, use the codes tabulated below:
To add characters as a subscript, use the codes tabulated below:
How To Add Superscript in Google Sheets?
The steps to add superscript in Google Spreadsheet are as follows:
- 1st Step: Open the Google Spreadsheet where you want to insert the Superscript.
- 2nd Step: Now on the homepage, move to the cell where you want to insert the Superscript.
- 3rd Step: In this example, we are trying to add 4². Since we need to add 2 as superscript, we need to use the ASCII code of the 2. The ASCII code of 2 is 178.
- 4th Step: Now type the formula =”4″&CHAR(178).
That’s it. The superscript has been added in the Google Sheets as shown below.
ASCII Codes To Add Superscript in Google Sheets
To add numbers as a superscript, use the codes tabulated below:
To add characters as a superscript, use the codes tabulated below:
Using Unicode Symbols To Add Subscript and Superscript in Google Sheets
Apart from ASCII codes, we can also add Subscript and Superscripts using the Unicode symbols. The steps to add Subscript or Superscript using the Unicode symbols are as follows:
- 1st Step: Visit third-party websites such as www.unicode-table.com.
- 2nd Step: Now on the homepage, click on the “See All” tab.
- 3rd Step: Scroll down and move to the section “Superscript and Subscript Numbers“.
- 4th Step: Click on the subscript or superscript which you would like to copy and click on the “Copy” button.
- 5th Step: Now the Subscript or Superscript has been copied to the clipboard. Move to the Google Spreadsheet where you want to paste the Subscript or Superscript,
- 6th Step: Press “Cntrl+Shift+V“. That’s it the subscript or superscript has been pasted in the Google Sheets.
Using Subscript or Superscript Generator in Google Sheets
The steps to add Subscript or Superscript in Google Spreadsheet using the Subscript and Superscript generator are as follows:
- 1st Step: Open the search engine and type Subscript or Superscript generator. I mostly use the website “Subscript/Superscript Generator” – https://lingojam.com/SuperscriptGenerator.
- 2nd Step: Now type the character or number which needs to be converted as Subscript or Superscript.
- 3rd Step: The Subscript or Superscript is generated to the right side of the window.
- 4th Step: Copy the character and move to the Google Spreadsheet where you want to paste.
- 5th Step: Paste the character or number using “Cntrl+Shift+V“.
That’s it. The Subscript or Superscript has been inserted into the Google Sheets.