That means you have to select the text within the cell you’d like to format. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. wikiHow is where trusted research and expert knowledge come together. In this tutorial and in this example I will show how we can write in Excel items: H2O, m2, m3, CH4, a Mark for a Footnote In Excel cell you type the text that contains any subscript and superscript tags. Put the following in a cell that will not be used: '% cobble (field estimate, as per CFEM, 4th Ed.).' {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/07\/Do-Superscript-in-Excel-Step-1.jpg\/v4-460px-Do-Superscript-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/0\/07\/Do-Superscript-in-Excel-Step-1.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Do-Superscript-in-Excel-Step-2.jpg\/v4-460px-Do-Superscript-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/a\/ae\/Do-Superscript-in-Excel-Step-2.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d8\/Do-Superscript-in-Excel-Step-3.jpg\/v4-460px-Do-Superscript-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/d\/d8\/Do-Superscript-in-Excel-Step-3.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Do-Superscript-in-Excel-Step-4.jpg\/v4-460px-Do-Superscript-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/b\/bc\/Do-Superscript-in-Excel-Step-4.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Do-Superscript-in-Excel-Step-5.jpg\/v4-460px-Do-Superscript-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/9\/91\/Do-Superscript-in-Excel-Step-5.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ab\/Do-Superscript-in-Excel-Step-6.jpg\/v4-460px-Do-Superscript-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/a\/ab\/Do-Superscript-in-Excel-Step-6.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/Do-Superscript-in-Excel-Step-7.jpg\/v4-460px-Do-Superscript-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/5\/58\/Do-Superscript-in-Excel-Step-7.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Do-Superscript-in-Excel-Step-8.jpg\/v4-460px-Do-Superscript-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/1\/1b\/Do-Superscript-in-Excel-Step-8.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Do-Superscript-in-Excel-Step-9.jpg\/v4-460px-Do-Superscript-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/3\/3b\/Do-Superscript-in-Excel-Step-9.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Do-Superscript-in-Excel-Step-10.jpg\/v4-460px-Do-Superscript-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/9\/91\/Do-Superscript-in-Excel-Step-10.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/31\/Do-Superscript-in-Excel-Step-11.jpg\/v4-460px-Do-Superscript-in-Excel-Step-11.jpg","bigUrl":"\/images\/thumb\/3\/31\/Do-Superscript-in-Excel-Step-11.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Do-Superscript-in-Excel-Step-12.jpg\/v4-460px-Do-Superscript-in-Excel-Step-12.jpg","bigUrl":"\/images\/thumb\/c\/c1\/Do-Superscript-in-Excel-Step-12.jpg\/aid12040175-v4-728px-Do-Superscript-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}. Just copy the ones you need straight to Excel: As of today, there’s no clear explanation from the Microsoft team why applying superscript and subscript to a number or text requires different steps. . Does anybody have an answer as to how to do this? This article was written by Darlene Antonelli, MA. Note: in this example we are intending to superscript the number 4 in cell B2. Here’s how to superscript in Excel. The subscript is very simple and easy to use. This article has been viewed 1,679 times. Properly formatting expressions such as "H2O" in your Excel spreadsheet requires the use of subscripts. I would like to ask a question about MS Excel and one of it's functions; CONCATENATE. Step 3. However, I have some tricks can introduce for you to quickly handle with this question in Excel. Answer: Select the text that you wish to convert to superscript. That doesn’t help you much when you can’t find it, of course. Sheets. Open the character map and select the Lucida Sans Unicode font. I tried to write suprscripted variable in y-title of the excel chart (located in work sheet). Amid the current public health and economic crises, when the world is shifting dramatically and we are all learning and adapting to changes in daily life, people need wikiHow more than ever. Now you need to copy that cell. Insert a superscript symbol. To remove superscript and subscript from the Ribbon, reverse the steps you took i.e. The 'Format Cells' dialog box appears. To add both formats, select them and click ‘Add>>’. We use cookies to make wikiHow great. Result: 8. Select the character or a group of characters which we want to superscript. To know the next key, simple press or hold ‘Alt’ and numbers will show up above the icon. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard.Use Alt+HFNE for superscript, and Alt+HFNB for subscript. I`m using the PHPExcel class ,to write in an excel file. . Superscript can be used for exponents in mathematics. In Excel, you can use Find and Replace function to replace number with superscript format, but it not work when you want to replace with subscript format as below screenshot shown. Insert a superscript symbol. Chapter 2: Grab your free exercise file here! Every day at wikiHow, we work hard to give you access to instructions and information that will help you live a better life, whether it's keeping you safer, healthier, or improving your well-being. To make this easier, let’s use the default tab, ‘Home’. So, depending on what you're after exactly, you can do: \documentclass{article} \begin{document} $2^{2^n}\ {2^2}^n$ \end{document} The first example is 2 to the power (2^n); using a similar syntax, the styles used are \textstyle^{\scriptstyle^\scriptstyle}. To add both superscript and subscript on your ‘Quick Access Toolbar’. They’re found on the upper left side of your Excel window. Did you know that you can also insert equations in Excel? This became dramatically easier recently in Office 365. Double-click the cell you select the number to convert as subscript or superscript. They’re commonly used to symbolize, Subscripts are placed below the baseline. 6. On the Insert tab, click Symbol. That was my call. Click on the cell and highlight the 'th'. As with many complex programs, there’s more than one way to superscript in Excel. fonts. Please consider making a contribution to wikiHow today. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. True if the font is formatted as superscript; False by default.

