ShaneEllams Replied on April 15, I just ran into the same problem and came up with a quick and easy solution.
It is now quicker than if they where in the tool bar: I am running on a Mac. Thanks for marking this as the answer. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response? Since MS hasn't released any information on how to modify the ribbon, the short answer is "no".
What's more, since they for some incomprehensible reason didn't include the Subscript or Superscript commands in the list of commands that can be assigned to Toolbars or Keyboard Shortcuts via the Customize tools, they made it a bit difficult to put them anywhere else, either.
However, it IS possible to put both controls on a toolbar - the Formatting Toolbar, Standard Toolbar or a custom toolbar -by running a simple macro, e. Add Id: This site in other languages x. 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 here. For example, to insert superscript 5, set up a custom format with this code: To add subscript 3, use this code: Unlike the previous method, Excel custom number format does not change the original value in a cell, it only changes the visual representation of the value.
If you reference A2 in formulas, its real value the number 1 will be used in all calculations. 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. This macro can also be used to attach the degree sign to the numbers in the selected cells. For this, use Chr , 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 here.
Or, you can download our sample workbook with all superscript macros and open it alongside your own workbook. Microsoft Excel does not provide shortcuts or character codes to insert superscripted numbers other than 1, 2 or 3. But we know that the impossibility is nothing: Simply copy the subscripted and superscripted numbers and mathematical symbols from here:.
Apart from simplicity, this method has one more advantage - it allows you to add subscripts and superscripts to any cell value, text and numbers! If you need Unicode subscript and superscript letters and symbols, you can copy them from this Wikipedia article.
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!
The character returned is based on the character set used by your computer. You can see the character set you are currently using and change to another set in Win 10 by: 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. I tried the ctrl1 for superscript and it worked but the moment I move to the next bar it goes back to the same number without subcript.
When i use text inside an ''IF" formula i cannot change the formatting and all the superscripts and subscripts return to normal.
Is there any way to change the format inside the "IF"?? E-mail not published. What is superscript and subscript in Excel? Subscript is a small character or string that sits below the line of text. How to do superscript and subscript for text values Most Excel formatting can be applied to any data type in the same way. Apply superscript or subscript format Every time you want to format text in Excel, open the Format Cells dialog box. Here are the steps to insert subscript or superscript correctly: Select the text you'd like to format.
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. 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. Sub SuperscriptTwo Selection. June 18, at 3: Doug says: June 19, at 6: August 14, at 1: Raheem says: September 26, at 4: Chathura says: October 16, at George says: December 10, at 2: Binosh Augusthy says: January 19, at 7: Post a comment Click here to cancel reply. Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise.
We thank you for understanding!
Clicking the Insert button will insert your input in a worksheet. When i use text inside an ''IF" formula i cannot change the formatting and all the superscripts and subscripts return to normal. This site in other languages x. Microsoft Excel does not provide shortcuts or character codes to insert superscripted numbers other than 1, 2 or 3. Apply superscript or subscript To make text appear slightly above superscript or below subscript your regular text, you can use keyboard shortcuts. Development Tools. Because custom buttons can only be added to custom groups, you will have to create one.
Add-ins for Microsoft Excel - Calculate dates and time See all products. Add-ins Collection for Outlook These 8 tools will boost your inbox productivity and simplify your emailing routine. Plug-ins for Microsoft Outlook - Apps for Excel for Mac. Add-ins for Microsoft Excel online. Add-ins for Microsoft Outlook online.
Add-ons for Google Sheets. Add-ons for Google Docs. Add-ons for Microsoft Word - Find broken links. Development Tools. Create Office add-ins in. Actual versions Previous versions.
Contact us Support forum Frequently asked questions How to activate your license Corporate deployment Useful links.