How to write st in excel?

1. For example, double click cell A1.

2. Select the value 2.

3. Right click, and then click Format Cells (or press Ctrl + 1).

The 'Format Cells' dialog box appears.

4. On the Font tab, under Effects, click Superscript.

5. Click OK.

Result:

6. Needless to say, a superscript effect cannot return a result. To square a number, use a formula like this:

Note: to insert a caret ^ symbol, press SHIFT + 6.

7. To format a character as subscript (slightly below the baseline), repeat steps 1-5 but at step 4 click Subscript.

Result:

8. Did you know that you can also insert equations in Excel? On the Insert tab, in the Symbols group, click Equation.

Note: equations in Excel are floating objects and do not return results.

Microsoft Excel is used for many purposes across many industries, so it’s no wonder the need to add superscripts or subscripts arises quite frequently.

Thankfully it’s very easy to insert subscripts and superscripts in Excel and there are quite a few options for this.

This blog post will show you 11 easy ways to add subscripts and superscripts in Microsoft Excel.

A lot of common formatting commands can be found in the Home tab in the Font, Alignment, or Number section.

Unfortunately, the Subscript and Superscript options are missing from these frequently used format options.

You can use either the subscript or superscript formats from the Format Cells menu.

Select any cell or range of cells that you want to apply the script format on.

Go to the Home tab and click on the launch icon in the lower right corner of the Font section to open the Format Cells menu.

You can also open the Format Cells menu using these two methods.

This will open up the Format Cells menu. Go to the Font tab and check either of the Superscript or Subscript options to format your text.

Here you can see the results of applying the subscript or superscript format to a cell as compared to regular text.

I just showed you how to apply the subscript or superscript format to the entire contents of a cell. But it’s usually the case that you’ll only want a part of your text to have superscripts or subscripts.

Just think of a math equation or molecular formula. These will only use scripts at certain places.

The good news is, it’s possible to apply the format to only part of a given text.

Click into the formula bar or press the F2 key to enter edit mode on a cell that contains the text to partially format.

Highlight the part of the text to format, then open the Format Cells menu with one of the following options.

Once the Format Cells menu is open, go to the Font tab and check one of the Superscript or Subscript options.

Unfortunately, you will need to repeat these steps if you want to apply the format to multiple parts of your text as you can’t highlight multiple parts of your text while in edit mode.

Here you can see a few examples of the possible format output when combining subscript and superscripts to multiple parts of the text.

This can make mathematical equations and molecular formulas much easier to read!

The quickest way to perform any action in Excel is certainly by using a keyboard shortcut when it’s available.

Luckily the subscript or superscript format can be applied by combining two keyboard shortcuts in succession.

There is a keyboard shortcut that will open the Format Cells menu with the Font tab active. From here, you can use the accelerator keys to check the subscript or superscript options.

Press the Ctrl + Shift + F keys to open the Format Cells menu. The Font tab is active!

In the effects section, you will notice the Superscript and Subscript options have a single letter underlined. This indicates the accelerator key which can be used to activate the option.

Hold the Alt key then press E on your keyboard to check the Superscript option.

Similarly, you can hold the Alt key and then press B on your keyboard to check the Subscript option.

With your chosen effect option checked, you can then press the Enter key to close the Format Cells menu and the format will be applied.

This is a much quicker method when applying these formats to multiple parts of your text!

If you find yourself using this format option quite a lot, then you might consider adding them to the Quick Access Toolbar (QAT).

This way, they will always be prominently available and ready to use with a single click.

Right-click on the QAT and choose the Customize Quick Access Toolbar option from the menu.

This will open up the Excel Options menu and allow you to add commands to your QAT.

Scroll down the list of commands and select Superscript or Subscript. Click on the Add button to add this to your QAT. Then press the OK button to close the Excel Options menu.

Now the commands will appear in your QAT ready to use!

The previous methods have shown you how to format the text as a subscript or superscript.

Formatting does not change the value, only the appearance of the value. Any two cells formatted differently but that contain the same value are considered equal to Excel.

There is another method that relies on using special characters for subscripts and superscripts instead of formatting.

The character choice is limited, but all the numbers and a few symbols are available.

You can insert any of the available script characters by going to the Insert tab and selecting the Symbol command.

This will open up the Symbols menu when you can select and insert many different characters.

Each of the selected characters will appear in your cell.

Each character seen in the Symbols menu has a unique keyboard sequence which will allow you to insert the character into Excel without using the Symbols menu.

This can be a quick way to insert your desired character without clicking through the symbols menu.

