How To Put A Subscript In Excel
This tutorial will teach you a few quick means to insert superscript and subscript in Excel, both for text values and numbers.
Microsoft Office users sometimes wonder why a detail feature is present in ane Office application and absent-minded in some other. And then is the case with superscript and subscript formats - bachelor on the Give-and-take ribbon, they are nowhere to be found in Excel. Delight think, Microsoft Word is all most text and Excel is about numbers, it can't exercise all Word tricks. However, it does have a lot of tricks of its own.
What is superscript and subscript in Excel?
Superscript is a small letter or number typed above the baseline. If there is whatever preceding text in a prison cell, superscript is attached to the superlative of the regular sized characters.
For example, you can utilize superscript to write square units similar chiliad2 or inch2, ordinal numbers such equally 1st, iind, or 3rd, or exponents in math such every bit 23 or 52.
Subscript is a small-scale character or string that sits below the line of text.
In math, it is oft used to write number bases like 64eight or chemical formulas such as H2O or NH3.
How to do superscript and subscript for text values
Almost Excel formatting can be applied to whatever data type in the same way. Superscript and subscript are a different story. The methods described in this section work only for text values, just not for numbers. Why? I believe only the Microsoft team know the exact reason :) Perhaps because this would convert numbers to strings and they want to preclude you from accidentally mangling your data.
Apply superscript or subscript format
Every time y'all want to format text in Excel, open the Format Cells dialog box. Information technology allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want.
In example of superscript and subscript, there is one hurdle. Y'all can't but utilize the format usually to the entire jail cell because this would movement all the text higher up or beneath the baseline, which is almost certainly non what you want.
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 yous can get the old-fashioned way - click the cell and press F2 to enter edit mode.
- Open the Format Cells dialog by pressing Ctrl + i or right-click the option and cull Format Cells… from the context card.
- In the Format Cells dialog box, go to the Font tab, and select Superscript or Subscript under Effects.
- Click OK to relieve the change and close the dialog.
Done! The selected text volition be subscripted or superscripted depending on which option you've ticked off.
Note. Similar any other formatting in Excel, it changes but visual representation of the value in a prison 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 together subscript or superscript in Excel, this can exist done with a couple of key combinations.
Excel superscript shortcut
Ctrl + 1, and so Alt + E, and then Enter
Excel subscript shortcut
Ctrl + 1, then Alt + B, and so Enter
Please pay attention that the keys should not be pressed simultaneously, each central combination should be pressed and released in turn:
- Select one or more than characters you desire to format.
- Press Ctrl + 1 to open the Format Cells dialog box.
- Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.
- Hit the Enter cardinal to apply the formatting and shut the dialog.
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). Here are the steps for this old setup:
- Click the down pointer next to the QAT in the upper left corner of the Excel window, and cull More Commands… from the popular-up menu.
- Under Choose commands from, select Commands Not in the Ribbon, scroll down, select Subscript in the list of commands, and click the Add together button.
- In the same way, add together the Superscript button.
- With both buttons added to the list of commands on the right pane, click OK to save the changes.
And now, yous can but select the text to be subscripted or superscripted in a cell or in the formula bar, and click the respective 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 lot to subscript and superscript in Excel 2016 with a single key stroke! The fundamental combinations vary depending on how many buttons your QAT accommodates.
To detect out the superscript and subscript shortcuts on your estimator, hold the Alt key and look at the Quick Access Toolbar. For me, they are as follows:
- Subscript shortcut: Alt + 4
- Superscript shortcut: Alt + 5
Add Subscript and Superscript buttons to Excel ribbon
If you'd rather non ataxia your Quick Access Toolbar with too many icons, yous can add together the Superscript and Subscript buttons to your Excel ribbon. As with the QAT, this feature is just available for Excel 2016 on Office 365 subscriptions.
Because custom buttons can only be added to custom groups, you will accept to create one. Here'due south how:
- Right-click anywhere on the ribbon and select Customize the Ribbon… from the pop-upwardly bill of fare. This opens the Excel Options dialog box.
- In the right function of the dialog box, under Customize the Ribbon, select the desired tab, say Dwelling, and click the New Group push button.
- Click the Rename button to give the newly added grouping a name y'all similar, e.g. My Formats. At this bespeak, you will take the post-obit outcome:
- In the left-hand drib-downwardly list, nether Choose commands from, select Commands Not in the Ribbon, then cull Superscript in the list of commands, and click Add.
- Next, select Subscript in the list of commands and click the Add button again.
- Click OK to save the changes and shut the dialog box.
Now, you can subscript and superscript in Excel by clicking the respective push button on the ribbon:
How to remove subscript and superscript formatting in Excel
Depending on whether y'all want to remove all or particular subscripts/superscripts in a cell, select the unabridged cell or only the subscripted/superscripted text, and do the following:
- Press Ctrl + one to open the Format Cells… dialog box.
- On the Font tab, clear the Superscript or Subscript checkbox.
- Click OK.
The subscript and superscript formats can also be deleted by pressing the respective keyboard shortcut or clicking the corresponding push button on the ribbon and QAT if such buttons are added in your Excel.
Apply superscript and subscript format to numbers
Below, yous will observe a few techniques to do superscript and subscript for numeric values. Delight continue in listen 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. As well, 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 exist able to type subscript and superscript in Excel, insert an equation in your worksheet. Here's how you tin do this:
- Become to the Insert tab, Symbols group, and click the Equation button.
- This volition take y'all to the Design tab, where you click the Script button in the Structures group, and select the desired format, for example Superscript.
- Click the squares, type your values, and y'all are done!
Alternatively, you can click the Ink Equation button and write your math using the mouse. If Excel understands your handwriting, information technology will show the preview correctly. Clicking the Insert button volition insert your input in a worksheet.
Caveats: This method inserts your math as an Excel object, not cell value. Yous can move, resize and rotate your equations by using the handles, simply yous cannot reference them in formulas.
Excel superscript shortcuts for numbers
Microsoft Excel provides an piece of cake style to insert superscripted numbers in cells, equally long as they are 1, two, or three. Simply blazon the post-obit numbers on the numeric keypad while belongings down the Alt key:
Superscript | Shortcut |
1 | Alt+0185 |
2 | Alt+0178 |
iii | Alt+0179 |
By using these shortcuts, you lot can blazon superscripts in empty cells and attach them to existing numbers:
Caveats:
- These shortcuts piece of work for Calibri and Arial If y'all are using some other font, the character codes may be different.
- The numbers with superscripts are turned into numeric strings, significant you won't be able to perform whatsoever calculations with them.
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 respective code.
Superscript1 formula: =CHAR(185)
Superscripttwo formula: =CHAR(178)
Superscript3 formula: =CHAR(179)
This method comes in handy when you'd similar to preserve the original numbers. In this case, y'all concatenate the CHAR function with the original number and enter the formula in the next cavalcade.
For example, that's how you lot can add superscript two to the number in A2:
=A2&CHAR(178)
Caveat: As with the previous method, the formula output is a string, not number. Please notice the left-aligned values in cavalcade B and right-aligned numbers in column A in the screenshot to a higher place.
How to superscript and subscript in Excel with custom format
If you'd like to add together superscript to a range of numbers, a faster manner would be creating a custom format. Here's how:
- Select all the cells to be formatted.
- Press Ctrl + 1 to open the Format Cells… dialog.
- On the Number tab, under Category, select Custom.
- In the Type box, enter 0, which is the digit placeholder, then agree the Alt primal as you lot type the respective superscript lawmaking.
For case, to create a custom number format for superscript 3, type 0, printing the Alt key, blazon 0179 on the numeric keypad, then release Alt.
- Click OK.
The superscripted numbers volition expect similar to this:
To brand a custom subscript format or superscript format with numbers other than ane, ii, or 3, copy the needed character from here. For example, to insert superscript 5, gear up up a custom format with this code: 0⁵. To add subscript three, employ this code: 0₃.
To remove superscripts, simply set up the cell format dorsum to Full general.
Caveat: Unlike the previous method, Excel custom number format does non change the original value in a cell, it simply changes the visual representation of the value. In the above screenshot, you lot can meet 1³ in cell A2, but the formula bar displays 1, meaning the actual value in the cell is one. If yous 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 tin can automate the creation of a custom number format with VBA.
Hither is a simple i-line macro to add together Superscript Two to all selected cells.
Sub SuperscriptTwo() Choice.NumberFormat = "0" & Chr(178) End Sub
To add other superscripts, replace Chr(178) with the corresponding character lawmaking:
Superscript One: Chr(185)
Superscript Iii: Chr(179)
This macro tin also be used to adhere the degree sign to the numbers in the selected cells. For this, use Chr(176), and your numbers will get formatted in this manner:
The step-by-step instructions on how to insert and run VBA lawmaking in Excel can exist found hither. Or, you tin download our sample workbook with all superscript macros and open up information technology alongside your ain workbook. And so, in your workbook, press Alt + F8, select the desired macro, and click Run.
Super like shooting fish in a barrel mode 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, ii or 3. Merely we know that the impossibility is nothing :) Simply re-create the subscripted and superscripted numbers and mathematical symbols from hither:
Subscripts: ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎
Superscripts: ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾
Apart from simplicity, this method has 1 more advantage - information technology allows you to add subscripts and superscripts to any cell value, text and numbers!
If yous 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 promise to see you on our blog adjacent week!
You may also be interested in
Source: https://www.ablebits.com/office-addins-blog/2018/05/16/how-to-superscript-subscript-excel/
Posted by: scalzosurplify99.blogspot.com
0 Response to "How To Put A Subscript In Excel"
Post a Comment