Then, put the number you want to be displayed in superscript format, i.e.: Put the digit you want displayed normally in a column, set up like it is in 'A1' below, i.e.:
Please notice that these are not "formatted" numbers, but special symbols with no numeric value. Superscripts 1, 2 and 3 are located in the subset "Latin-1 Supplement".Īnd so on.
Insert now each character in its corresponding cell be sure to use "Superscript Minus" for negative numbers. In the tab "Symbol", change the comboboxes "Font" to "(normal text)" and "Subset" to "Superscripts and Subscripts". In the second column, "Superscript", go to Excel Ribbon Insert > Symbol. In the first column, "Digit", just type something like: Somewhere else, build a simple table with a map from "Digit" numbers to "Superscript" numbers. Experiment with each of these methods until you find one (or a combination of methods) that works best for your needs.I also found a way to make this work without using concatenate, it just requires making a table to map to superscript numbers. Which method you use will ultimately depend on your personal preferences and what works best for you. Tip: Although Excel doesnt have quick keyboard shortcuts to these commands. If you press and hold down both of these keys at the same time and then press Enter, all of the selected text will be formatted as superscript text.Īs you can see, there are a few different ways that you can go about specifying superscript text in Excel. Under Effects, check the Superscript or Subscript box, and click OK. Both of these keys are located above the Enter key on most keyboards. Now, with the cell containing the symbol selected, click in the Formula Bar. To do this, simply highlight the text that you want to format and then hold down the Ctrl key while pressing either the Shift key or the Equals sign key (=). Select any empty cell and go Insert>Symbol and insert the symbol required. You can also use shortcut keys to format existing text as superscript text. Just make sure that you release the Ctrl key after you have inserted all of the characters that you want to be superscripted. In Ms- Word, with your keyboard, type in the text you want to subscript. If you wanted to insert multiple characters as superscript text, you could do so by holding down the Ctrl key and pressing the 1 key multiple times. Inserting specific characters in superscript Click in the Google Docs document where you want to insert the character. For example, if you wanted to insert the character "1" as superscript text, you would simply hold down the Ctrl key and press the 1 key on your keyboard (Ctrl+1). Please remember that it only changes the appearance of the text. You have successfully converted your selected text into a superscript using shortcuts. Hello Everyone Welcome to My Channel (Education Ashok) I Provide Computer Education video like Ms Word Tutorial, Ms Excel Tutorial, Ms PowerPoint Tutorial, P. Select the text you wish to convert to superscript. This will insert the character or characters into your worksheet as superscript text.Īnother way that you can specify superscript text in Excel is by using shortcut keys. Keyboard Shortcuts to Superscript in Excel To make the process quicker you can use this shortcut. Now the select part text has been formatted as superscript or subscript. Finally, find the character or characters that you want to insert as superscript text and double-click on it/them. Then press Ctrl + Shift + F to open the Format Cells dialog, then press Alt + E to format as superscript or Alt + B to format as subscript, or you can check Superscript or Subscript option in Effects section as you need in the popping dialog. Then, in the Subset drop-down menu, you will want to select the Superscripts and Subscripts option. Under the Effects group check the box of Subscript. Go to the Home tab and under the Font group click on the expand arrow in the bottom right corner. In the Font drop-down menu, you will want to select the Normal Text option. Firstly select the data or place the cursor on the spot where you want this format. This will bring up the Symbol dialog box. Remove the check mark beside Subscript and/or Superscript. Go to the Font section and click on the little arrow in the lower right corner. From here, you will want to click on the Symbol button which looks like a pi symbol. Select the text or numbers that have the superscript or subscript formatting you want to remove. To access this dialog box, simply click on the Insert tab and then click on the Symbols group. When it comes to superscript text in Excel, there are a few different ways that you can go about specifying this type of text.