Excel Text Powers: Subscript & Superscript - Episode 2112
3,315 views · Published 19 July 2017 · 4:31 · Indexed 26 October 2026
Channel: MrExcel.com · 2017 · Education
Microsoft Excel Tutorial: Superscript and Subscripts in Excel using Quick Access Toolbar June 2017, in response to customer votes on Excel.UserVoice.com there are now two items you can add to your Quick Access Toolbar Welcome back to the MrExcel netcast! In this episode, we're going to talk about a highly requested feature in Excel - superscript and subscript. Thanks to the idea on excel.uservoice.com, Microsoft has finally added icons for these formatting options to the quick access toolbar. No more hassle of going into the font menu and selecting the option - just one click and you're done! But wait, there's a catch. As mentioned in yesterday's episode, there is currently a bug with the quick access toolbar. But don't worry, I have an update for you. To add the superscript and subscript icons to your quick access toolbar, go to "Customize Quick Access Toolbar" and select "Commands Not in the Ribbon". Scroll down to the "Ss" section and you'll see that the icons are not populating. But fear not, there's a workaround. Simply use the "Tell Me" box and type in "superscript" or "subscript". Right-click on the option and select "Add to Quick Access Toolbar". Easy peasy! Now, let's see how much easier it is to use these formatting options. Say you want to write "H2O" with the 2 as a subscript. Simply select the 2, press F2 to enter edit mode, and click on the subscript icon. Voila! It's that simple. However, there is one thing to keep in mind - these formatting options only work on text, not numbers. So if you want to format a number as a subscript or superscript, you'll have to add a single quote before it to make it a text cell. I personally don't use subscripts and superscripts often, but for those who do, this feature is a game-changer. And it's all thanks to the 372 people who voted for it on excel.uservoice.com. If you have a feature that you desperately want in Excel, make sure to write it up on the website and get your co-workers to vote for it. Microsoft has already covered 20% of the top voted features in the first half of 2017, so your vote can make a difference! And that's it for today's episode. Don't forget to check out my book "Power Excel With MrExcel" for more tips and tricks in Excel. Click on the "i" on the top right-hand corner to learn more. Thank you for tuning in and we'll see you next time for another netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ #excel #microsoftexcel #exceltutorial #excelnew #excelformatting This video answers these common search terms: how to add subscript and superscript in excel how to insert subscript and superscript in excel do a subscript in excel excel how to subscript excel how to use subscript how to do a subscript in excel how to do you subscript in excel how to enter a subscript in excel how to get subscripts and superscrips excel how to type in the subscript on excel how to do superscript letters excel how to add superscript to excel how to use superscripts in excel how to write superscript in excel how to write superscript in excel shortcut how to make a superscript in excel how to make a number superscript in excel Table of Contents: (00:00) New icons for superscript and subscript added to quick access toolbar (00:49) Bug with quick access toolbar, workaround using TELL ME box (01:41) Easier to use superscript and subscript with new icons (02:51) How to use superscript and subscript in numbers and text (03:09) Importance of voting for desired features on the feedback site (03:46) Clicking Like really helps the algorithm Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153937/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920