Format text or numbers as superscript or subscript
※ Download: Subscript shortcut key
You can also use menu access keys. Apply superscript or subscript format Every time you want to format text in Excel, open the Format Cells dialog box. Characters SubR - 1, 1.
Or, you can download our sample workbook with all and open it alongside your own workbook. Alt + Shift + , Page up Alt + Up arrow Page down Alt + Down arrow Move to beginning of document Ctrl + Search + Left arrow Move to end of document Ctrl + Search + Right arrow Move to next misspelling Ctrl + ' Move to previous misspelling Ctrl + ; Insert or move to header holding Ctrl + Alt, press o then h Insert or move to footer holding Ctrl + Alt, press o then f Move focus to popup for links, bookmarks, and images holding Ctrl + Alt, press e then p Open chat inside the document Shift + Esc Move focus out of document text Ctrl + Alt + Shift + m Return focus to document text Esc Focus containing webpage such as when using Docs in Google+ Hangouts Ctrl + Shift + Esc. Not, I think, without a script that can identify those cases where it would be appropriate to apply it, and even then you'd need to run the script.
Insert subscript or superscript text - For example, to open the Insert menu on a Mac, press Ctrl + Option + i.
This tutorial will teach you a few quick ways to insert superscript and subscript in Excel, both for text values and numbers. 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. Superscript is a small letter or number typed above the baseline. If there is any preceding text in a cell, superscript is attached to the top of the regular sized characters. For 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. Subscript is a small character or string that sits below the line of text. In math, it is often used to write number bases like 64 8 or chemical formulas such as H 2O or NH 3. How to do superscript and subscript for text values Most Excel formatting can be applied to any data type in the same way. Superscript and subscript are a different story. The methods described in this section work only for text values, but not for numbers. 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. Apply superscript or subscript format Every time you want to format text in Excel, open the Format Cells dialog box. It allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want. In case of superscript and subscript, there is one hurdle. 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. 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. The selected text will be subscripted or superscripted depending on which option you've ticked off. Like any other formatting in Excel, it changes only visual representation of the value in a cell. The formula bar will display the original value without any indication of the applied superscript or subscript format. Keyboard shortcuts for superscript and subscript in Excel Although 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. Add Superscript and Subscript icons to Quick Access Toolbar 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. And now, you can simply select the text to be subscripted or superscripted in a cell or in the formula bar, and click the corresponding icon on the Quick Access Toolbar to apply the format: Moreover, a special keyboard shortcut is assigned to each Quick Access Toolbar button enabling you to subscript and superscript in Excel 2016 with a single key stroke! The key combinations vary depending on how many buttons your QAT accommodates. To find out the superscript and subscript shortcuts on your computer, hold the Alt key and look at the Quick Access Toolbar. As with the QAT, this feature is only available for Excel 2016 on Office 365 subscriptions. Because custom buttons can only be added to custom groups, you will have to create one. The subscript and superscript formats can also be deleted by pressing the respective or clicking the corresponding button on the and if such buttons are added in your Excel. Apply superscript and subscript format to numbers Below, you will find a few techniques to do superscript and subscript for numeric values. 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. How to write subscript and superscript in Excel To be able to type subscript and superscript in Excel, insert an equation in your worksheet. Alternatively, you can click the Ink Equation button and write your math using the mouse. If Excel understands your handwriting, it will show the preview correctly. Clicking the Insert button will insert your input in a worksheet. Caveats: This method inserts your math as an Excel object, not cell value. You can move, resize and rotate your equations by using the handles, but you cannot reference them in formulas. Excel superscript shortcuts for numbers Microsoft Excel provides an easy way to insert superscripted numbers in cells, as long as they are 1, 2, or 3. How to make superscript in Excel with a formula Another quick way to do superscript in Excel is by using the CHAR function with the corresponding code. 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. How to superscript and subscript in Excel with custom format If you'd like to add superscript to a range of numbers, a faster way would be creating a custom format. For example, to create a custom number format for superscript 3, type 0, press the Alt key, type 0179 on the numeric keypad, then release Alt. The superscripted numbers will look similar to this: To make a custom subscript format or superscript format with numbers other than 1, 2, or 3, copy the needed character from. To remove superscripts, simply set the cell format back to General. Caveat: Unlike the previous method, does not change the original value in a cell, it only changes the visual representation of the value. 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. How to do superscript in Excel with VBA In case you need to quickly add a certain superscript to the entire column of numbers you can automate the creation of a custom number format with VBA. Here is a simple one-line macro to add Superscript Two to all selected cells. For this, use Chr 176 , and your numbers will get formatted in this way: The step-by-step instructions on how to insert and run VBA code in Excel can be found. Or, you can download our sample workbook with all and open it alongside your own workbook. Then, in your workbook, press Alt + F8, select the desired macro, and click Run. Super easy way to superscript and subscript in Excel - copy and paste! Microsoft Excel does not provide shortcuts or character codes to insert superscripted numbers other than 1, 2 or 3. If you need Unicode subscript and superscript letters and symbols, you can copy them from this. That's how to use subscript and superscript formats in Excel. I thank you for reading and hope to see you on our blog next week! You can see the character set you are currently using and change to another set in Win 10 by: Open Control Panel, go to Clock, Language, and Region,select Region. Now the Region wizard opens and the Administrative tab is there. You can see your region and language and add a language if needed. However, this will change all the characters you use on your computer.
Spreadsheets and other specific apps like Excel, the various Adobe suites, and others. Alt + Shift +Page up Alt + Up arrow Page down Alt + Down arrow Move to beginning of document Ctrl + Search + Left arrow Move to end of document Ctrl + Search + Right arrow Move to next misspelling Ctrl + ' Move to previous misspelling Ctrl + ; Insert or move to header holding Ctrl + Alt, press o then h Insert or move to footer holding Ctrl + Alt, press o then f Move focus to popup for links, bookmarks, and images holding Ctrl + Alt, press e then p Open chat inside the document Shift + Esc Move focus out of document text Ctrl + Alt + Shift + m Return focus to document text Esc Focus containing webpage such as when using Docs in Google+ Hangouts Ctrl + Shift + Esc. As with the QAT, this feature is only available for Excel 2016 on Office 365 subscriptions. Once you've turned on subscript with the keyboard shortcut, you can then use the keypad to enter subscript numbers. Also, please be sure to carefully read the limitations of each method before using it in your worksheets. It would be nice to have a common solution that works across ALL apps and scenarios. subscript shortcut key You can see your region subscript shortcut key language and add a language if needed. Apply superscript and subscript format to numbers Below, you will find a few techniques to do superscript and subscript for numeric values. Uncommon fractions would require manual intervention. For 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.
