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. Please pay attention that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn:. Here are the steps for this one-time setup:. 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 with a single key stroke!
The key combinations vary depending on how many buttons your QAT accommodates.
How do I type superscripts and subscripts using keyboard shortcuts?
To find out the superscript and subscript shortcuts on your computer, hold the Alt key and look at the Quick Access Toolbar. For me, they are as follows:. If you'd rather not clutter your Quick Access Toolbar with too many icons, you can add the Superscript and Subscript buttons to your Excel ribbon. Because custom buttons can only be added to custom groups, you will have to create one. Here's how:.
Format text as superscript or subscript - Office Support
Now, you can subscript and superscript in Excel by clicking the corresponding button on the ribbon:. The subscript and superscript formats can also be deleted by pressing the respective keyboard shortcut or clicking the corresponding button on the ribbon and QAT if such buttons are added in your Excel. 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. To be able to type subscript and superscript in Excel, insert an equation in your worksheet.
Here's how you can do this:. 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. You can move, resize and rotate your equations by using the handles, but you cannot reference them in formulas.
Microsoft Excel provides an easy way to insert superscripted numbers in cells, as long as they are 1, 2, or 3. By using these shortcuts, you can type superscripts in empty cells and attach them to existing numbers:. Another quick way to do superscript in Excel is by using the CHAR function with the corresponding code. This method comes in handy when you'd like to preserve the original numbers. In this case, you concatenate the CHAR function with the original number and enter the formula in the next column.
Caveat : As with the previous method, the formula output is a string , not number. Please notice the left-aligned values in column B and right-aligned numbers in column A in the screenshot above. 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 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 here.
Caveat : 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:.
tancandcaten.tk 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.
- Subscript shortcut!
- How to Do Superscript in Word.
- adobe photoshop free trial for mac.
I thank you for reading and hope to see you on our blog next week! Tdat: 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: 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. 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"?? None of these work there. It uses Unicode as a base. I am running excel and the quick command for superscripts and subscripts is not under "Commands Not in the Ribbon" as said in the "Add Superscript and Subscript icons to Quick Access Toolbar" section of this article.
It is not even in "All Commands".
Leave a Reply
Hello do you have any idea how to set superscript into auto correct? Is there a way to make letter subscripts e. 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 pm. Doug says:. June 19, at pm. August 14, at pm. Raheem says:. September 26, at pm. Home Questions Tags Users Unanswered. Shortcuts for subscript and superscript Word , Mac Ask Question. Asked 2 years, 9 months ago. Active 2 months ago. Viewed 2k times. I am using Word on a macbook air with a danish keyboard.
Is plus above equals on that keyboard? That's what it's expecting, so super is 'shifted' sub.
- Shortcuts for subscript and superscript Word , Mac - Super User.
- Format text as superscript or subscript.
- barra de ferramentas do mac sumiu.
- Category: Capital;
- How to Do Superscript in Word.
TomEus TomEus 3, 13 13 silver badges 30 30 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.