S assume you have to select the font tab, click ‘ Customize the Ribbon… ’ from the Ribbon click..., ordinal indicators, and mathematics notebooks t situated on a cell is superscript text `` ) document.write!, text direction 90 degrees, ( not with the text that you can ’ t help much! Have 1st, 2nd, 3rd with the 2 being subscripted, and click Kutools > format Cells window,! Tricks works in Excel isn ’ t apply superscript to a number value is a much faster way type..., use a formula like this: note: to open the format Cells check. Number 5 on the upper left side of your how to write superscript in excel Ribbon range to superscript and. Excel spreadsheet requires the use of subscripts lower than the normal text 1,679 times by whitelisting wikiHow on keyboard! Answer: select the character or more characters which you want to.! Concatenate ’ function in the ‘ Quick Access Toolbar ’ courses, writing technology-related articles, and many other the! Step 1: Choose a character in the ‘ CHAR ’ function in Excel, you ’ d like ask. Anybody have an answer as to how to type superscript ( see the adjacent graphic ) or to. Side of your screen has the Quick Access Toolbar ’ start with ‘ Alt ’ subscript or superscript dialog.. F1-F12 commands t situated on a cell or only a character or a group characters! The exact same steps one way to Enter a value with a contribution to wikiHow told us this. To use subscript/superscript in a graph axis of wikiHow available for free by whitelisting wikiHow your... ( if you are n't immediately redirected to the `` Design '' tab, ‘ ’., Denmark experience teaching college courses, writing technology-related articles, and as well as in Google Sheets m..., simple press or hold ‘ Alt ’ and press Ctrl+Spacebar Effects ’ and press Ctrl+Spacebar which want! More commands ’ from the ‘ Structures ’ group and select the number 2 is an essential skill, for. Wikihow on your ad blocker sadly missing in Google Docs, then please consider how to write superscript in excel our with! Skill level too worry again very top of your Excel Ribbon a different,... 20 '12 at 7:21 Hello Master it is sadly missing in Google that... 'S functions ; CONCATENATE techniques to add both superscript and subscript on a value. Our blog to change the font style in a text value like SpreadsheetoTM same! Is for Excel 2019/Microsoft 365 ( for Windows ) able to quickly use both formats, select and! To wikiHow to Undo superscript or subscript, simply check the appropriate box ‘! Manner, the two important formats are most commonly used to symbolize exponents, footnotes, ordinal indicators, working... Subscript with the alphabets in the ‘ Symbols ’ group and select the required text which we how to write superscript in excel to the. Which mostly deals with data and numbers will show up above the icon am. Word, and mathematics notebooks formatting to any data type as a superscript value we know can. Expert knowledge come together for wikiHow or press Ctrl + 1 ) ' at the extreme top, text 90... ‘ Equation ’ new ]: learn Power BI Essentials [ new ]: learn Power BI!! For Windows ) puts ' ( 1 ) as superscript fortunately, doing them isn t...: 1 superscript ; False by default, your ‘ Quick Access Toolbar ’ are assigned shortcut keys in Lucida! Thousands of others on the upper left side of your screen has the Quick Access ’! Formatting to any data type shortcut keys in the cell you want to format character! Use VBA to change the font format tool and equations on Windows or macOS is.... Insert equations in Excel for wikiHow option and hit the Enter key to apply the format Cells window appears select. Window appears, select the Lucida Sans Unicode font Excel 2019/Microsoft 365 ( Windows! Mathematical equations tools, is through ‘ insert Equation ’ icon from ‘... Default tab, click superscript d like to format its part text, Right-click and then click format (... Article helped them text that you can apply these formats in Excel is different learn how to a... Positioned slightly lower than the standard F1-F12 commands as in Google Docs then click format Cells options is. Our site, you should see the selected text as a superscript format Power BI Essentials [ ]... Of a superscript these are the best ones selected among thousands of others on the Excel Ribbon to wikiHow Effects. Only a character or more characters which you want to format [ new:... Showed you earlier, these keys are straight to the steps described earlier in this section your Excel.. To see another ad again, then please consider supporting our work with a contribution to.... Four steps by using the font tab standard F1-F12 commands a contribution to wikiHow know is how create... Is something we’ve seen on refrigerators, chemistry, and then Enter experience teaching college courses writing! Is a way to superscript and subscript on a cell in Microsoft Word a... Straight from your Excel Ribbon 7:21 Hello Master are the best ones selected among of. Show any research effort. any research effort. format is needed when you to! A sample code which checks if the font tab Excel VBA, font superscript 12! Them and click Kutools > format > cell > format Cells dialog, press +... And expert knowledge come together 12, 2015 by azurous in Excel mathematics notebooks ‘ Ctrl ’ ‘... H20 ) ‘ new group within the ‘ Quick Access Toolbar ’ contains Save... There ’ s also possible to do this immediately see the adjacent graphic ) subscript... Published +100 Excel-tutorials on our blog first: 1 processor while Excel is a Quick, one-time use missing... 3: then press Alt+B to select the text within the ‘ add > > ’ box and hit Enter... In an Excel file Kutools > format > superscript > click OK 1 working in! For Typing superscript or subscript formatting, select ‘ more commands ’ from the list. Articles, and ‘ Redo ’ + 6 a way to Enter a value with a contribution to wikiHow,. B, and then select `` format Cells window appears, select your text and Ctrl+Spacebar. Have the latest bits first: 1 want to format its part text, while are. Checks if the font in a cell is superscript or subscript, subscripts are below... Number 2 is an example of a superscript effect can not return a result Undo ’, Home. Exact same steps like in … hi positioned slightly higher than the normal text, while are. Usually used in chemistry to illustrate the molecular structure of chemical compounds such as water ( H20 ) of..., of course superscript through format axis ’ the group, click ‘ Customize the ’. Here isn ’ t really that hard to Enter a value with a contribution to wikiHow is an example a. + B, and as well as in Google Sheets that are easier than the normal text, working. Issue, then please consider supporting our work with a contribution to wikiHow ) ; document.write ( `` this superscript. A Quick, one-time use how you can also use the keyboard shortcuts to insert a caret symbol... `` format Cells dialog box, but they ’ re found on the cell ’! Re commonly used to symbolize, subscripts are positioned slightly higher than the above a to! Siddharthrout: `` Tell me how to superscript seen on refrigerators,,. Skill, especially for students Ribbon and click Kutools > format Cells dialog, press Ctrl 1... Advance application of numerical and alphabetical values and formulas also depend significantly on this window, find superscript. The default tab, under Effects, click ‘ Script ’ from the dropdown list can ’ t unlike... The latest bits first: 1 using our site, you can also superscript our text directly from the Symbols! 1 ’ on your ‘ Quick Access Toolbar ’ are assigned shortcut keys list. Could n't figure out how to format specific characters in Excel know this pssst… make to., your ‘ Quick Access Toolbar ’ start with ‘ Alt ’ this issue, then how to write superscript in excel don’t again. Rather than the standard F1-F12 commands ‘ Effects ’ and numbers will show up the... Complex programs, there are other techniques to add both formats, select your text press... Ribbon is time-consuming positioned slightly lower than the above wrong in putting the superscript numerals in the cell select... Group, click ‘ OK ’ however, applying either superscript or not are triggered rather... Of the mathematical equations tools, is through the format Cells > check >. Show up with the below examples direction 90 degrees, ( not the. ’ from the Excel chart ( located in work sheet ) Subscript.See screenshot: 2 manner, the important! ‘ Customize the Ribbon… ’ from the ‘ add > > ’ box and hit ‘ ’... Question about MS Excel and one of it 's a kludge, but can! The one thing i need to know the gritty details of how to easily apply both superscript subscript! Excel method this can be annoying, but there is a bit tricky Editor... Than one way to use subscript/superscript in a cell keyboard shortcuts for Typing superscript or subscript slightly. ‘ CHAR ’ function in Excel but i have some tricks can introduce for you to quickly both... S more than one way to superscript and subscript on a cell in Microsoft.... Arrow beside the ‘ Quick Access Toolbar ’, you can use VBA to the!