How to Insert Superscript in Google Sheets: A Quick Tutorial

Last Modified: February 14, 2024 - 2 min read

Hannah Recker

TL;DR: To use superscript in Google Sheets, select your text, go to ‘Format’ > ‘Text’ > ‘Superscript,’ or use Ctrl + . (Cmd + . on Mac). Remove superscript with the same steps.

How to Insert a Superscript in Google Sheets

This tutorial will walk you through how to apply and remove superscript in your Google Sheets

Step 1: Open Your Google Sheet

Open the Google Sheets document where you need to use superscript.

Step 2: Select the Text for Superscript

Click on the cell with the text you want to format. If you only want to superscript part of the text in a cell, double-click the cell and highlight the specific text.

Step 3: Applying Superscript

With your text selected, click on the ‘Format’ menu in the menu bar, hover over ‘Text,’ and then select ‘Superscript.’ Alternatively, you can use the keyboard shortcut Ctrl + . (Cmd + . on Mac).

Step 4: Removing Superscript

To remove superscript formatting, reselect the text or cell and follow the same path: ‘Format’ > ‘Text’ > ‘Superscript’, or use the keyboard shortcut again.

Tips for Using Superscript Effectively:

  1. Mathematical and Scientific Data: Use superscript for mathematical powers or chemical formulas to maintain accuracy and readability.
  2. Referencing and Footnotes: Apply superscript for reference numbers if you’re including footnotes or endnotes in your document.
  3. Consistency in Formatting: Ensure that your use of superscript is consistent throughout the document for professionalism and clarity.

Use GPT to Automatically Generate Formulas

Constantly searching for Google Sheets tutorials? You can use Coefficient’s free GPT Copilot to automatically generate any spreadsheet formulas, charts, pivots, and more. To use GPT Copilot, you need to install Coefficient. The install process takes less than a minute.

First, you’ll get started for free right from our website. 

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Follow along with the prompts to install. Once the installation is finished, return to Extensions on the Google Sheets menu. Coefficient will be available as an add-on.

Now launch the app. Coefficient will run on the sidebar of your Google Sheet. Select GPT Copilot on the Coefficient sidebar.

 use the Coefficient GPT Copilot’s Formula builder to calculate the number of comments per post

For this example, let’s test Formula Builder.

select formula builder

Type a description of a formula into the text box. Let’s calculate the student average if the score is above 50. Let’s type: Calculate the average score in column B if the score is above 50.

Then press ‘Build’. Formula Builder will automatically generate the formula from the first example.

Simply paste your Google Sheets formula in the desired cell.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies