How To Add Superscript in Google Sheets: 3 Easy Ways [2024]

Key Takeaways
  • Superscript and subscript formatting in Google Sheets enhances clarity and accuracy in documents, especially for mathematical, scientific, and professional applications.
  • Methods to add superscript include copying and pasting Unicode characters, using the CHAR function for specific superscript numbers, and, as a last resort for subscripts, changing font size.
  • Despite the absence of a built-in superscript feature in Google Sheets, creative workarounds like Unicode characters and the CHAR function allow for effective superscript and subscript representation.

Google Sheets stands out as a versatile tool that simplifies data management and presentation. Among its many features is the ability to apply superscript formatting, which can be particularly useful for anyone dealing with mathematical equations, scientific notations, or simply wanting to emphasize a piece of text. This subtle yet powerful feature allows users to elevate characters above the baseline, providing clarity and precision where needed.

And remember, while our text might be ascending to new heights, we’ll keep our feet firmly on the ground with a straightforward, no-frills guide that even your grandma could follow. So, let’s get started, and who knows, by the end of this article, you might find yourself looking at that tiny ‘2’ in H₂O with a newfound respect.

What is Superscript & Subscript?

Superscript and subscript in Google Sheets are text formatting styles that allow you to position text above (superscript) or below (subscript) the standard text line. These are commonly used in mathematical and scientific formulas to denote exponents, chemical compounds, and other specialized notations.

Superscript and Subscript in Google Sheets

READ MORE: How To Add Superscript in Google Docs? [4 Easy Methods]

Superscript is often used for:

  • Ordinal indicators, e.g., 1st, 2nd, 3rd, etc.
  • Exponents in mathematical expressions, e.g., for “x squared.”
  • References and footnotes in a document.

Subscript is commonly used for:

  • Chemical formulas, e.g., (H2O) for water.
  • Mathematical variables, e.g., (A2 + B2 = C2) in algebraic expressions.
  • Denoting bases in logarithms, e.g., (log2) for “log base 2.”

Benefits of using superscripts and subscripts:

  • Clarity: They help maintain clarity in expressions where certain elements need to be differentiated from the main text.
  • Accuracy: In scientific and mathematical contexts, they ensure an accurate representation of formulas and equations.
  • Professionalism: Documents look more professional and adhere to standard writing conventions.

How they can be helpful:

  • Education: They’re essential for students and educators when creating educational materials and assignments.
  • Research: Researchers can accurately present their findings, especially in fields like chemistry and physics.
  • Data Presentation: They allow for better data presentation in reports and analyses.

READ MORE: How to Fix Google Docs Superscript Not Working ➜

How to Add Superscript in Google Sheets?

Google Sheets does not currently have a built-in feature for superscript. However, the following methods are creative workarounds to achieve the desired effect.

Method 1: Copy and Paste Unicode Characters

  1. Go to a website like Graphemica, which allows you to search for Unicode characters.
    Go to Graphemica
  2. Type in the symbol you want, such as “superscript two.”

    Search for your desired superscript in the search bar at the top
  3. Copy the result (e.g., for superscript two, you would copy “²”).
    Right-click and copy the character to your clipboard
  4. Paste the copied character into your Google Sheet in the formula bar.
    Paste the copied character in the formula bar
  5. To get multiple superscripts next to each other, copy them multiple times (e.g., “¹²”).

Method 2: Use the CHAR Function

  1. Determine the ASCII number for the desired superscript character. For example, the ASCII number for “superscript two” is 178.
  2. Open a search engine and type in the keyword “ascii superscript” followed by the specific character you’re looking for. For instance, if you need the ascii value for “subscript three,” type “ascii subscript three” into the search bar. This will provide you with the ASCII number for the requested subscript.
    Search for your desired ascii value on Google
  3. Enter the CHAR function in your Google Sheet with the Unicode number: =CHAR (178).
    Use the Sheets formula = followed by the CHAR function to display the superscript in the desired cell
  4. This will display the corresponding superscript character in the cell.

Method 3: Change Font Size (Last Resort)

NOTE: This method is more suitable for adding subscripts rather than superscripts. When you decrease the size of a character in Sheets, it aligns to the bottom of the cell by default, which is the standard position for a subscript. And it becomes challenging to position it at the top where a superscript is usually placed.
  1. Enter your text in a cell in Google Sheets.
  2. Select the portion of the text you want to be in superscript.
  3. Change the font size of the selected text to a smaller size than the rest of the text to create a superscript effect.
    Select the character you want to display as subscript and decrease its size

There you have it! These workarounds allow you to continue using Google Sheets for tasks that require formatting such as superscripts, even though the application’s toolbar does not directly support it. Remember to use these features judiciously to enhance the readability and professionalism of your documents.

READ MORE: How to Get Dark Mode in Google Sheets – Desktop & Mobile ➜


The superscript feature in Google Sheets enhances data presentation by allowing annotation of equations, citing sources, and emphasizing points. Despite being small, superscripts are crucial for clear communication. Mastering this feature enhances precision and attention to detail in your work.

Remember, even small features like superscripts can greatly impact clarity and effectiveness in your projects. Thank you for reading this guide. We hope you feel more confident in using it for your projects and gained insights for better spreadsheet management.


Is there a built-in option to add superscript in Google Sheets?

Currently, there is no built-in feature for superscript in Google Sheets. Users typically use Unicode characters or the CHAR function to achieve this.

What are some common superscript Unicode characters I can use in Google Sheets?

Some common superscript characters include ⁰, ¹, ², ³, and so on. You can find a complete list of these characters on Unicode character databases online.

How do I remove superscript formatting in Google Sheets?

Since Google Sheets doesn’t have direct formatting options for superscript, you would need to replace the superscript characters with regular text.

Are there any third-party add-ons for superscript in Google Sheets?

Some third-party sites and add-ons can help you with superscript and subscript formatting in Google Sheets.

Will superscript characters copy over correctly when I export from Google Sheets to Excel?

Yes, when you export your Google Sheets to Excel, the superscript characters should retain their formatting.

Can I use keyboard shortcuts to insert superscript in Google Sheets?

There are no direct keyboard shortcuts for inserting superscript in Google Sheets. However, you can use keyboard shortcuts to access the CHAR function or copy-paste methods more quickly.


Abdullah Amin

Abdullah is passionate about staying up-to-date on the latest trends and developments in the gaming industry. With a strong background in writing and research, he is able to provide in-depth analysis and informative articles for a wide range of gaming audiences.