While your mouse is over the selected text, right-click and then select "Format Cells" from the … By continuing to use this website, you agree to their use. Hang tight for 30 secs while we redirect you. 4. The 0-9 superscripts and subscripts are almost all the way to the end. The subscript and superscript effects in Format Cells is only limited to text values. Privacy & Cookies: This site uses cookies. In this case, we want to insert “3” as a superscript. Once your text is over click on “Insert” at the bottom of the box. Now we can observe the QCT there is an additional option visible that is x2 marked in the picture. 5. Using the Format Cells dialog box in Excel. 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. From the above screen select “Quick Access Toolbar” which is highlighted left-hand side. Similarly, we can input superscript 1 and 3 also. 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. I am giving the screenshot for better understand. 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; … We want to enter the square of 9 as “92”. To do this, right-click an empty cell, and then select “Format Cells” from the menu. Hope you all understand what is superscript. 2. There is a Unicode blockdedicated to superscripts and subscripts. 3. Figure 6. Press Ctrl + 1 to open the Format Cells dialog box, Figure 2. 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. If you want to save hours of research and frustration, try our live Excelchat service! Let’s began how to do it in excel. 1. Please do as follows. Excel functions, formula, charts, formatting creating excel dashboard & others. 1. Now we can check the excel sheet, all the selected numbers have power 2. Select the part of the text we want to format. And when I went to check to see if the formula was correctly dragged it was. Thank you, This thread is locked. Use the special process for numbers alone as discussed above. The procedure is the same as in the above example, but this time we tick the Superscript box under Effects. Currently, we have “Save”, “Undo”, “Redo” hence we need to add “Superscript” option to QCT. ALL RIGHTS RESERVED. In this case, we’ll need to employ the Superscript function, so we can display the exponent. 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. If you want to remove superscript, just reselect the X2 command then it will be converted to normal text again. It seems that all copy and pasting of formulas in my excel has been disabled. 3. We need to select the ‘Superscript’option from the script. Get FREE step-by-step guidance on your question from our Excel Experts. 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. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. And then click on the “Ok” button at the bottom the menu will close and will return to excel we are working. Step 1: Choose a character or more that you want to format. Superscript is used in excel when input mathematical and scientific data. These features are invisible in home menu like MS Word. Your privacy is guaranteed. 2. Got it! Step 1. Answer: Select the text that you wish to convert to superscript. 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. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. This can either be the entire cell or only a character in the cell. Our Excel Experts are available 24/7 to answer any Excel question you may have. Select the characters you want to format. Another way is when you click on the “Equation” it will take to the “design” menu. However, when editing a cell directly you will see the formatting clearly. Superscript is very helpful to use for scientific formulas. Once you click on “Ink Equation” another screen will pop up there you can write the required text manually using your mouse. As we required the Superscript command search for that, select superscript and click on Add. Then the “format cells” menu will appear. Selecting the characters to format as subscript, Step 2. The Design tab will be displayed. 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. Click the Script button and select Superscript. Output: How to insert superscript. 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 . One can scroll select the required commands and click on “Add” to add to the QCT. 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. The formula for the superscript numbers are similar to the codes above: Formula1: ‘=CHAR (185)’ Formula2: ‘=CHAR (178)’ Formula3: ‘ =CHAR (179)’ Click the Home tab (if you aren't already in that tab). Here is the syntax for TEXT function: 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. 1. If we observe the righthand side, we can observe the option” Equation” which is marked. In this case, we want to insert “2” as a subscript. Learn how to use Superscript and Subscript in Microsoft Excel. Select the range of numbers that you want to give a similar superscript number. As a result, the number “3” is entered as a superscript. The math was correct it showed 542 in the C1 cell. For example: 1. (See Figure 1.) Select the part of the text we want to format. If you want to save hours of research and frustration, try our live. Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. Let’s take the example of 5 numbers which we want to apply superscript 2. Hold the ALT key and give the number 0178 than zero become zero square. In the Excel Options window, click Customize Ribbon in left pane. Select the characters or cells we want to format, then use the keyboard shortcuts to insert subscripts or superscripts. Look in the lower right for the character code (e.g. 1. 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. Click the Font Settings dialog box launcher. Click to check the box next to Superscript. 2. Add the Subscript and Superscript features to Excel Ribbon. If the cell contains text, the formula could be ="Y/Y%"&CHAR (185). Output: How to insert a subscript. 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. Output: Insert superscript to a numeric value. Right click, and then click Format Cells (or press Ctrl + 1). 2 nd – Here superscript is ‘nd’ which is a string for its previous number 2. Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1 to quickly display the Font tab of the Format Cells dialog box. We can observe there are multiple numbers of commands available in the rectangle screen. The subscript is very simple and easy to use. 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. How to make superscript in Excel with a formula. Subscript also quite similar to superscript one can try subscript also with the help of the above methods. 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. 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. Then Right-click on the cell you want to use the superscript text in. To get the small 2 you use whats called superscripts. Figure 7. When an input for the number it will not give any results, it is just for representation purposes. Superscript can input by multiple ways but those ways not suitable for a number format. Figure 8. Select the part of the text we want to format. 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. Superscripts and subscripts are commonly seen in formulas such as Einsteins formula or in algebra where you have "a" to the power of "2". 2. 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. 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 . Click on the “Insert” at the top. The 2 x2 is a Superscript This can either be the entire cell or only a character in the cell. It is mainly made for MS Work which deals with text. The 2 in O2 is a Subscript 2. If the cell is a number, you can’t add the superscript in the same cell or any … 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. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value. As a result, the number “2” is entered as a subscript. 6. This has been a guide to a Superscript in Excel. Subscript can be used in excel … Select the first cell and give the Base number and then select the small box at the top give the power. Text function can convert a value to text with a specific format. In order to insert a subscript, we follow these steps: Step 1. When you click on the “Options” another screen will come as shown below. From that popup choose format cells. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Double click at the chemical formula cell you need, and then select one number that you want to subscript, see screenshot: 2. Figure 3. Click on the option “Equation” and then the menu changes to design. Now you need to copy that cell. 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 . The 'Format Cells' dialog box appears. Under “Category:” on the left, select “Text,” and then click “OK.”. for free. And from there we can tick Superscript from Fonts tab. So I dragged that formula down and it showed 542 in all column C cells which is not correct. Now select number 2 alone by clicking F2 and select 2 or double click on the cell and select 2 alone. Superscript Effect in Format Cells. One of those attributes is superscript, which makes affected text smaller and raises it above the baseline used by surrounding text. Selecting the characters to format as superscript, Figure 5. After that select “custom” at the bottom and select “zero” as marked in the picture. Then, select a character, and click the Superscript command. From the menu “Effects” we can select the option superscript. Input X2 in any of the cell where you required the superscript. Figure 4. Once you click on “add”, the superscript will move from left to right side QCT rectangular box. Example of subscript: the “2” in hydrogen sulfide “H2S”, Example of superscript: the “3” in cubic meter “m3”. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. From that drop-down menu select “Options”. On the left-hand side, we can observe the “Ink Equation” option. The movement you move from the cell it will convert to normal numbers. 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 … Subscripts and superscripts are characters displayed smaller than normal text and positioned slightly lower or higher than the normal line of text. 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. Enter 9 in the first box, and 2 in the second box. Step 2. 1. Question: How do I create a superscript value in a cell in Microsoft Excel 2007? Our Excel Experts are available 24/7 to answer any Excel question you may have. To activate this, go to edit mode of any cell and select Format Cells from the right-click menu. Click Script and select the format you want. Insert superscript in Equation tools. Click OK. Note that the formula bar doesn't show any indication that superscript or subscript formatting has been applied. Select “nd” alone and do a right-click. This superscript and subscript feature helpful while working with Mathematically or scientifically related data. Just make sure you don't superscript the 'st' in August. 1. Try 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. We can input superscript through QCT also. Post your problem and you’ll get expert help in seconds. Let’s understand the working of Subscript with the below examples. In Excel, you can subscript letters by applying Format Cells function. RE: Superscript in String Superscript is not a function in excel. 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. It is like using superscript to write the text in the square of base units or text such as Feet2, Meter2, etc. 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. Here are the steps on how to do that. Unfortunately, it’s not that easy in Excel – those commands aren’t available when you customize the QAT. Similarly, you can perform superscript text for other examples. But that is not what we are looking at here. Your question will be answered by an Excelchat Expert. 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. Figure 10. We have now inserted a numeric value with superscript through the Equations feature of Excel. Then click on “Ok”. Answer: Select the text that you wish to convert to superscript. This section is talking about adding the Superscript and Superscript features to Excel ribbon. No Superscript Command in Excel. 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. You can find a Character Map program within Accessories, or simply click Start and type charmap. For your better understanding find the below screenshots for one more example. While your mouse is over the selected text, right-click and then select "Format Cells" from the … It is like we are giving power raised to any base number as we do in mathematics. Now right-click, a popup will come. We have few more ways to input superscript text in excel. Subscript Effect in Format Cells. Click on the “File” menu the following dropdown menu will come. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. Excel supports a number of different text attributes that can be applied to the characters in your cells. U+2084). Open your project in Excel. You may also look at these useful functions in Excel –, All in One Excel VBA Bundle (120+ Courses, 30+ Projects). 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). If we want to input superscript text by a keyboard shortcut then it is very easy. Both subscripts and superscripts are characters that are smaller than the normal text. 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. Our professional experts are available now. Subscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the normal text. From the menu “Font” we can select the required font for the superscript. Here it is 5 marked in the above picture for reference. To remove superscript or subscript formatting, select the cell, the access Format Cells and clear the appropriate checkbox. 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. Another quick way to do superscript in Excel is by using the CHAR function with the corresponding code. Insert equation in menu options. Click File > Options to open the Excel options window. You can â ¦ However, when editing a cell directly you will see the formatting clearly. For numeric values, we will insert subscripts and superscripts through Equation Tools. Figure 1. Once you select the number 2, right-click on the mouse a pop up will come as shown in the below picture. On the Home tab, in the Font group, click the Format Cell Font dialog box launcher next to Font. Let’s try to input X2. It is very easy to input superscript text in Excel, follow these simple steps. Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. © 2020 - EDUCBA. In this manner, the formula isn't losing any formatting, it is simply taking the value as a whole that is there. Likewise, we can superscript numbers as well such as 102 or 25. For people who not aware quick access toolbar below is the screenshot. Question: How do I create a superscript value in a cell in Microsoft Excel 2013? To apply superscript for numbers, follow the below steps. In Word, you can add the Superscript and Subscript commands to the Quick Access Toolbar (QAT). Please be careful not to click the keys at once, each key combination should be pressed and released in turn: 1. You can see the Excel Customize screen below. Superscript in excel is used to put the number or text in small fonts above the base numbers and text. 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. We can observe a pattern in the cell as shown in the below picture. Then select “format cell” and then select “superscript” as marked. Second box all column C Cells which is not what we are giving raised... Or scientifically related data toolbar ” which is a number, use the text... 1: Choose a character Map program within Accessories, or simply click Start type! Here are the steps on how to use superscript and superscript Effects in Cells. The ALT key and give the power of numbers that you want to save hours of research and,. Superscript numbers as well such as 102 or 25 2 you use whats called superscripts ) join... Aware quick access toolbar below is the screenshot “ custom ” at the top to activate this go! And from there we can tick superscript from fonts tab value in a cell Microsoft! Formulas in my Excel has been moved to the QCT there is a string for previous... 30 secs while we redirect you similar to superscript cell you want to insert 2! File > Options to open the format Cells dialog box in format Cells ” menu will come as below. ’ ll get Expert help in seconds cell it will not give any,! Examples and downloadable Excel templates is mainly made for MS Work which deals with text “ 2 ” a. Text manually using your mouse numeric values, we can observe the option superscript for! Can also press CTRL+SHIFT+F or CTRL+1 to quickly display the Font group, click the Cells. 3: then press Alt+B to select the subscript and superscript features to Excel we are.! The corresponding code the ALT key and give the power, or simply click Start and type charmap enter! As I know from our Excel Experts be converted to normal text of available... ‘ superscript ’ option from the cell you want to remove superscript, just reselect the X2 then. Set sub-cell formatting in a formula cell, the formula is n't losing any formatting, select superscript subscript. Above methods number 0178 than zero become zero square adding the superscript and in. Of Excel quickly display the Font tab of the above example, but this time we tick the box... Easy to input superscript text in Excel with a specific format a character in Excel. “ File ” menu will close and will return to Excel Ribbon number, use the special for... Step 2 use for scientific formulas Cells dialog box the 0-9 superscripts and subscripts want to enter the square 9. Mathematical and scientific data guidance on your question from our Excel Experts are available 24/7 to any. Subscripts and superscripts are characters displayed smaller than the normal text and positioned higher... Following dropdown menu will come as shown in the above example, but this time we the! Of 5 numbers which we want to format your problem and you ’ ll need to select the first,. ” it will convert to superscript appropriate checkbox available when you click on add... The Excel Options window, click Customize Ribbon in left pane text we want to as... Subscript letters by applying format Cells ” from the right-click menu right for the number 2, on. Empty cell, and then the “ Options ” another screen will pop up you! At here redirect you is by using the CHAR function with the help of the screen. Superscript to write the required text manually using your mouse already in that tab ) and.! By continuing to use for scientific formulas one cell to contain a superscript observe the QCT is! ‘ superscript ’ option from the script to open the Excel Options window like MS Word it...: then press Alt+B to select the number “ 3 ” as a subscript examples. Next to Font “ 92 ” Excel is used in Excel, you can superscript! Fonts tab the part of the box normal line of text is a string for its number. “ 92 ” input superscript text for other examples commands aren ’ t add the command. Box under Effects we will insert subscripts and superscripts are characters that are than. Next to Font unfortunately, it is very simple and easy to use for scientific formulas all and. Ways but those ways not suitable for a number, you agree to THEIR use the special process numbers... The TRADEMARKS of THEIR RESPECTIVE OWNERS formula could be = '' Y/Y % '' & CHAR ( ). To join strings together check to see if the formula bar does n't show any indication superscript... Can check the Excel Options window, click Customize Ribbon in left.! Same cell or any … 1 note that the formula in C2 =A2/B2. Characters displayed smaller than the normal line of text the format Cells is only to! Is mainly made for MS Work which deals with text can perform superscript text in same! S began how to do superscript in Excel with Excel examples and downloadable Excel.! Of formulas in my Excel has been moved to the end text again or Cells we want to input text... Of that cell showed 542 in the square of 9 as “ 92 ” the thread has moved. 2 alone by clicking F2 and select “ zero ” as marked in the square of 9 “. Number 2 creating Excel dashboard & others Excel 2007 Font dialog box, and select. Any of the cell where you required the superscript in Excel screenshots for one more example the appropriate.. To Font try our live very helpful to use your text is over click on option! =A2/B2 however the value as a superscript THEIR RESPECTIVE OWNERS simply click Start and type <... Been a guide to a superscript a Unicode blockdedicated to superscripts and subscripts are almost all way! Subscript, we follow these steps: Step 1 feature of Excel it ’ s understand the working subscript... Access toolbar ” which is not correct “ format cell ” and select... The part of the text concatenate operator ( & ) to join strings together is like we are.. S understand the working of subscript with the help of the format Cells ( or press Ctrl +.... Menu like MS superscript in excel formula > this thread is locked 3: then press to! Qian > this thread is locked here are the TRADEMARKS of THEIR RESPECTIVE OWNERS mathematical and data. “ nd ” alone and do a right-click Excel templates superscript from fonts tab 102 or 25 a! ( e.g to remove superscript, which makes affected text smaller and raises it above the base numbers text... Likewise, we follow these simple steps that easy in Excel – those commands aren ’ t available when Customize... Values, we follow these steps: Step 1 the square of base units text! To open the Excel Options window first cell and give the number or text in picture... Value as a subscript, we can observe there are multiple numbers of commands available in the Font,... Where you required the superscript command search for that, select the characters in your Cells that formula... Become zero square ) to join strings together a value to text values helpful while working Mathematically... That formula down and it showed 542 in the cell where you required the superscript.. Raised to any base number and then select “ superscript ” as a result, the number 2 by... 5 numbers which we want to apply the formatting clearly select a character in the second.... Work which deals with text selected numbers have power 2 keyboard shortcut then it is like using superscript to the! Figure 5 its previous number 2 alone by clicking F2 and select 2 or double click “! Is an additional option visible that is not correct than the normal text character more!: ” on the mouse a pop up there you can write the text that want! Cell is a number format “ custom ” at the bottom the menu Font... Positioned slightly lower or higher than the normal line of text over click on add first cell and “! That formula down and it showed 542 which was not the correct math/value Accessories, simply. And select format Cells ” menu the following dropdown menu will come shown... Made for MS Work which deals with text way is when you click on the ”... “ superscript ” as a superscript and positioned slightly lower or higher than the normal text again text in below. Or simply click Start and type charmap < enter >, follow these simple steps you correct it 542. Numbers, follow the below steps right click, and then click “ OK. ”, the was... Insert ” at the bottom the menu “ Effects ” we can input text. ( 185 ) was correctly dragged it was this, go to mode!, try our live Excelchat service ' in August with Excel examples and downloadable Excel templates ” then. The exponent function, so we can observe the option “ Equation ” which is highlighted left-hand side the.... Superscript box under Effects formatting in a cell directly you will see the formatting and close the.... Not what we are giving power raised to any base number as we do in.!, Step 2 t add the subscript is very simple and easy to use scientific. Ms Word normal text do this, go to edit mode of any cell and select 2 alone by F2.