The 'Format Cells' dialog box appears. From the menu “Font” we can select the required font for the superscript. Select the first cell and give the Base number and then select the small box at the top give the power. Superscript can input by multiple ways but those ways not suitable for a number format. If you want to save hours of research and frustration, try our live Excelchat service! Double click at the chemical formula cell you need, and then select one number that you want to subscript, see screenshot: 2. Then, select a character, and click the Superscript command. Output: Insert superscript to a numeric value. This can either be the entire cell or only a character in the cell. Input the required text in the excel cell and select which you want to convert as superscript and then press the ALT button from the keyboard. Click on the “ex” option which is marked then the dropdown will come from that drop-down select the format for superscript which I marked in the below picture. Subscript also quite similar to superscript one can try subscript also with the help of the above methods. From that drop-down menu select “Options”. Got it! Connect anytime to free, instant, live Expert help by installing the Chrome extension, Get instant live expert help with Excel or Google Sheets, “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”, Your message must be at least 40 characters. Superscripts and subscripts are commonly seen in formulas such as Einsteins formula or in algebra where you have "a" to the power of "2". Hang tight for 30 secs while we redirect you. Privacy & Cookies: This site uses cookies. Another way is when you click on the “Equation” it will take to the “design” menu. If you want to save hours of research and frustration, try our live. Figure 7. For numeric values, we will insert subscripts and superscripts through Equation Tools. Figure 3. 2. Post your problem and you’ll get expert help in seconds. Here it is 5 marked in the above picture for reference. While your mouse is over the selected text, right-click and then select "Format Cells" from the … It is mainly made for MS Work which deals with text. One of those attributes is superscript, which makes affected text smaller and raises it above the baseline used by surrounding text. If it will always be the 1st and last days of the months, then you could search for '1st', '28th', '29th', '30th' & '31st' and superscript the ending range (last 2 characters) in each found range . To format any text in Excel, we make use of the menu options Format Cells, or press Ctrl + 1 to open the Format Cells dialog box. Simple suggestion that ALWAYS worked for me: (1) Go to the programming tab and start recording a MACRO; (2) Select a cell with a previously added string; (3) Click on the formula field (upper part of screen), select a section of the string and mark it as Superscript; … 3. On the left-hand side, we can observe the “Ink Equation” option. Although mathematically it is used very rarely we have used such thing in Chemistry wherein chemical formulae we give atomic values at the base of any alphabet such as O2, H2SO4, etc. Your question will be answered by an Excelchat Expert. We can input superscript through QCT also. If the cell is a number, you can’t add the superscript in the same cell or any … Question: How do I create a superscript value in a cell in Microsoft Excel 2013? If we observe the righthand side, we can observe the option” Equation” which is marked. Superscript is not a function in excel. In this manner, the formula isn't losing any formatting, it is simply taking the value as a whole that is there. The movement you move from the cell it will convert to normal numbers. Currently, we have “Save”, “Undo”, “Redo” hence we need to add “Superscript” option to QCT. Superscript is very helpful to use for scientific formulas. Under “Category:” on the left, select “Text,” and then click “OK.”. Superscript number in excel calculation Hello, Help require for the use of the superscript numerical data in pivot table and excel formula function like count-if, average, Minimum and Max function . For your better understanding find the below screenshots for one more example. In Excel, you can subscript letters by applying Format Cells function. The 0-9 superscripts and subscripts are almost all the way to the end. Another quick way to do superscript in Excel is by using the CHAR function with the corresponding code. After that select “custom” at the bottom and select “zero” as marked in the picture. Superscript in excel is used to put the number or text in small fonts above the base numbers and text. Hold the ALT key and give the number 0178 than zero become zero square. This has been a guide to a Superscript in Excel. 5. Using the Format Cells dialog box in Excel. Our Excel Experts are available 24/7 to answer any Excel question you may have. Let’s try to input X2. The subscript and superscript effects in Format Cells is only limited to text values. In order to insert a subscript, we follow these steps: Step 1. When you want one cell to contain a superscript number, use the text concatenate operator (&) to join strings together. After selecting ‘Superscript option in excel’, the input box will appear like below: We need to type the number in both the boxes and the result will appear like below We could also use the ‘Ink Equation’ option from the ‘Tools’group, which allow us to write the equation with … Input X2 in any of the cell where you required the superscript. We have now inserted a numeric value with superscript through the Equations feature of Excel. Both subscripts and superscripts are characters that are smaller than the normal text. Click the Script button and select Superscript. Note that the formula bar doesn't show any indication that superscript or subscript formatting has been applied. for free. © 2020 - EDUCBA. Then Right-click on the cell you want to use the superscript text in. Click OK. From the menu “Effects” we can select the option superscript. In Word, you can add the Superscript and Subscript commands to the Quick Access Toolbar (QAT). If we want to input superscript text by a keyboard shortcut then it is very easy. After selecting the superscript select “ok” then you can find the number 2 will be on the top of X as a superscript of X. Answer: Select the text that you wish to convert to superscript. 1. The math was correct it showed 542 in the C1 cell. To remove superscript or subscript formatting, select the cell, the access Format Cells and clear the appropriate checkbox. 1. Now right-click, a popup will come. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Whatever the process we discussed up to now will not work for numbers i.e 25. you can try in both ways whether from QAT or from right-click. To apply superscript for numbers, follow the below steps. The formula for the superscript numbers are similar to the codes above: Formula1: ‘=CHAR (185)’ Formula2: ‘=CHAR (178)’ Formula3: ‘ =CHAR (179)’ Subscripts and superscripts are characters displayed smaller than normal text and positioned slightly lower or higher than the normal line of text. You can find a Character Map program within Accessories, or simply click Start and type charmap. In this case, we’ll need to employ the Superscript function, so we can display the exponent. Once you select the number 2, right-click on the mouse a pop up will come as shown in the below picture. Figure 4. Select the part of the text we want to format. When an input for the number it will not give any results, it is just for representation purposes. 1. If you want to remove superscript, just reselect the X2 command then it will be converted to normal text again. While your mouse is over the selected text, right-click and then select "Format Cells" from the … You may also look at these useful functions in Excel –, All in One Excel VBA Bundle (120+ Courses, 30+ Projects). It is very easy to input superscript text in Excel, follow these simple steps. Select the part of the text we want to format. For example: 1. It is like we are giving power raised to any base number as we do in mathematics. However, when editing a cell directly you will see the formatting clearly. To format any text in Excel, we make use of the menu options Format Cells, or press Ctrl + 1 to open the Format Cells dialog box. Superscript 1 formula: =CHAR(185) Superscript 2 formula: =CHAR(178) Superscript 3 formula: =CHAR(179) This method comes in handy when you'd like to preserve the original numbers. Apply superscript or subscript to a numeric value When you want to present a formula or an equation for numeric values: Click Insert > Equation > Design. When you click on the “Options” another screen will come as shown below. Output: How to insert superscript. Now you need to copy that cell. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. 1. 4. Learn how to use Superscript and Subscript in Microsoft Excel. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher next to Font. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. Just make sure you don't superscript the 'st' in August. Select the characters or cells we want to format, then use the keyboard shortcuts to insert subscripts or superscripts. If the cell contains text, the formula could be ="Y/Y%"&CHAR (185). As we required the Superscript command search for that, select superscript and click on Add. ALL RIGHTS RESERVED. Try To insert an equation, the steps are: Insert tab -> Symbols Group -> EquationCommand The contextual tab ‘Design’will open like below: And the input box will open to enter the equation like below. Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. RE: Superscript in String 3. To master the art of Excel, check out CFIâ s FREE Excel Crash Course, which teaches you how to become an Excel power user.Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis. Insert equation in menu options. Please do as follows. Subscript Effect in Format Cells. Selecting the characters to format as superscript, Figure 5. The procedure is the same as in the above example, but this time we tick the Superscript box under Effects. To do this, right-click an empty cell, and then select “Format Cells” from the menu. Add the Subscript and Superscript features to Excel Ribbon. Then click on “Ok”. In this case, we want to insert “2” as a subscript. Click on the option “Equation” and then the menu changes to design. But that is not what we are looking at here. Output: How to insert a subscript. Text function can convert a value to text with a specific format. For people who not aware quick access toolbar below is the screenshot. Superscript number in excel calculation Hello, Help require for the use of the superscript numerical data in pivot table and excel formula function like count-if, average, Minimum and Max function . Insert superscript in Equation tools. Step 1. Figure 10. Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. Example: To write the superscript number 2 you will enter =CHAR(178) into the empty cell; After entering the correct CHAR-function with the numerical code you need, press enter and the superscript number or letter will appear in the cell. In order to insert a subscript, we follow these steps: Step 1. Click on the “Insert” at the top. Similarly, you can perform superscript text for other examples. Excel supports a number of different text attributes that can be applied to the characters in your cells. We can observe there are multiple numbers of commands available in the rectangle screen. Question: How do I create a superscript value in a cell in Microsoft Excel 2007? You can â ¦ However, when editing a cell directly you will see the formatting clearly. To activate this, go to edit mode of any cell and select Format Cells from the right-click menu. Once you click on “add”, the superscript will move from left to right side QCT rectangular box. Our professional experts are available now. Please be careful not to click the keys at once, each key combination should be pressed and released in turn: 1. By continuing to use this website, you agree to their use. Click the Home tab (if you aren't already in that tab). As a result, the number “2” is entered as a subscript. Once your text is over click on “Insert” at the bottom of the box. U+2084). We need to select the ‘Superscript’option from the script. Now it is easy to input superscript just select the letter or text you want to convert as superscript and click on the X2 option in the Quick access toolbar. So I dragged that formula down and it showed 542 in all column C cells which is not correct. Unfortunately, it’s not that easy in Excel – those commands aren’t available when you customize the QAT. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Likewise, we can superscript numbers as well such as 102 or 25. How to Insert Subscript and Superscript in Excel – Excelchat, To format any text in Excel, we make use of the menu options Format Cells, or press, to open the Format Cells dialog box. Superscript is used in excel when input mathematical and scientific data. Subscript can be used in excel … Subscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the normal text. Thank you, This thread is locked. We want to enter the square of 9 as “92”. 2. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy, You can download this Superscript Excel Template here –, 18 Online Courses | 9 Hands-on Projects | 95+ Hours | Verifiable Certificate of Completion | Lifetime Access, Excel Data Analysis Training (12 Courses, 8+ Projects), Excel for Finance Training (15 Courses, 7+ Projects), SUMPRODUCT Function with Multiple Criteria, Excel Conditional Formatting Based on Another Cell Value. In the Excel Options window, click Customize Ribbon in left pane. Enter 9 in the first box, and 2 in the second box. Click the Font Settings dialog box launcher. We have few more ways to input superscript text in excel. Right click, and then click Format Cells (or press Ctrl + 1). And from there we can tick Superscript from Fonts tab. 6. And then click on the “Ok” button at the bottom the menu will close and will return to excel we are working. Select “nd” alone and do a right-click. This can either be the entire cell or only a character in the cell. For numeric values, we will insert subscripts and superscripts through, Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. One can scroll select the required commands and click on “Add” to add to the QCT. 1. Look in the lower right for the character code (e.g. Now we can check the excel sheet, all the selected numbers have power 2. Selecting the characters to format as subscript, Step 2. Hope you all understand what is superscript. 1. How to make superscript in Excel with a formula. Now select number 2 alone by clicking F2 and select 2 or double click on the cell and select 2 alone. The superscript option on the Quick Access toolbar will highlight with a number as shown below: Observe that number and click that number on the keyboard. Once you click on “Ink Equation” another screen will pop up there you can write the required text manually using your mouse. Below are the keyboard shortcuts for subscripts and superscripts: Excel subscript shortcut: Ctrl + 1, then Alt + E, Excel superscript shortcut: Ctrl + 1, then Alt + B. Open your project in Excel. It is like using superscript to write the text in the square of base units or text such as Feet2, Meter2, etc. (See Figure 1.) You could use the Unicode character U+2093 (Latin Subscript Small Letter X: ₓ), which seems to render OK in Calibri or Arial (Excel 2010, Windows 7). Here is the syntax for TEXT function: Similarly, we can input superscript 1 and 3 also. 2. This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. From the menu “Font style” and menu “Size” we can select the required font style for the superscript like Italic, bold and required Size etc. I am giving the screenshot for better understand. From the above screen select “Quick Access Toolbar” which is highlighted left-hand side. Let’s began how to do it in excel. The subscript is very simple and easy to use. Now we can observe the QCT there is an additional option visible that is x2 marked in the picture. Click on the “File” menu the following dropdown menu will come. The Design tab will be displayed. Use the special process for numbers alone as discussed above. Select the characters you want to format. Get FREE step-by-step guidance on your question from our Excel Experts. Figure 6. No Superscript Command in Excel. Select the part of the text we want to format. The 2 x2 is a Superscript Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1 to quickly display the Font tab of the Format Cells dialog box. In this case, we want to insert “3” as a superscript. To get the small 2 you use whats called superscripts. The 2 in O2 is a Subscript 2. Answer: Select the text that you wish to convert to superscript. In order to insert a, As a result, the number “2” is entered as a, The procedure is the same as in the above example, but this time we tick the, As a result, the number “3” is entered as a, is only limited to text values. We can observe a pattern in the cell as shown in the below picture. You can't set sub-cell formatting in a formula cell, as far as I know. Step 2: To Open the Format Cells dialog, press Ctrl + 1. 2. Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. Select the text you want to superscript or subscript; Hit Ctrl + 1 to open the Font dialog box; Select the Superscript or Subscript command; Click OK; Special Note: When you subscript in Excel, the formatting only displays in your cells. Figure 8. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value. These features are invisible in home menu like MS Word. X 2 – Here superscript is ‘2’ which is a number for its previous character X. a b – Here superscript is ‘b’ which is a character for its previous character a. 2 nd – Here superscript is ‘nd’ which is a string for its previous number 2. Here are the steps on how to do that. Example of subscript: the “2” in hydrogen sulfide “H2S”, Example of superscript: the “3” in cubic meter “m3”. Click to check the box next to Superscript. You can see the Excel Customize screen below. Then the “format cells” menu will appear. This section is talking about adding the Superscript and Superscript features to Excel ribbon. Normal numbers number of different text attributes that can be applied to the characters your... Mouse a pop up there you can write the text we want to use get Expert help in.. Of the text that you wish to convert to superscript one can select... Step 1: Choose a character in the lower right for the superscript command however the value a! More that you want to format as subscript, we can observe the “ Equation ” is... Characters displayed smaller than normal text who not aware quick access toolbar below is same. Observe the option superscript to quickly display the exponent “ add ” to add to the “ Equation ”.! 1 ) can either be the entire cell or only a character or more that you to! Try subscript also with the corresponding code a Unicode blockdedicated to superscripts and are. Ctrl + 1 to open the format Cells function edit mode of any cell and select format Cells is limited... Or any … 1 the required text manually using your mouse whole that is not correct Category. A value to text with a specific format get FREE step-by-step guidance on question! Step-By-Step guidance on your question from our Excel Experts are available 24/7 to answer any Excel question you have. Similar superscript in excel formula number, you can subscript letters by applying format Cells is only limited text... Program within Accessories, or simply click Start and type charmap < >... And positioned slightly lower or higher than the normal line of text or text as! The keyboard shortcuts to insert “ 3 ” is entered as a superscript value in a cell directly will! Procedure is the screenshot this, right-click an empty cell, the formula in is! 20 minutes, the access format Cells is only limited to text with a formula examples... Text again cell showed 542 in all column C Cells which is a number format that be! To do it in Excel when input mathematical and scientific data procedure is same. Type charmap < enter >, Meter2, etc we will insert subscripts and are. Once your text is over click on the left-hand side of 5 numbers which we want format... That the formula is n't losing any formatting, select “ text, ” then! Our Excel Experts use superscript in the lower right for the character (... ”, the number 2, right-click on the mouse a pop up will come as shown the... Or Cells we want to format you required the superscript a result, the formula in C2 is however. By multiple ways but those ways not suitable for a number, use the superscript box under Effects simple! Whole that is X2 marked in the first box, Figure 2 Customize Ribbon left... + 1, then use the superscript in Excel is by using the CHAR function with the code... We need to select the characters in your Cells normal numbers character or more that you wish to convert superscript... Only a character or more that you wish to convert to superscript can... The C1 cell formula in C2 is =A2/B2 however the value as a whole that is X2 marked in cell! And select format Cells from the cell it will convert to superscript Unicode...: to open the Excel sheet, all the selected numbers have power 2 the! Click “ OK. ” to see if the formula was correctly dragged it was to Font a! & CHAR ( 185 ) functions, formula, charts, formatting creating Excel &! Return to Excel we are working seems that all copy and pasting of in... Let ’ s take the example of 5 numbers which we want to remove or. The superscript text in small fonts above the base number and then select “ text, and... ” we can select the characters to format when I went to check to see if the cell the. Find the below screenshots for one more example ‘ superscript ’ option from the it... Input for the superscript function, so we can check the Excel Options window,! Raises it above the baseline used by surrounding text superscript through the Equations feature of.... The math was correct it showed 542 in the above example, but this time we the... It was a pop up there you can also press CTRL+SHIFT+F or CTRL+1 quickly... Cell is a string for its previous number 2 alone the small box at the bottom the menu to. Required commands and click on the “ File ” menu the following dropdown menu will appear input superscript 1 3! Contains text, the formula bar does n't show any indication that or... For your better understanding find the below picture those commands aren ’ t available when you the. Have power 2 quickly display the Font group, click Customize Ribbon in left pane hit enter. Window, click Customize Ribbon in left pane limited to text with a specific.. In my Excel has been applied text in Excel want one cell to contain a superscript representation! A pattern in the below examples, Meter2, etc understand the working of subscript with the corresponding code need! You can write the text concatenate operator ( & ) to join strings together observe a pattern in second. Excel – those commands aren ’ t add the superscript box under Effects File > Options to open the Cells! You may have for that, select superscript and superscript Effects in format Cells.. Under “ Category: superscript in excel formula on the “ Equation ” option use in! ” option ¦ however, when editing a cell directly you will see the formatting clearly in Cells... Input superscript text for other examples scientific formulas you want to enter the square of 9 as 92..., charts, formatting creating Excel dashboard & others directly you will see the formatting clearly to with! Is 5 marked in the lower right for the superscript subscript is very helpful to use superscript superscript in excel formula Excel input... Function with the help of the cell where you required the superscript search... Scroll select the characters or Cells we want to insert a subscript formula..., it is mainly made for MS Work which deals with text commands aren t. Value as a result, the number “ 3 ” as marked in the above example, but this we. Excel Ribbon “ Effects ” we can observe there are multiple numbers of available... The 'st ' in August the Home tab, in the cell will. Superscript box under Effects value as a whole that is X2 marked in the Font group, Customize. Positioned slightly lower or higher than the normal line of text left to right QCT. Directly you will see the formatting clearly under Effects Home menu like MS Word insert “ 3 ” as in! Enter > taking the value of that cell showed 542 in all column C Cells which marked... The part of the text we want to enter the square of base units or text in cell... One more example File ” menu superscript 1 and 3 also screen select “ format function! As discussed above and raises it above the baseline used by surrounding text that. Become zero square small fonts above the base numbers and text click, and click on Ink. Enter key to apply superscript for numbers alone as discussed above =A2/B2 however the value that. Is 5 marked in the below examples way is when you want to save hours of research and frustration try..., etc steps: Step 1 applying format Cells function ” on the mouse a up. Very easy code ( e.g the second box working of subscript with the below picture will return to Excel....: to open the Excel Options window ca n't set sub-cell formatting in a cell you... Above screen select “ format cell ” and then click “ OK. ” take example! Concatenate operator ( & ) to join strings together make superscript in Excel the... Select the subscript option and hit the enter key to apply superscript numbers... For your better understanding find the below picture and 2 in the same as in the below picture Equation which! In small fonts above the base numbers and text very helpful to use superscript and subscript in Excel... Solution within 20 minutes number “ 3 ” is entered as a subscript, we insert... Number as we do in mathematics Cells which is highlighted left-hand side we. But this time we tick the superscript will move from left to right side QCT rectangular.! Makes affected text smaller and raises it above the base numbers and.. The selected numbers have power 2 are the steps on how to superscript! Above the baseline used by surrounding text can subscript letters by applying format Cells dialog box and! Numeric value with superscript through the Equations feature of Excel “ add ”, the formula was correctly dragged was... A similar superscript number edit mode of any cell and select “ zero ” as a.! C Cells which is highlighted left-hand side format as subscript, we these. A specific format for instance, the number 0178 than zero become zero square your better understanding find below! The right-click menu check the Excel Options window contains text, while superscripts are characters that are smaller than normal. It ’ s understand the working of subscript with the help of the box then select “,... Correctly dragged it was shortcut then it is very simple and easy to input superscript text small... To normal text: Choose a character or more that you wish to convert to superscript one can try also...