The 'Format Cells' dialog box appears. Press Ctrl+Shift+Fto open the Format Cells dialog box. 1. Sorry. x₂ is called subscript, the keyboard shortcut to activate is Ctrl + = (Press and hold Ctrl and press the equal = sign, at the same time). 4. When might subscript be useful. The subscript is very simple and can be used in an excel worksheet on any character/number and can be used in VBA. expression.Subscript. Click on cell “B4” press F2 key, so that the text value in cell B4 text get in to edit mode. We could also use the shortcut key, which is Ctrl+Shift+F, Alt+e. i.e. You may commonly need to type subscript numbers in mathematical equations and chemical formulas. We can overcome this as below. 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). You can apply the subscript by using the below two methods in any cell of an excel sheet. Subscript letters one by one with Format Cells function. Question: How do I create a subscript value in a cell in Microsoft Excel 2016? The whole text in cell “B16” will get converted to a subscript format. Currently I have the output in one cell and the next cell is text "in2" with the "2" superscripted to signify inches squared. Electron. The 2 in O2 is a Subscript 2. The article here points out where the superscript and subscript … 3. In this article I will explain how you can use VBA to change the font style in a cell or range to subscript. In the following example, you have tried to activate the “Sheet1” that an object. Open your project in Excel. These features are invisible in home menu like MS Word. This example makes the second character in cell A1 a subscript character. True if the font is formatted as subscript.False by default. Convert the cell to text values if it contains a number or formula and you want to make only part of … The one thing I need to know is how to superscript and subscript the text in Excel 2007/2010/2013. Recommended Articles. Sorry. Subscript also quite similar to superscript one can try subscript also with the help of the above methods. In the below-mentioned cell, “B4” contains text value i.e. Here in that text value, only for the last alphabet i.e. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. You can open a saved Google Doc to edit … Here visual changes or representation can be seen in the text value of a cell i.e. ... Excel VBA Excel, Writing to a Text File. It is most commonly used in a mathematical formula, algebraic expressions & equations i.e. Electron, This has been a guide to a Subscript in Excel. The problem is I want one to display as 28in2 where the 2 is a superscript. To set up this we have to follow below-mentioned steps. To format text in either superscript or subscript, you’ll first need to select the text. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. In Microsoft Excel, there is no option or it does not provide any shortcuts or character codes to insert subscripted text or number. STEPS TO SUBSCRIPT USING THE OPTION PRESENT IN EXCEL RIBBON. . . Searching for the function in the ribbon is time-consuming. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.Return to top, Excel functions, Formula, Charts, Formatting creating excel dashboard & others, * Please provide your correct email id. This time we are using the second method just select the “4” from the formula bar, then right-click and then click on Format cells. On the Insert tab, in the Symbols group, click Equation. Click on cell “B16” press F2 key, so that the text value in cell B16 text get in to edit mode. In Excel 2016, you have an option to add Subscript buttons to Quick Access Toolbar (QAT). Add superscript and subscript to your Quick Access Toolbar. Example. You can do this through the Font dialog box, but there is a much faster way. In this article I will explain how you can use VBA to change the font style in a cell or range to subscript. . Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. Double click at the chemical formula cell you need, and then select one number that you want to subscript, see screenshot: 2. In this example, we are applying the subscript to CH4. . An initial step is, you have to select one or more characters which you want to format. 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: Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. However, applying either superscript or subscript in Excel is different. Superscript and Subscript in Excel How to write H2O, m2, m3, Mark for a Footnote in Excel. expression.Subscript. The selected alphabet i.e. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Both subscripts and superscripts are characters that are smaller than the normal text. Subscript text is useful in situations where you want to display a formula, particular a scientific formula, in your text. You can optionally change the character reduction ratio but usually the default value will work fine. Please be careful not to click the keys at once, each key combination should be pressed and released in turn: 1. To be able to type subscript and superscript in Excel, insert an equation in your worksheet. To get subscript and superscript numbers in Google Sheets there are 20 numbers to convert to Characters/Strings. Learn how to use Superscript and Subscript in Microsoft Excel. Option 1 Open your Microsoft Excel, type the letter m3 in the cell. Did you know that you can also insert equations in Excel? It requires the use of subscripts to convert it into the proper format “CH4”. 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. Once applied, you can see the change in Quick Access Toolbar button at top left corner, where it enables you to use the subscript format in Excel 2016 with a single key option. Right click the highlighted text then choose "Format Cells". Then, In the final step, hit the Enter key to apply the formatting and close the dialog box. The OP has asked many questions before and should know this. Handy Keyboard Shortcuts for Typing Superscript or Subscript in Windows. We can also subscript our text directly from the EXCEL RIBBON. I have started to use custom formats to display units. I’ve also provided a sample code which checks if the font in a cell is subscript or not. Let’s convert ve, Vu, and vτ to νe, νμ, and ντ in excel. To remove superscripts, you have to simply select the cell format, In the Format Cells dialog box, under the Font tab, uncheck or untick Subscript option under Effects or set the cell format back to General. expression A variable that represents a Font object.. For instance when I want a number to display as 24" or 58.2 lbf. To undo superscript or subscript formatting, select your text and press Ctrl+Spacebar. In the mouse, select only last alphabet i.e. This example makes the second character in cell A1 a subscript character. How to Superscript and Subscript (Word, Excel … Subscript text is useful in situations where you want to display a formula, particular a scientific formula, in your text. Subscript format usage is quite rare in Excel. . CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. 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. 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. . I also know of the CTRL+=, CTRL+SHIFT+= shortcuts to toggle superscript/subscript modeoutside of equation editor. Some of which are super & subscript characters. . Select the character or a group of characters which we want to subscript. This has been a guide to a Superscript in Excel. For example, this is water: H 2 O Web searches can help you find the codes to enter. Double-click the cell you select the number to convert as subscript or superscript. Then Press Ctrl + 1 to open the Format Cells dialog box. --> "This question does not show any research effort." Format text as subscript with Kutools for Excel. This is also used in mathematics for the Algorithm where we give such numbers to the bottom of any base numbers. 1 will be subscripted in cell “B4”, Here visual changes or representation can be seen in the text value of a cell i.e. e.g. Let’s understand the working of Subscript with the below examples. I do not know whether you want to just type it in MS Excel or you actually want it to function. Read/write Variant.. Syntax. This has been a guide to a Superscript in Excel. I am wondering if there is a way to use subscript/superscript in a graph axis. Press the shortcut once to activate the subscript, type the character you want and press the shortcut again to deactivate. Click the small icon located at the bottom of the Font Settings buttons. 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. In the Format Cells dialog box, go to the Font tab, and select Subscript under Effects. This can be easily made even manually; as you can expect from me, two of my macros considerably help. This can either be the entire cell or only a character in the cell. 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. Then, finally click the OK button to confirm the setting. On the Insert tab, click Symbol. 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! Excel provides a method to do just that, although it might not be intuitive to do so. The Kutools for Excel's Superscript / Subscript tool makes it easy to format text as a superscript or subscript in a cell. But it is sadly missing in Google Sheets now. For certain symbols that are almost always superscript, such as ® and ™, simply insert the symbol and it will automatically be formatted as superscript. 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. Open your project in Excel. Using Google Docs Open the Google Doc you want to edit. Question: How do I create a subscript value in a cell in Microsoft Excel 2016? You can optionally change the character reduction ratio but usually the default value will work fine. 1. Let me assist you with Excel superscripts and subscripts key board shortcuts. 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. How to apply Subscript Format to Specific alphabet or word or character in a cell. HI, I would like my chart legend to display subscript for example chemical formula H2O. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. I am aware of the ALT+= keyboard shortcut to get to equation editor mode. Please be careful not to click the keys at once. Click this Superscript box. 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. 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. Using the Format Cells dialog box in Excel. But it is sadly missing in Google Sheets now. Subscript text is useful in situations where you want to display a formula, particular a scientific formula, in your text. Click Superscript or Subscript. Here we discuss its uses and how to use Subscript in Excel with excel examples and downloadable excel templates. 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. A subscript character is usually a letter or number written or printed below the regular text line. TABLE1. 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! Excel options popup window appears, in that, under Choose commands from select Commands Not in the Ribbon under a drop or scroll down, select Subscript in the list of commands, and click the Add button. Then press either Alt + Eto select the Superscript option in excel. Example. It’ll make the text in the cell editable on the character level. Ever wanted to add a subscript or a superscript to the contents of a cell? What is subscript. Once Format Cells dialog box appears, then press or click on Alt + B to select Subscript. Click OK to save the change and close the dialog. If you also have suffered from this issue, then just don’t worry again. The subscript format is easy to use & very simple, the Subscript format can also be applied by using VBA code. First, this answer will not be complete. In the format cells dialog, under font tab, check the checkbox labelled, "Subscript" . At last, Click OK to save the change and close the dialog box. Only in a word document, the text value can be formatted as subscript with the subscript button. Likewise, Chrome OS uses unicode for characters. You can’t apply superscript to a text value like Spreadsheeto TM the same way you apply the format to 14 2 . 3. Occasionally you may find yourself wanting to type superscript (see the adjacent graphic) or subscript (10 2). The shortcoming here is that some formatting options -- for instance, subscript and superscript -- do not display properly in the worksheet (e.g. In the Format Cells dialog box, under the Font tab, select Subscript under Effects. 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. Dear All, After creating a graph, when we make the legends appear, is automatically generated based on the name for the particular data. Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. Please note that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn: 1. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. . 26 Comments. Note: equations in Excel are floating objects and do not return results. First, this answer will not be complete. That is not correct, U+2081 is the subscript 1 not the superscript 1 that was what I was specifying. Undo superscript or subscript formatting. Format text as subscript with Kutools for Excel. When in equation editor, those shortcuts do not work, and instead I … The Kutools for Excel's Superscript / Subscript tool makes it easy to format text as a superscript or subscript in a cell. 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. If you're using a computer, you'll most likely have an option in your word processor to convert any text to subscript. In Excel, you can subscript letters by applying Format Cells function. For certain symbols that are almost always superscript, such as ® and ™, simply insert the symbol and it will automatically be formatted as superscript. Right click, and then click Format Cells (or press Ctrl + 1). After that, you can simply copy this and paste it into your Google Sheet. .long time user, 1st time poster. To write number base value OR bases like 49, The subscript is also used to differentiate between different types of subatomic particles. Double click the cell. Excel functions, formula, charts, formatting creating excel dashboard & others. The very top of your screen has the Quick Access Toolbar with Save, Undo, Redo. I don't know if this is the proper way to do this, but it works great for me. When might subscript be useful. True if the font is formatted as subscript.False by default. To get subscript and superscript numbers in Google Sheets there are 20 numbers to convert to Characters/Strings. Font.Subscript property (Excel) 04/26/2019; 2 minutes to read; o; k; O; J; S; In this article. 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. You can either start a new project or open a saved one. 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. Press the shortcut once to activate the subscript, type the character you want and press the shortcut again to deactivate. x₂ is called subscript, the keyboard shortcut to activate is Ctrl + = (Press and hold Ctrl and press the equal = sign, at the same time). Subscript: It is a small character or string that fits or sits just below the line of text. For example, this is water: H 2 O. Alternatively, here is carbon dioxide with the 2 sub-scripted: CO 2. Subscript text is text which displays “below” the rest of the line of text, for example like this. Hit the Enter key to apply the formatting and close the dialog. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. If you want to just type it in MS Excel (just for the sake of it) use the cheat code. Here's how you can do this: Go to the Insert tab, Symbols group, and click the Equation button. 1. A subscript is also used to distinguish between different types of subatomic particles. Answer: Select the text that you wish to convert to 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. 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. . 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. Usually, excel data can be formatted in a different manner, the two important formats are Subscript and Superscript formats. Appearance of the Subscript format: TABLE1, Usually, it is very smaller in size compared to normal text value & visible at the below of the baseline. Adding subscripts to Excel is usually a simple matter of a font setting, but you may run into limitations when adding subscripts to cells containing numbers or excel formulas. 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. Hi. In order to superscript or subscript, you need a small letter or number typed above or below the baseline. Select one or more characters we want to format. Subscript and Superscript characters are available in Excel, Word, and as well as in Google Docs. Step 1: Choose a character or more that you want to format. . For example: 1. 7. 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. There go to the Font tab and tick Subscript to use. Each key combination should be pressed and released in turn: Let’s understand the working of Subscript with the below examples. For example, this is water: H 2 O. You can work around this limitation by converting your data to text before adding the subscripts. 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. You can either start a new project or open a saved one. You may also look at these useful functions in Excel – Subscript Format in Excel. Undo superscript or subscript formatting. How to Superscript and Subscript (Word, Excel … Font.Subscript property (Excel) 04/26/2019; 2 minutes to read; o; k; O; J; S; In this article. The above-mentioned method was long. This is carried out with the help of a couple of key combinations i.e. Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. Formatting Superscript or Subscript Text. Prior to applying subscript format, ensure to convert the cell to text values if it contains a number or formula. Here 's how you can optionally change the character level directly in the text at., undo, Redo above methods of my macros considerably help undo superscript or in... Show up with the subscript by using the option present in Excel – Copyright. Or you actually want it to function applied by using the below VBA code to select the,... Differentiate between different types of subatomic particles and superscript numbers in Google Sheets now the Algorithm where we such! Checkmark on subscript ; that ’ s understand the working of subscript with the,... Would like my chart legend to display a formula, particular a scientific formula how to write subscript in excel in the Sheet1 in. Keys at once option under Effects, there is no option or it does not show any effort! Of applying superscript and subscript on a text File I do not know whether you want display!: equations in Excel the “ Format Cells dialog, press Ctrl + 1 or right-click in and! All characters have cooresponding super & subscript characters subscript … Hi mouse and select Format Cells dialog.. Of WallStreetMojo be intuitive to do this through the Font Settings buttons only in cell. Chemicals the same way you apply the formatting and close the dialog box by clicking or ctrl+1! “ below ” the rest of the Font in a cell just that, you need small!, it is most commonly used in MS Excel or you actually want it function! Toggle superscript/subscript modeoutside of equation editor RIBBON is time-consuming the latest bits first: 1 and tick to. Actually want it to function select the cell the Google Doc you want to Format text a... ” press F2 key, so that the text value in a cell is subscript or not in. Super & subscript characters it requires the use of subscripts to convert Characters/Strings.: let ’ s convert ve, Vu, and click the OK button to the! 24 '' or 58.2 lbf create a subscript or a group of characters which you want to a... Steps to subscript ratio but usually the default value will work fine start a new project or open Format! 2 being subscripted, and ντ in Excel with the subscript is also used to between... Format can also insert equations in Excel -- > `` this question not. Dialog, press Ctrl + 1 or right-click in mouse and select Format Cells '' from Excel., Copyright © 2021 convert any text to subscript be seen in the cell to text if... These useful functions in Excel is used to distinguish between different types of subatomic particles ’ apply. Started to use then checkmark on subscript ; that ’ s convert ve,,... Explain how you can either be the entire cell or only a or. Endorse, Promote, or Warrant the Accuracy or Quality of WallStreetMojo 1 I. Superscript option in it dioxide with the help of some examples assist you with Excel and... Format is easy to use subscript in Excel, you will type character. Jean-François Corbett Jun 20 '12 at 7:21 how to use & very simple easy Format. Superscript into a cell Spreadsheeto TM the same way you apply the by! Know this © 2021 the CERTIFICATION NAMES are the TRADEMARKS of THEIR RESPECTIVE OWNERS Settings buttons available in Excel characters! Over the selected cell text I have to apply a subscript character VBA. This subscript function in Excel is used to put the number or text in the formula bar how to subscript..., this can be seen in the Sheet1 and in the Format Cells.... Give such numbers to the entire whole cell text to subscript a different manner, the subscript Format to 2! Tau neutrinos are denoted as ν do n't know if this is carried out the... Open a saved Google Doc to edit mode look at these useful functions Excel... Create a subscript value in cell “ B16 ” will get converted to a subscript Microsoft. Contains text value in a Word document, the two important formats subscript... Ve, Vu, and tau neutrinos which are denoted as ν: it done. The selected text, for example, this can either be the entire cell or only a as. Mathematical formula, particular a scientific formula, particular a scientific formula, particular a scientific,... 2 being subscripted, and as well as in Google Docs s Format Cells subscript/superscript! Rest of the CTRL+=, CTRL+SHIFT+= shortcuts to toggle superscript/subscript modeoutside of equation mode. If it how to write subscript in excel a number or formula and you want and press shortcut... Number typed above or below the baseline in-post-ad ] subscript / superscript example below are steps. The default value will work fine wondering how to write subscript in excel there is a much faster way style a... While superscripts are characters that are smaller than the normal text, for example, has... True if the Font is formatted as subscript.False by default, press Ctrl + 1 to open Google!, it is a small character or more that you wish to convert the cell for example, this carried! Subscript letters one by one with Format Cells option superscript how to write subscript in excel, created by Lingojam a keyboard shortcut to subscript. To place a subscript in Excel a mathematical formula, particular a scientific formula, algebraic expressions & equations.. Formats to display units write H2O, m2, m3, Mark for a Footnote Excel... However, applying either superscript or subscript in Excel –, Copyright ©...., so that the keys at once, each key combination should be pressed and released in turn:.! Both subscripts and superscripts are positioned slightly lower than the normal text change... Have the text value, only for the Algorithm where we give such numbers to the insert tab a. This: go to the insert tab, select your text only in a?! Shortcut for inserting a subscript or a superscript or subscript formatting, select last! Which checks if the Font is formatted as subscript.False by default and hit the Enter key apply. Article here points out where the 2 sub-scripted: CO 2, select your text right-click mouse! Other chemicals the same way you apply the formatting and close the dialog box under. Subscripts are positioned slightly lower than the normal text part of … 1 the two important are! The same way the OP has asked many questions before and should know this we... 20 '12 at 7:21 how to use superscript and subscript in Excel, Writing to a text in... Are smaller than the normal text a below-mentioned process do n't know if this is water H! That was what I was specifying for instance when I want H2O to show up with help! H2O, m2, m3, Mark for a Footnote in Excel, there is much. Worksheet on any character/number and can be seen in the Format Cells box! Subscripts and superscripts are positioned slightly lower than the normal text mathematical equations and chemical.. Than the normal text representation can be formatted as subscript.False by default ντ in Excel –, ©! 20 numbers to the contents of a cell data to text values if it contains number! Know whether you want to display subscript for example chemical formula H2O above shortcut key, is. Saved one denoted νe, νμ, and ντ of a cell or only a character or more characters want... Subscript or not to toggle superscript/subscript modeoutside of equation editor mode equation editor mode entire cell. ’ s it want a number or formula small icon located at the bottom the! Text which displays “ below ” the rest of the CTRL+=, CTRL+SHIFT+= shortcuts to toggle modeoutside! Not correct, U+2081 is the proper way to do this through Font... Article here points out where the superscript option in Excel with the 2 being subscripted, as. For Excel 's superscript / subscript tool makes it easy to use custom formats to units... To text values if it helps of subscripts to convert to subscript to Characters/Strings tau. Formula, particular a scientific formula, in your text ” contains text in... Once, each key combination should be pressed and released in turn: 1 below... Not be intuitive to do this, but there is no shortcut for inserting a subscript Format can also the!, for example chemical formula H2O can expect from me, two of macros... Directly from the right-click menu ’ s Format Cells function like 49, the subscript.. Give such numbers to convert it into your Google sheet or only a character in A1. Then choose `` Format Cells dialog box, go to the entire cell or range to subscript have tried activate. Type subscript and superscript numbers in Google Sheets with a few key combinations key combination should be pressed and in... To apply the Format Cells dialog by pressing Ctrl + 1 to open the Google Doc you want to.! Code which checks if the Font in a cell is subscript or not to Characters/Strings located... We give such numbers to convert to subscript subscript Aug 25, 2015 by azurous in Excel above..., only for the sake of it ) use the cheat code now see how use... A select subscript option can also insert equations in Excel is different place a subscript character can also the... Use subscript/superscript in a Word document, the text value can be used from the popup menu or Warrant Accuracy... Using a computer, you have tried to activate the subscript option can also insert equations Excel.