In this tutorial, we will explain and show what is superscript in Excel. As well as methods and shortcuts to add superscript easily and quickly.
If you are finding how possible to add superscript in Excel this guide is for you. Given that Microsoft Excel is known about numbers it can’t do all the tricks of MS Word. But it has its own way to unlock these tricks.
Prior to that, let’s define superscript in Excel…
What is Superscript in Excel?
The Superscript of Excel is part of the formatting style where smaller number or letter is placed above the preceding text. Usually, it is used to represent units like n², n³, or exponents in numerical equations like 22 or 2⁴.
So now, you will know how to add superscript in Excel separately in both numbers and text.
How to superscript in excel
It is the quickest way to convert normal text into a superscript.
- Select text to format as superscript.
Highlight the text you want to be converted to superscript dragging your mouse over it.
- Open Format Cells menu.
To do this simply, press Ctrl+1 or right-click the cell and select Format cells options. This will open the Format cells dialog box.
- Select Superscript checkbox.
In the Format cells dialog box, under the Font tab, inside the Effects group check the checkbox next to the Superscript option.
- Click OK.
Now you have superscript text. Please remember that it only changes the appearance of the text.
How to add superscript in Excel Using Ribbon
And now we are going to add add subscript or superscript button in Home tab ribbon quick access toolbar, making sure it is not cluttered with other buttons. Hence it will be easily accessed using excel ribbon.
Since the buttons can only be added by custom groups, you have to create one. Here’s how:
Anywhere in your ribbon, right-click and select customize the ribbon.
When the pop-up menu displays. Excel will open Options dialog box.
On the right section of the Excel Options Dialog box, under Customize the Ribbon. Then select your desired tab like Home Tab, click the New Group button.
Right-click your customize new group or click Rename Button to change the name of the newly added group. For instance, Scripts group. See the result below:
In the left-hand drop-down list, under Choose commands from, select Commands Not in the Ribbon, then choose Superscript in the list of commands and click Add.
Under Choose commands from from the left section part of dialog box dropdown list, select Commands not in the ribbon. Then find the Superscript command and then click Add. This will automatically add to the newly created group scripts.
In the same way, select the Subscript command on the list, then click add button again.
After you add your selected command just click OK to close the dialog box and save changes.
As a result, you can now access Superscript as well as Subscripts in Home tab ribbon.
Shortcut for superscript in excel
The keyboard shortcuts for superscript and subscript to access quickly are given to you below:
- Select the text if you want to format text as superscript.
- Press Ctrl+1.
- Press Alt+E.
- Press Enter.
As a result, you have now converted text to superscript. Please remember that it only changes the appearance of the text.
Superscript and subscript in excel With Equation
Now we are going to insert subscript and superscript in Excel utilizing equation in your worksheet. Here are the following ways to do it:
- On the Insert tab under symbol group choose Equation button.
- After you click the Equation button, this will take you to the design tab, selects the superscript option under structure group. Then select the desired style you want, for example superscript.
- Click the squares and enter your desired value, and guess what you are done!
Additionally, there is another way you can use to apply superscript. This is the Ink Equation button, it allows you to input your equation using the mouse.
Just make sure that excel will be able to read your handwritten. Whenever you click the insert button it inserts on your worksheet.
Note: The method we use above will insert as cell value rather an Excel object. The good thing is you can move, resize and rotate the inserted equations using handles.
To learn more about subscript you can read this article Subscript in Excel Quick Method To Add With Shortcut.
Add Superscript in Excel Using Shortcuts for Numbers
Except from the alternative way above, Microsoft Excel provides another easy way to add superscripted numbers in cells however it is limited to 1, 2, or 3 only. To do this simply enter the following key and numbers below:
Superscript | Shortcut |
1 | Alt+0185 |
2 | Alt+0178 |
3 | Alt+0179 |
Using these shortcuts it can be easy to add superscripts in blank cells of your worksheets and put them together with existing numbers:
Reminders: The superscripted numbers in this matter is now a numeric strings. It means that you are not able to perform calculations using this value. Thus it only works for Calibri and Arial text font styles, if you are using other fonts, the character code may vary.
Conclusion
In conclusion, this topic about superscript in Excel is a great help and creative in working with Excel spreadsheets. Another thing, superscripts and subscripts can be done through format applications, inserting special characters or even with math equations.
However, what is the best guide still depends on what requires you.
Have you ever used the given method above? Let us know by leaving your insights below.
Thank you for reading 🙂