x₂ is called subscript, the keyboard shortcut to activate is Ctrl + = (Press and hold Ctrl and press the equal = sign, at the same time). Click OK to save the change and close the dialog. Read/write Variant.. Syntax. Let me assist you with Excel superscripts and subscripts key board shortcuts. These features are invisible in home menu like MS Word. Click on cell “B16” press F2 key, so that the text value in cell B16 text get in to edit mode. 1. Let’s understand the working of Subscript with the below examples. Result: 8. Example. © 2020 - EDUCBA. Using subscript is also possible in Excel, however it works a little differently than in Word: Select either the cell you want to subscribe or the individual characters. Both subscripts and superscripts are characters that are smaller than the normal text. If you also have suffered from this issue, then just don’t worry again. . Currently I have the output in one cell and the next cell is text "in2" with the "2" superscripted to signify inches squared. What is subscript. Web searches can help you find the codes to enter. How to Superscript and Subscript (Word, Excel … Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. . If you're using a computer, you'll most likely have an option in your word processor to convert any text to subscript. A subscript character is usually a letter or number written or printed below the regular text line. You may try the following key board shortcuts and check if it helps. I’ve also provided a sample code which checks if the font in a cell is subscript or not. You can either start a new project or open a saved one. The OP has asked many questions before and should know this. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. I am working in science field (chemistry) and I need to use formulas such as CH3OH or H2SO4, where all the numbers are basically subscripts. Answer: Select the text that you wish to convert to subscript. First, this answer will not be complete. Here's how you can do this: Go to the Insert tab, Symbols group, and click the Equation button. Handy Keyboard Shortcuts for Typing Superscript or Subscript in Windows. I am wondering if there is a way to use subscript/superscript in a graph axis. Then, In the final step, hit the Enter key to apply the formatting and close the dialog box. It requires the use of subscripts to convert it into the proper format “CH4”. For example, this is water: H 2 O. Alternatively, here is carbon dioxide with the 2 sub-scripted: CO 2. But as you can see in the workbook no worksheet exists with the name of the “Sheet1” (instead you have the “Sheet2”) so that VBA show “Subscript Out of Range” to notify you that there’s something wrong with the code. Please be careful not to click the keys at once, each key combination should be pressed and released in turn: 1. Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. Using the Format Cells dialog box in Excel. ... Excel VBA Excel, Writing to a Text File. Read/write Variant.. Syntax. In the following example, you have tried to activate the “Sheet1” that an object. In the Format Cells dialog box, go to the Font tab, and select Subscript under Effects. Subscript and Superscript formats are most commonly used in MS Word and PowerPoint documents. 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 Subscript 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. Subscript also quite similar to superscript one can try subscript also with the help of the above methods. Right click, and then click Format Cells (or press Ctrl + 1). How to write subscript and superscript in Excel. You can do this through the Font dialog box, but there is a much faster way. The Kutools for Excel's Superscript / Subscript tool makes it easy to format text as a superscript or subscript in a cell. Select one or more characters we want to format. Learn how to use Superscript and Subscript in Microsoft Excel. 3. Let’s convert ve, Vu, and vτ to νe, νμ, and ντ in excel. Recommended Articles. 1. Hit the Enter key to apply the formatting and close the dialog. But it is sadly missing in Google Sheets now. This can either be the entire cell or only a character in the cell. The subscript is very simple and easy to use. Likewise, Chrome OS uses unicode for characters. \+(o) will convert the symbol "o" to superscript in the graph legend or axis title but the worksheet cell is … 1, I have to apply a SUBSCRIPT format to 1. We can overcome this as below. Recommended Articles. A small window will pop-up which is the Format Cells. After that, you can simply copy this and paste it into your Google Sheet. The subscript is very simple and can be used in an excel worksheet on any character/number and can be used in VBA. Searching for the function in the ribbon is time-consuming. 3. TABLE1, How To Apply Subscript Format To The Whole Cell Text, In the below-mentioned cell, “B16” contains the word or text value i.e. The article here points out where the superscript and subscript … It’ll make the text in the cell editable on the character level. 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. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. This has been a guide to a Superscript in Excel. Sorry. This can either be the entire cell or only a character in the cell. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. To undo superscript or subscript formatting, select your text and press Ctrl+Spacebar. Excel provides a method to do just that, although it might not be intuitive to do so. Once your text is selected, click the Font group’s “Dialog Box Launcher,” which is the tiny icon found at the bottom-right of the “Font” group. Open the Format Cells dialog by pressing Ctrl + 1 or right-click the selection and choose Format Cells. Subscript text is text which displays “below” the rest of the line of text, for example like this. Let’s assume you have the latest bits first: 1. In this example, we are applying the subscript to CH4. The 'Format Cells' dialog box appears. Here we learn how to do Subscript in Excel, and we will also look at the keyboard shortcut used to add subscript with an example. ALL RIGHTS RESERVED. Prior to the EXCEL 2016 version, In the Version of EXCEL 2007, EXCEL 2010 & EXCEL 2013, There is no proper subscript button option to quickly format text as a subscript. 7. Range(“D2”).Characters(2, 1).Font.Subscript = True, MsgBox “D2 cell value in now in subscripts.”, This has been a guide to Subscript in Excel. This is carried out with the help of a couple of key combinations i.e. . Example. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. This became dramatically easier recently in Office 365. Subscript text is useful in situations where you want to display a formula, particular a scientific formula, in your text. Click this Superscript box. Simply type in the value for which you need a superscript/ subscript on the left-hand side and you will get the corresponding superscript/subscript on the right-hand side. We can overcome this as below. For certain symbols that are almost always superscript, such as ® and ™, simply insert the symbol and it will automatically be formatted as superscript. For certain symbols that are almost always superscript, such as ® and ™, simply insert the symbol and it will automatically be formatted as superscript. I am wondering if there is a way to use subscript/superscript in a graph axis. However, applying either superscript or subscript in Excel is different. 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. 4. In the Format Cells dialog box, under the Font tab, a select Subscript option under Effects. Click Superscript or Subscript. Open a format cell dialog box by clicking or pressing ctrl+1 or right-click in mouse and select format cells option in it. Electron, This has been a guide to a Subscript in Excel. You can also convert the whole-cell text to subscript. With it, you can also apply some command formatting styles to the superscript or subscript characters, such as the Bold, Italic, Upper/Lower Case, Font size, and Color. .long time user, 1st time poster. First, this answer will not be complete. I do not know whether you want to just type it in MS Excel or you actually want it to function. . How to Get Subscript and Superscript Numbers in Google Sheets. To undo superscript or subscript formatting, select your text and press Ctrl+Spacebar. Please note that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn: 1. The subscript format is easy to use & very simple, the Subscript format can also be applied by using VBA code. I hate this stuff ;) I find that you can do almost anything in Excel, but for things like this, you need to think out of the box, literally! How to make text subscript in Google Docs. Only in a word document, the text value can be formatted as subscript with the subscript button. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy, New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More, You can download this Subscripts Excel Template here –, All in One Excel VBA Bundle (35 Courses with Projects), 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion. Here in that text value, I have to apply a Subscript format to the entire whole cell text. The very top of your screen has the Quick Access Toolbar with Save, Undo, Redo. Some of which are super & subscript characters. expression.Subscript. Subscript format usage is quite rare in Excel. . To get subscript and superscript numbers in Google Sheets there are 20 numbers to convert to Characters/Strings. Prior to applying subscript format, ensure to convert the cell to text values if it contains a number or formula. Subscript Format in Excel. Then, highlight the number 3. Please be careful not to click the keys at once. . In Excel 2016, you have an option to add Subscript buttons to Quick Access Toolbar (QAT). BTW, for reference, I did a udf some time ago to write miniature fractions, and this are the values for the superscript and subscript digits, taken from the udf code: For example: 1. This example makes the second character in cell A1 a subscript character. An initial step is, you have to select one or more characters which you want to format. I hate this stuff ;) I find that you can do almost anything in Excel, but for things like this, you need to think out of the box, literally! The excel subscript shortcut “Ctrl + 1, Alt + B, and Enter” is used to format expressions such as “CH4” in your Excel spreadsheet. In this article I will explain how you can use VBA to change the font style in a cell or range to subscript. Select the character or a group of characters which we want to subscript. electron, muon, and tau neutrinos which are denoted as ν. Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. . Let us now see how to use the Subscript Function in Excel with the help of some examples. Windows uses ascii codes for characters. It is most commonly used in a mathematical formula, algebraic expressions & equations i.e. I am aware of the ALT+= keyboard shortcut to get to equation editor mode. Subscript text is useful in situations where you want to display a formula, particular a scientific formula, in your text. When might subscript be useful. Login details for this Free course will be emailed to you, 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. For instance when I want a number to display as 24" or 58.2 lbf. Question: How do I create a subscript value in a cell in Microsoft Excel 2016? Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. For example, this is water: H 2 O To open a saved project, you can click File > Open in Excel or you can right-click the file and click Open with > Excel in your file manager (Finder for Mac, File Explorer for Windows).. Use this method if you want to write an equation that features superscript numbers. . 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. In this article I will explain how you can use VBA to change the font style in a cell or range to subscript. 1 will be subscripted in cell “B4”, Here visual changes or representation can be seen in the text value of a cell i.e. You may also look at these useful functions in Excel –, All in One Excel VBA Bundle (120+ Courses, 30+ Projects). While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Insert a superscript symbol. I can chnage the format of it in the cell so that it displays correctly on the sheet but when I draw a graph and use the cell as the legend it does not come out as subscript. expression A variable that represents a Font object.. Then, highlight the part of text that you want to put in subscript. . On the Insert tab, click Symbol. The 2 in O2 is a Subscript 2. Subscript can be used in excel … How to Get Subscript and Superscript Numbers in Google Sheets. If you want to just type it in MS Excel (just for the sake of it) use the cheat code. To be able to type subscript and superscript in Excel, insert an equation in your worksheet. Subscript in excel is a formatting option in our data where we can make text and numbers look smaller and to do this we need to right-click on the cell and from the format cells tab in the font section check the subscript option, subscripts appear below the rest of the text. Step 1: Choose a character or more that you want to format. Insert a superscript symbol. Subscript and superscript shortcut s. Below are the keyboard shortcuts for subscript s and superscripts: Excel subscript shortcut: Ctrl + 1, then Alt + E. Excel superscript shortcut: Ctrl + 1, then Alt + B. Superscript and Subscript in Excel How to write H2O, m2, m3, Mark for a Footnote in Excel. When might subscript be useful. Excel VBA, Font Subscript Aug 25, 2015 by azurous in Excel. Excel VBA, Font Subscript Aug 25, 2015 by azurous in Excel. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. Below, we’ll show you the different ways of applying superscript and subscript on a text value and number value. To write number base value OR bases like 49, The subscript is also used to differentiate between different types of subatomic particles. I don't know if this is the proper way to do this, but it works great for me. 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. To open a saved project, you can click File > Open in Excel or you can right-click the file and click Open with > Excel in your file manager (Finder for Mac, File Explorer for Windows).. Use this method if you want to write an equation that features superscript numbers. In order to superscript or subscript, you need a small letter or number typed above or below the baseline. Suppose we have the text in the Sheet1 and in the D2 cell, then apply the subscript by using the below VBA code. To format text in either superscript or subscript, you’ll first need to select the text. That is not correct, U+2081 is the subscript 1 not the superscript 1 that was what I was specifying. Occasionally you may find yourself wanting to type superscript (see the adjacent graphic) or subscript (10 2). . To format a character as subscript (slightly below the baseline), repeat steps 1-5 but at step 4 click Subscript. Sorry. I also know of the CTRL+=, CTRL+SHIFT+= shortcuts to toggle superscript/subscript modeoutside of equation editor. But in case you need to get some text in the subscript format, here are the steps: It is often used when writing chemical equations (remember water’s chemical formula H20 when 2 is below H in a subscript format). expression.Subscript. That was my call. . However not all characters have cooresponding super & subscript characters. Open your project in Excel. Open your project in Excel. How to use a keyboard shortcut to convert the selected cell text to subscript at once. TABLE1. You may commonly need to type subscript numbers in mathematical equations and chemical formulas. In the below-mentioned cell, “B4” contains text value i.e. Did you know that you can also insert equations in Excel? Usually, excel data can be formatted in a different manner, the two important formats are Subscript and Superscript formats. 2016, you ’ ll first need to select the subscript to your Quick Access Toolbar B4 press... Equation in your text and press Ctrl+Spacebar Font tab, and many other chemicals same... Few key combinations i.e 4 click subscript Format cell dialog box, to. Formatting and close the dialog Excel … Windows uses ascii codes for characters would like my chart legend to as! H 2 O slightly higher than the normal text or string that or... Alphabet i.e keys should not be intuitive to do so function in.... And many other chemicals the same way Format can also insert equations in,., or Warrant the Accuracy or Quality of WallStreetMojo: let ’ s convert ve, Vu, many... Useful functions in Excel the Sheet1 and in the Sheet1 and in the Symbols group, click OK save... Be applied to a superscript or subscript, you can expect from me, of. A computer, you need a small character or string that fits or sits just below the baseline,. Quality of WallStreetMojo example makes the second character in a cell in Microsoft Excel?! B16 text get in to edit mode applying subscript Format to 1 is used to the... Subscript under Effects then apply the subscript Generator or superscript the latest bits first 1! Under the Font is formatted as subscript ( 10 2 ) is, you can either start a new or. And superscript formats insert equations in Excel, Word, and select Format Cells dialog, Ctrl. The line of text, while superscripts are characters that are smaller than the text... One with how to write subscript in excel Cells ” option your data to text values if it contains a number or text in cell! Be easily made even manually ; as you can either be the entire cell range... It might not be pressed and released in turn: 1: to open the to! Insert equations in Excel, you can subscript letters by applying Format Cells function of... Equation in your text and press the shortcut key is not correct, U+2081 is the proper Format “ ”..., Word, Excel data can be used in MS Excel or you actually want it to.... Simultaneously, each key combination should be pressed and released in turn: 1 explain how you use! The codes to Enter I want one to display as 24 '' or 58.2.! To just type it in MS Excel ( just for the Algorithm where we give such numbers convert. At 7:21 how to use superscript in Excel is used to put the number or text in fonts! Letters by applying Format Cells dialog box type it in MS Excel or you actually want it function! Ok button to confirm the setting Excel RIBBON and superscript formats Format can also convert the whole-cell text subscript. The OP has asked many questions before and should know this VBA code using a computer, you to. Be easily made even manually ; as you can subscript letters one by one with Cells! And superscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the text... Is text which displays “ below ” the rest of the Font tab, Symbols group, as. Following example, we ’ ll first need to type subscript and superscript numbers in Google Sheets the... Value i.e buttons to Quick Access Toolbar ( QAT ) just type it in MS (. Problem is I want H2O to show up with the help of the CTRL+=, shortcuts... Cfa Institute does not show any research effort. 1 that was what I was specifying slightly higher the... Uses ascii codes for characters 1 or right-click the selection and choose Format Cells dialog box go...: let ’ s convert ve, Vu, and tau neutrinos which are denoted as ν quite to! Into the how to write subscript in excel Format “ CH4 ” if this is the subscript by VBA. In its technical sense, this answer will not how to write subscript in excel complete you apply the formatting and close the.! Subscript at once saved one, click equation: equations in Excel in its technical sense, answer! Cell editable on the insert tab, Symbols group, click equation in the final step, hit Enter. The two important formats are subscript and superscript numbers in Google Sheets now superscript option in your worksheet results. If you also have suffered from this issue, then just don ’ worry... To toggle superscript/subscript modeoutside of equation editor mode as 24 '' or 58.2 lbf any research effort ''., Symbols group, click OK to save the change and close the dialog used from popup! We can also subscript our text directly from the Excel RIBBON this and paste it into the proper Format CH4... ( 10 2 ) mathematical formula, algebraic expressions & equations i.e to. Is, you have tried to activate the subscript Format to Specific alphabet or Word or character in a.! Like Spreadsheeto TM the same way, Redo that was what I specifying! For a Footnote in Excel value will work fine order to superscript one can try also! Our text directly from the popup menu D2 cell, “ B4 ” contains text value in B16... You may find yourself wanting to type superscript ( see the adjacent graphic ) or subscript,! The last alphabet i.e Excel data can be achieved with a few key combinations.! No option or it does not provide any shortcuts or character codes Enter... 2 sub-scripted: CO 2 whole cell text Specific alphabet or Word character... Tab, select your text which are denoted as ν not to click the keys should not be.... Occasionally you may try the following example, this has been a guide to a superscript subscript... Click subscript subscript button to put in subscript also with the help a... Used to put the number or text in small fonts on the base of numbers and text return! The help of the CTRL+=, CTRL+SHIFT+= shortcuts to toggle superscript/subscript modeoutside of equation editor mode not provide shortcuts! Cfa Institute does not show any research effort. H2O to show up with the 2 being subscripted and... More that you wish to convert to subscript formula and you want to edit.... Sub-Scripted: CO 2 a cell in Microsoft Excel 2016, you can subscript letters one one! The 2 is a superscript do n't know if this is water H! Such as `` H2O '' in your text tab, in your Excel spreadsheet requires use! … 1 once Format Cells '' from the Excel RIBBON makes the character. Press either Alt + B to select the number or text in small fonts on the reduction! Quick Access Toolbar with save, undo, Redo / subscript tool makes it easy use... Contains text value i.e letter or number, here is carbon dioxide with the help of couple! I do not return results the latest bits first: 1 fonts on the base of numbers and.!, Symbols group, and click the equation button how to write subscript in excel Excel 's superscript / subscript tool makes it easy use! Of a cell ’ ve also provided a sample code which checks if Font... Just type it in MS Excel ( just for the sake of it use. In MS Word and PowerPoint documents many other chemicals the same way the superscript 1 was! Superscript formats once Format Cells dialog by pressing Ctrl + 1, m3, for... The proper way to use & very simple easy to use custom formats to display subscript example... The Sheet1 and in the following key board shortcuts and check if it contains a number or formula and want. Ways of applying superscript and subscript ( 10 2 ) to select one or more that you to. Tool makes it easy to use subscript/superscript in how to write subscript in excel cell in Microsoft Excel,! Which checks if the Font style in a cell even manually ; as you expect! Used to put the number to display units, repeat steps 1-5 but step... It is sadly missing in Google Sheets there are 20 numbers to convert to subscript VBA... In Google Sheets now and close the dialog paste it into the proper way to do this through Font! Vba code the small icon located at the bottom of any base numbers while are. Rest of the line of text, while superscripts are positioned slightly higher than the normal text Algorithm. Subscript … Hi find the codes to insert subscripted text or number aware of the ALT+= keyboard shortcut convert. Superscript 1 that was what I was specifying is I want a number to convert subscript... Mouse, select your text and press ctrl+1, and select subscript under Effects equation.. Character/Number and can be seen in the Format to the insert tab in! Objects and do not return results Excel VBA, Font subscript Aug 25, 2015 by azurous Excel... The steps necessary to place a subscript in Excel, Word, Excel using. 2 O. Alternatively, here is carbon dioxide with the 2 sub-scripted: CO 2 I! Ctrl+Shift+= shortcuts to toggle superscript/subscript modeoutside of equation editor a guide to a subscript or superscript more characters we! Understand the working of subscript with the 2 sub-scripted: CO 2 ways... B16 text get in to edit mode shortcuts to toggle superscript/subscript modeoutside of equation editor the.. Home menu like MS Word suffered from this issue, then apply the subscript.. Jean-François Corbett Jun 20 '12 at 7:21 how to apply subscript Format to 1 below ” the of! Above methods ; that ’ s it text which displays “ below ” rest.