keyboard shortcut for subscript and superscript in excel

If we use the cell in any formulae, the real value (formula bar value) will be used for calculation. Unlike the previous method, this only changes the cell’s visual representation, not the cell’s real value (we can check the difference by checking the ing value in the formula bar and the cell). Like the previous method, this formula output is a string, which we cannot use for calculations in Excel. We can also use the “CHAR” function for superscript typing numbers.

The superscripted number or the number written with this is converted into “Number String.” That is why we cannot use these values for calculation. The specified shortcuts will only work if the font is “Calibri” or “Arial.” If we have selected any other font, then the characters may be different, which we get after typing these codes. To do the same, we must press some numbers while pressing the “Alt” key. MS Excel also offers us to type superscript numbers (only 1, 2, and 3) using the Alt key. We can move, resize and rotate the equations by using the handles, but we cannot reference them in formulas. This method inserts math as an Excel object, not a cell value.

Press the “Enter” key to apply the formatting and close the dialog.Īfter we click the “Insert” button, the text will appear in the text box.Then, press “Alt + E” to select the “Superscript” option in Excel.The formatting of the cell depends upon the nature of the data present. Next, press “ Ctrl+Shift+F” to open the Format Cells dialog box Format Cells Dialog Box Formatting cells is an important technique to master because it makes any data presentable, crisp, and in the user's preferred format.First, we must select one or more characters we want to format.Instead, each key combination should be pressed and released in turn: Please note that we should not press the keys simultaneously. We could also use the shortcut key, Ctrl+Shift+F, Alt+e. In the dialog box, we can tick the checkbox of “Superscript” and then click on “OK.” #2 – Short Method read more, which is Ctrl+1, or we can click on the arrow placed at the bottom right of the “Font” group. To open the “Format Cells” dialog box, either we can use the shortcut in excel Shortcut In Excel An Excel shortcut is a technique of performing a manual task in a quicker way.To choose the text, either we can press F2 to enter into “Edit Mode” for the selected cell or double click on the cell and then select the text for applying the formatting. To select the required text, we want to make it a superscript.

You can download this Superscript Excel Template here – Superscript Excel Template #1 – Long method

Keyboard shortcut for subscript and superscript in excel