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 cant do all Word tricks.

If there is any preceding text in a cell, superscript is attached to the top of the regular sized characters.

The methods described in this section work only for text values, but not for numbers.

Why I believe only the Microsoft team know the exact reason:) Possibly because this would convert numbers to strings and they want to prevent you from accidentally mangling your data.

It allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want.

You cant just apply the format normally to the entire cell because this would move all the text above or below the baseline, which is almost certainly not what you want.

For this, double click a cell and select the text using the mouse.

Or you can go the old-fashioned way - click the cell and press F2 to enter edit mode.

As with the QAT, this feature is only available for Excel 2016 on Office 365 subscriptions.

Please keep in mind that some of the methods convert numbers to strings, while others change only a visual display of the value in a cell.

To see the actual value behind a superscript, look at the formula bar.

Also, please be sure to carefully read the limitations of each method before using it in your worksheets.

If Excel understands your handwriting, it will show the preview correctly.

Clicking the Insert button will insert your input in a worksheet.

You can move, resize and rotate your equations by using the handles, but you cannot reference them in formulas.

Simply type the following numbers on the numeric keypad while holding down the Alt key.

In this case, you concatenate the CHAR function with the original number and enter the formula in the next column.

Please notice the left-aligned values in column B and right-aligned numbers in column A in the screenshot above.

For example, to insert superscript 5, set up a custom format with this code: 0.

In the above screenshot, you can see 1 in cell A2, but the formula bar displays 1, meaning the actual value in the cell is 1.

If you reference A2 in formulas, its real value (the number 1) will be used in all calculations.

For this, use Chr(176), and your numbers will get formatted in this way.

Excel For Mac Subcript Wont Work