Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > How to Superscript in Excel? (9 Best Methods)

How to Superscript in Excel? (9 Best Methods)

Note: This guide on how to add superscript in Excel is suitable for all Excel versions including Office 365. 

Have you ever wondered if it is even possible to add a subscript or superscript in Excel sheets? 

Yes, it is definitely possible to add them in Excel, and also as easy as in Microsoft Word. 

Related: 

How To Find Duplicates In Excel? The Best Guide

Excel Goal Seek—the Easiest Guide (3 Examples)

How to Delete a Pivot Table in Excel? 4 Best Methods

It’s probably one of the least known Excel formatting features. Because of this many Excel users resort to never using it altogether. 

In this guide, I will teach the simplest methods to add a superscript in Excel sheets. After reading this, you will be able to add them without compromising on time. 

I’ll cover:

Table Of Contents
  1. Superscript in Excel – An Overview
  2. How to Superscript in Excel for Text?
    • Format Text as Superscript in Excel
    • Keyboard Shortcuts to Superscript in Excel
    • Superscript Option in Quick Access Toolbar
    • Superscript Option in Excel Ribbon
  3. How to Type Exponents in Excel using superscript?
    • How to Type an Exponent Using the Equation Option?
    • How to Add Exponents Using the Ink Equation Option?
    • How to Type an Exponent Using Superscript Shortcuts?
    • How to Add Exponents in Excel using the Char Function?
    • Excel Superscript using Custom Category. 
    • How to do superscript in Excel?
    • What is the shortcut key for superscript?
  4. Let’s Wrapup 



Superscript in Excel – An Overview

Superscript is a formatting style where a smaller number or letter is typed above the preceding text. It is usually used to denote units like m², m³, or exponents in numerical equations like 2³ or 2⁴. 

Now I’ll show you, separately, how to add a superscript in Excel for both texts and numbers. 

How to Superscript in Excel for Text?

All the methods covered in this section, convert your data into a string. Hence, note that they cannot be used by any formula or equation in Excel, for calculations. 

Format Text as Superscript in Excel

It is the quickest way to convert a normal text into a superscript. 

  1. Just select the text you want to be converted to superscript.
superscript in excel
Select the text you want to convert to superscript
  1. Go to the Format cells dialogue box. You can do this either by using Ctrl+1 or by right-clicking on the cell and selecting Format Cells.
Click on the Format Cells button
Click on the Format Cells button
  1. In the Format cells menu, under the Font tab, inside the Effects group check the checkbox next to the Superscript option. 
Check the checkbox next to the Superscript option.
Check the checkbox next to the Superscript option.
  1. Click OK 

You have successfully converted your selected text into a superscript. Please remember that it only changes the appearance of the text. 

Keyboard Shortcuts to Superscript in Excel

To make the process quicker you can use this shortcut. 

  1. Select the text you wish to convert to superscript.
  2. Press Ctrl+1.
  3. Press Alt+E.
  4. Press Enter. 

You have successfully converted your selected text into a superscript using shortcuts. Please remember that it only changes the appearance of the text.

Also Read: 

How To Use Excel Countifs: The Best Guide

Excel Conditional Formatting -the Best Guide (Bonus Video)

The Best Excel Project Management Template In 2021

Superscript Option in Quick Access Toolbar

In Excel versions 2016 and later, including Office 365 you can have an option to add superscript buttons to the quick access toolbar. To do this, follow these steps:

  1. Click the drop-down button at the end of the quick access toolbar.
  2. Choose More Commands from the drop-down menu.



  3. Under the Commands Not in the Ribbon section, find and select the Superscript option and click the Add button.
     
Add the Superscript option to the Quick Access Tool Bar
Add the Superscript option to the Quick Access Tool Bar
  1. Click OK.

You have successfully added the superscript button to the quick access toolbar.



Now, just click on this button after selecting a  text, to convert it into a superscript.





You can also use the quick access toolbar shortcuts to do this. The shortcuts vary from user to user and are in the format of Alt + “Position of Quick Access the Button”. For example, if the superscript button is the 4th from left, then the shortcut is Alt+4.


Superscript Option in Excel Ribbon

Similarly, you have the option to add the superscript button to the Excel Ribbon in Excel versions 2016 and later. To do this, follow these steps:

  1. Right Click anywhere on the Excel Ribbon and click on the Customize the Ribbon option.
  2. In the Excel Options dialogue box, under the Customize the Ribbon section, select the desired tab where you want to place the superscript button.


  3. Click on the New Group button.
  4. Click on the Rename Button, to give this group a unique name. 
  5. In the drop-down list on the left side called Choose commands from,  select Commands Not in the Ribbon.
  6. Scroll and select Superscript from the commands list.






  7. Click Add and Hit OK. 

