The users of Excel 2016 on Office 365 subscriptions, have the ability to add the Subscript and Superscript buttons to their Quick Access Toolbar (QAT). Hit the Enter key to apply the formatting and close the dialog.Īdd Superscript and Subscript icons to Quick Access Toolbar.
Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.Press Ctrl + 1 to open the Format Cells dialog box.Select one or more characters you want to format.Please pay attention that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn: Keyboard shortcuts for superscript and subscript in ExcelĪlthough there is no shortcut in its pure sense to add subscript or superscript in Excel, this can be done with a couple of key combinations. The formula bar will display the original value without any indication of the applied superscript or subscript format. Like any other formatting in Excel, it changes only visual representation of the value in a cell. Click OK to save the change and close the dialog.ĭone! The selected text will be subscripted or superscripted depending on which option you've ticked off.In the Format Cells dialog box, go to the Font tab, and select Superscript or Subscript under Effects.Open the Format Cells dialog by pressing Ctrl + 1 or right-click the selection and choose Format Cells… from the context menu.Or you can go the old-fashioned way - click the cell and press F2 to enter edit mode. For this, double click a cell and select the text using the mouse. Here are the steps to insert subscript or superscript correctly: You can't 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. In case of superscript and subscript, there is one hurdle. It allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want. Apply superscript or subscript formatĮvery time you want to format text in Excel, open the Format Cells dialog box. 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. The methods described in this section work only for text values, but not for numbers.
Superscript and subscript are a different story. Most Excel formatting can be applied to any data type in the same way.
#How to make a superscript number in html how to
How to do superscript and subscript for text values In math, it is often used to write number bases like 64 8 or chemical formulas such as H 2O or NH 3. Subscript is a small character or string that sits below the line of text. If there is any preceding text in a cell, superscript is attached to the top of the regular sized characters.įor example, you can use superscript to write square units like m 2 or inch 2, ordinal numbers such as 1 st, 2 nd, or 3 rd, or exponents in math such as 2 3 or 5 2. Superscript is a small letter or number typed above the baseline. What is superscript and subscript in Excel?
Microsoft Office users sometimes wonder why a particular feature is present in one Office application and absent in another. This tutorial will teach you a few quick ways to insert superscript and subscript in Excel, both for text values and numbers.
0 kommentar(er)