To insert any of the characters, hold the Alt key then type out the code in sequence from the numbers keypad of your keyboard.

For example, to insert the ³ symbol, hold the Alt key then press 0 1 7 9 in sequence on your number pad, then release the Alt key.

Above is a comma-separated list of all the number sequences that will produce a script character. Each number is followed by its character.

The symbols menu and the associate keyboard shortcut for each character are great ways to get script characters you want, but it might be easier to copy and paste from another source as needed.

Above are all the available subscript characters. You can copy and paste any of them into Excel.

Above are all the available superscript characters that you can copy and paste into Excel.

The CHAR function is another potential method you can use to generate script characters in Excel.

The CHAR function takes a number between 1 and 255 and returns the corresponding ASCII character.

You can use this function to return 3 of the superscript characters available.

For example, the above formula will produce ¹ as a superscript.

Similarly, you can pass 178 and 179 into the CHAR function to return ² and ³ respectively.

With the CHAR function, it is only possible to return 3 different superscripts and no subscripts.

There is a more useful function that can return any of the Unicode script characters.

The UNICHAR function takes an integer number and returns the associated Unicode character.

For example, the above formula will return the ⁰ superscript character.

Above is the full list of codes that will produce a script character followed by the character it returns when passed into the UNICHAR function.

There is another method for adding subscripts and superscripts that might be suitable.

This feature allows you to create equations with proper mathematical notation, including both subscripts and superscripts options.

The downside is this doesn’t create an equation inside a cell. It will create an equation that floats above the grid, similar to a shape or image.

To insert an equation, follow these steps.

Go to the Insert tab and click on the Equation command.

This will place an equation input box above the grid. When this is selected, you will see an Equation tab that appears in the ribbon.

This creates a template in the equation which you can then fill in with the required text. You can even add equation elements inside these to create subscripts on a superscript or any other combination.

Working with equations to get your desired output can be tricky at best.

But there is a feature that makes this as easy as writing the equation on paper! This is Ink Equations. It’s a feature that will translate your handwriting into an equation.

Go to the Draw tab and click on the Ink to Math command in the Convert section.

This will open up the Math Input Control dialog box where you can draw your equation.

As you draw inside the input box, Excel will convert it and show a preview of the equation above the drawing.

There are three handy options for when you mess up the drawing or Excel gets the conversion wrong.

When you are satisfied with the conversion in the preview, press the Insert button and the equation will be inserted above the grid.

Once the equation has been created and inserted using the Ink to Math command, you can select it and further edit it using the Equation tab in the ribbon.

This is usually a much quicker method for building complex equations, especially if you have a touch screen device.

After you add the subscript and superscript commands to the Quick Access Toolbar, it becomes a lot easier to format multiple parts of a string.

You will only need to highlight each part then click on the command in the QAT.

But imagine you have a long list of molecular formulas and you need to format all the numbers as subscripts. This could still be quite time consuming.

Is there a way to automate this?

Yes, you can use VBA to format any numeric substrings!

Press Alt + F11 to open the visual basic editor. Go to the Insert tab and select Module, then paste the following code into the editor.

The above code will loop through the cells in the active range. It then loops through each character of the text in each cell and formats it as a subscript if the character is a number.

You can use the same code to format the numbers with superscripts. Just replace the bolded part of the code with the above.

Now all you need to do is select a range of values in which you want to format numbers as scripts and run the macro. Press Alt + F8 to open the Macro menu then select the macro and press the Run button

This can be an amazing time saver as you no longer need to highlight each number and manually apply a script format.

There are many useful and creative ways you can use to add subscripts or superscripts into your Excel spreadsheets.

You can create subscripts and superscripts by applying format, inserting special characters, or creating math equations.

The best way for you will depend on your needs. If you only need the appearance of scripts in your data, then formatting will be the best choice. Otherwise, using a special character will be a suitable choice.

Formatting parts of your text as subscripts or superscripts can become tedious, but you can even automate this with VBA.

Microsoft Office users sometimes wonder why a particular feature is present in one Office application and absent in another. So is the case with superscript and subscript formats - available on the Word ribbon, they are nowhere to be found in Excel. Please remember, Microsoft Word is all about text and Excel is about numbers, it can't do all Word tricks. However, it does have a lot of tricks of its own.

• Open the table in Design View.
• In the Field Name column, select the first blank row, and then type a name for the field.
• Select the adjacent cell in the Data Type column, and then select Short Text from the list.
• Save your changes.

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:

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.

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.

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

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

To make the process quicker you can use this shortcut.

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

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:

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.

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:

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.

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.

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

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

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:

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.

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.

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.

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

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

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

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.