You have successfully added the superscript button to the Excel Ribbon.



Now, just click on this button after selecting a text, to convert it into a superscript. 

How to Type Exponents in Excel using superscript?

Now, let me show you how to type exponents in Excel using superscripts. This is applicable for numbers and other equation-type formats. 

Please remember that most of these methods either convert your numbers into strings or simply change their appearance to look like superscripts. 

Hence, be careful and check their values in the formula bar before using them inside any function or formulas. 

How to Type an Exponent Using the Equation Option?

To add Excel superscript using the equation option, just follow these steps. 

  1. Locate and click on the Equation button under the Insert tab in the Symbols group.



  2. In the Design tab which appears next, click on the Superscript format under the Script section of the Structures
    group.






  3. Select the location using the selection squares and type in the value. 

You have successfully added numerical superscripts to your Excel Sheet. You can now drag and change the position of this superscript if required. 

How to Add Exponents Using the Ink Equation Option?

There is no scarcity of options when it comes to adding equations with a superscript in Excel. 

You can just doodle your equation with your mouse to add these superscripts. 

Interesting isn’t it?

To do this:

  1. Click on the Ink Equation button.




  2. Doodle your equation using a mouse.

  3. If Excel recognizes your handwriting, it will automatically display the equation.





  4. If the equation is correct, click on the Insert button. 

You have now inserted an equation with superscript. Please note that this is just an Excel object, and will not be treated as a valid value or formula. Hence, it can not be used inside formulas or functions. 

How to Type an Exponent Using Superscript Shortcuts?

You can quickly add a numerical superscript in Excel, only for numbers 1,2, and 3 using the shortcuts Alt+0185, Alt+0178, and Alt+0179 respectively.

Please note that this will convert the entire number into a string, disabling it to be used inside formulas. 

How to Add Exponents in Excel using the Char Function?

To add superscript using char function, just concatenate the original number with Char(185), Char(178), and Char(179) for superscripts 1,2, and 3 respectively. 

Concatenate the Number and the superscript using the CHAR function
Concatenate the Number and the superscript using the CHAR function

Please note that this will convert the entire number into a string, disabling it to be used inside formulas. 

Excel Superscript using Custom Category. 

If you need to apply the same superscript to multiple cells, this method will come in handy. 

  1. Just select the cells you want to add superscripts to and go to the Format cells dialogue box using Ctrl+1.
  2. Select the Custom Category under the Number tab.
  3. In the Type box, enter 0.
  4. Immediately, hold down the Alt button and enter the Superscript Code. ( 0185, 0178 and 0179 for 1,2 and 3 respectively)




  5. Release the Alt button and click OK. 

For example, for a superscript of 3, I will enter, 0+Alt+0179, which will translate into 0^3. 

Excel will add the superscripts to all the selected cells uniformly. 

Please keep in mind that this will only change the appearance of the selected cells. Their values will remain the same. 

Suggested Reads: 

Create An Excel Dashboard In 5 Minutes – The Best Guide

Dynamic Dropdown Lists In Excel – Top Data Validation Guide

Predict Future Values Using Excel Forecast Sheet – The Best Guide

How to do superscript in Excel?

The easiest way to superscript in Excel is to use the Format Cells menu. Select the text you want to superscript and press “Ctrl+1” to access the Format Cells menu. Go to the Font tab and tick the checkbox next to the Superscript option.

What is the shortcut key for superscript?

The shortcut key for superscript in Excel is “Ctrl+1” followed by “Alt+E”. Select the part of the text you want to be changed into superscript and press “Ctrl+1” and “Alt+E” successively.

Let’s Wrapup 

In this guide, I have explained how to add an Excel superscript in a step-by-step manner. We also saw how to add superscripts for numbers, texts, and equations. If you have any doubts regarding superscripts or any other Excel feature, please let us know in the comments below. 

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Similar Posts

How to setup rules in Microsoft Outlook 2013 – Part 1

Tips and Tricks for Microsoft Word 2010 – Part 3

How to Use ISTEXT in Excel? With 3 Different Methods

Macros and Basic VBA in Excel – Recorded Webinar

How to Insert a Checkbox in Excel? 3 EASY Examples

Creating a New Presentation in PowerPoint 2016

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)