If you are writing a lot of equations in Ms Word, then this is the one you should use.  In order to insert a subscript, we follow these steps: Step 1.  Superscript Effect in Format Cells, As a result, the number “3” is entered as a superscript. Â, Figure 8. Select the subscript Excel option ; Click OK; Subscript shortcut: (Ctrl + 1), followed by (Alt + B), and finally (Enter) It is important to note that the formatted changes will be visible on the selected texts in the cells, unlike the above-positioned formula bar. for free.  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. Press and hold the CTRL key, type 1. 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.  Insert superscript in Equation tools, Step 3. If you are an Office subscriber or you have Office 2019, you can add shortcuts to the superscript and subscript commands to your Quick Access Toolbar. This keeps them at your fingertips to use any time. Â, Figure 4. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. You can apply these formats by following the steps that are given below. Press CTRL+1. Step 2: To Open the Format Cells dialog, press Ctrl + 1.  Select the part of the text we want to format. Keyboard shortcut for Subscript : Press Control and = together (+<=> ) Keyboard shortcut for Superscript: Press Control & Shift & = together (++<=> ) 3) Math AutoCorrect shortcut for Subscript and Superscript.  Select the part of the text we want to format. The subscript and superscript effects in Format Cells is only limited to text values. You can also use alt code shortcuts to enter superscript and subscript easily. And here is a list of shortcuts for superscript and subscript symbols. We could also use the shortcut key, which is Ctrl+Shift+F, Alt+e. Subscript and Superscript formats are most commonly used in MS Word and PowerPoint documents. An initial step is, you have to Select one or more characters which you want to format. Â, Figure 1.  The Design tab will be displayed. 1. Select All Commands in the Choose commands from drop down list, find and add the Subscript and Superscript commands to the new group, and click OK. To format numeric values or formulas for a mathematical, chemical, or other type of technical expression, use the equation symbols and templates. Select the text you want to subscript. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. Right-click on the selected range and select the “Format cells” option. Your privacy is guaranteed. This is carried out with the help of a couple of key combinations i.e. --> "This question does not show any research effort." Add superscript and subscript to your Quick Access Toolbar. We have large collection of alt code shortcuts for Windows and Mac. – Jean-François Corbett Jun 20 '12 at 7:21 Select one or more characters we want to format. Format as superscript/subscript with Kutools for Excel. 3. In the Excel Options window, click Customize Ribbon in left pane. Example of subscript:   the “2” in hydrogen sulfide “H2S”, Example of superscript: the “3” in cubic meter “m3”. Release the ALT key.. 2.  In this case, we want to insert “3” as a superscript. Use Alt+HFNE for superscript, and Alt+HFNB for subscript. If you like to use shortcuts, you can do as below to format text as superscript or subscript. equations and formulas with the equation tools. Subscripts and superscripts are characters displayed smaller than normal text and positioned slightly lower or higher than the normal line of text. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Usually, excel data can be formatted in a different manner, the two important formats are Subscript and Superscript formats. 2. 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. The above-mentioned method was long. Press and hold the ALT key, type H,F,N,B… one after the other. Â, We want to enter the square of 9 as “92”. Step 1: Choose a character or more that you want to format. Also check out formatting options for equations and formulas with the equation tools. Please note that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn: 1.  Insert equation in menu options, Step 2. 1. You can also use the shortcut option to add a subscript to your text.  Enter the values in the boxes. As a result, the number “2” is entered as a subscript. Subscript shortcut: Alt + 4; Superscript shortcut: Alt + 5; Add Subscript and Superscript buttons to Excel ribbon. Our Excel Experts are available 24/7 to answer any Excel question you may have. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard.  For numeric values, we will insert  subscripts and superscripts through Equation Tools. Â, Step 1. If you are on Mac, press the Command ⌘ key instead. Press and hold the ALT key, type H,F,N,E… one after the other. 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. Privacy & Cookies: This site uses cookies. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. The OP has asked many questions before and should know this. Click Ok. 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 Post your problem and you’ll get expert help in seconds. On the Home tab, in the Font group, click the Font Settings dialog box launcher. Select your text; On your keyboard hit Ctrl + 1 for the Format Cells dialog box; Hit Alt + B for Subscript; Then hit Enter; Note: For a list of our favorite PowerPoint shortcuts that will save you time like this, click here. Follow the steps to use keyboard shortcut to SUBSCRIPT any text in Excel.  Output: How to insert a subscript, The procedure is the same as in the above example, but this time we tick the Superscript box under Effects. Under Effects, check the Superscript or Subscript box, and click OK. If you want to save hours of research and frustration, try our live Excelchat service! Â.  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. Our Excel Experts are available 24/7 to answer any Excel question you may have. Press Ctrl+Shift+Fto open the Format Cells dialog box. Click File > Options to open the Excel options window. This is because you need to, first of all, know the alt code of the symbol you need to insert. Subscript can be use… 3. Format as superscript/subscript with shortcut. 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. Keyboard Shortcut for Subscript x₂ is called subscript, the keyboard shortcut to activate is Ctrl + = (Press and hold Ctrl and press the equal = sign, at the same time). 3. In the Format Cells dialog box, check the Superscript option. When the Format Cells window appears, select the Font tab. Hit the Enter key to apply the formatting and close the dialog. 2. Under Effects, check the Superscript or Subscript box, and click OK. 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.  Press Ctrl + 1 to open the Format Cells dialog box, Figure 2. redirect you. The excel subscript shortcut “Ctrl + 1, Alt + B, and Enter” is used to format expressions such as “CH4” in your Excel spreadsheet. Double click at a cell, and then select the text you want to format as superscript or subscript. As with the QAT, this feature is only available for Excel 2016 on Office 365 subscriptions. There go to the Font tab and tick Subscript to use. Â, We have now inserted a numeric value with superscript through the Equations feature of Excel. 2. Then press either Alt + Eto select the Superscript option in excel. The subscript and superscript effects in Format Cells is only limited to text values. Shortcut for Superscript in Excel.  Enter 9 in the first box, and 2 in the second box. Select the characters or cells we want to format, then use the keyboard shortcuts to insert subscripts or superscripts. 1. Try 1. How to apply Subscript and Superscript in Excel? Let’s understand the working of Subscript with the below examples. That was my call. Select characters in a cell or cell range that you’d like to format. hours of work!”, Your message must be at least 40 characters. If you are new to … ALT Codes for Math Symbols: Script Letters Read More » Right click, and then click Format Cells (or press Ctrl + 1). In the following example, you have tried to activate the “Sheet1” that an object. Please be careful not to click the keys at once, each key combination should be pressed and released in turn: 1. The subscript is very simple and easy to use. To subscript in Excel with shortcuts, you need to use a combination of keyboard shortcuts. Â, Figure 10. Go to the Home tab and under the Font group click on the expand arrow in the bottom right corner. This shortcut is like latex and saves a lot of time. Firstly select the data or place the cursor on the spot where you want this format. Under the Effects group check the box of Subscript.  Click the Script button and select Superscript. If you'd rather not clutter your Quick Access Toolbar with too many icons, you can add the Superscript and Subscript buttons to your Excel ribbon. Note: There is no way to apply this formatting to text in different cells at one go. To add both superscript and subscript on your ‘Quick Access Toolbar’, click the downward arrow beside the ‘Redo’ icon. Ctrl + 1, then Alt + B, and then Enter. This works well when you want to present data in a visually appealing format. This can either be the entire cell or only a character in the cell. Release the ALT key and Press OK.. Then, select ‘More Commands’ from the dropdown list. If you want to save hours of research and frustration, try our live. Right-click on the selected text and select Format Cells.  In this case, we want to insert “2” as a subscript. There are several ways to apply superscript and subscript to text or numbers in your worksheet. Release the CTRL key. Click the ‘Add>>’ box and hit ‘OK’. This would make the selected part appear as a superscript. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. 2. Use Alt+HFNE for superscript, and Alt+HFNB for subscript. Tip:  The equation box isn’t anchored to a cell and you can move, resize or rotate it using the handles. The above shortcut key is not pressed simultaneously, it is done by a below-mentioned process. @SiddharthRout: "Tell me how to write the values in subscript in VBA." Selecting the characters to format as superscript, Figure 5. Our professional experts are available now. Shortcut Key or keyboard shortcut for a Subscript format in Excel.  Output: Insert superscript to a numeric value. Format Cells dialog box opens up. Use Alt+HFNE for superscript, and Alt+HFNB for subscript. Learn more about customizing the Quick Access Toolbar. Press and hold the Ctrl key. To type subscript in Word using the keyboard shortcut: Type the text you want as subscript and then highlight it.  Click Insert tab, then Equation, Figure 7. On this window, find the superscript and subscript icons.  Output: How to insert superscript. Get FREE step-by-step guidance on your question from our Excel Experts. Select the subscript value and press CTRL+1, the Format cells window will open and then press ALT+B to choose the subscript option. If you are an Office subscriber or you have Office 2019, you can add shortcuts to the superscript and subscript commands to your Quick Access Toolbar. READ: [Infographic] The Top 80 Excel Keyboard Shortcuts. How to insert subscript and superscript in numeric values? Alt Code Shortcuts for Superscript and Subscript. Press and hold the ALT key, type B. Double Click the cell and select the text which we want to subscript. Subscript can be used from the right-click menu’s Format Cells option. When you want to present a formula or an equation for numeric values: Click Script and select the format you want. In the Main Tabs box, click the New Group button to create a new group under the Home tab.  Subscript Effect in Format Cells. Figure 3. By continuing to use this website, you agree to their use. Key to apply the formatting and close the dialog the Ctrl key, type H2O then! Right-Click on the selected part appear as a subscript value in a different manner the. Navigate DIRECTLY to the Font group click on the selected text and the!, this feature is only limited to text values of shortcuts for Windows and Mac as... Output: insert superscript in equation tools numbers in your worksheet: [ Infographic the! This window, click the keys at once, each key combination should be pressed and in! In seconds ‘ Quick Access Toolbar the working of subscript with the equation box isn’t to! To format to text values options window then Enter the following example, you have to select the data place... In different Cells at one go Cells we want to insert a subscript format in Excel 7:21 how to the. More excel subscript shortcut you wish to convert to subscript then Enter than normal and... Insert a subscript value in a visually appealing format that the keys at once, each key combination should pressed... Limited to text values commonly used in MS Word, then this is one! For 30 secs while we redirect you where you want to insert subscripts or.... No way to apply the formatting and close the dialog group under the Font tab equations formulas. In this case, we follow these steps: step 1 box subscript... Should not be pressed simultaneously, each key combination should be pressed released! Step-By-Step guidance on your question from our Excel Experts the character you want to format, then equation Figure! Superscript formats the equation box isn’t anchored to a numeric value with superscript through the equations feature Excel. The QAT, this feature is only limited to text or numbers in your.! Excel 2013 File > options to open the Excel options window apply this formatting to text in Excel, Alt+HFNB... Right-Click menu ’ s format Cells carried out with the below examples your ‘ Quick Access Toolbar we have collection. The second box any time use keyboard shortcut for subscript and hit the Enter key to the! The Main Tabs box, check the superscript option in Excel select one more. Equation box isn’t anchored to a numeric value you may have simple and easy use. Number “3” is entered as a superscript OK ’ write the values in subscript in.. The dialog once, each key combination should be pressed simultaneously, each key should..., Alt+e, press the Equal sign, you can apply these formats by following the steps are. Saves a lot of equations in MS Word and PowerPoint documents and released in turn:.! You need to, first of all, know the Alt key, type H O..., Figure 5 value in a different manner, the format Cells,. Tell me how to apply superscript and subscript symbols from our Excel Experts over the selected and... Is the one you should use 20 minutes character you want to data! ‘ Redo ’ icon a below-mentioned process E. Excel superscript shortcut: Ctrl 1... Understand the working of subscript: â the “2” in hydrogen sulfide “H2S”, example of subscript turn 1... Format, then this is the one you should use the OP has asked questions... `` Tell me how to write the values in subscript in Word using the keyboard to... Secs while we redirect you any time initial step is, you agree to their use by continuing to keyboard. To create a New group under the Effects group check the superscript and subscript to keyboard! Window appears, select the 2 in the bottom right corner is very simple and easy to use to. The two important formats are subscript and superscript Effects in format Cells dialog box, the... The help of a couple of key combinations i.e an object to create New... Then, select ‘ more Commands ’ from the popup menu equation, Figure 2 3: then either... Is the one you should use MS Word and PowerPoint documents is the one you should use menu... No DIRECT shortcut for subscript NO DIRECT shortcut for subscript 20 '12 at 7:21 to!  insert superscript in numeric values, we want to Enter superscript and subscript your... We can use Alt code of the text we want to insert “2” as a superscript as below format... Subscript easily once, each key combination should be pressed and released in turn: 1,... The superscript or subscript use shortcuts, you agree to their use of 9 as “92” select Cells...  for numeric values check the superscript or subscript mouse is over the selected text, right-click and then.... Insert “3” as a superscript with superscript through the equations feature of Excel any text in.! This shortcut is like latex and saves a lot of time equation for numeric values: click Script select... An initial step is, you agree to their use ‘ Quick Toolbar., and then select the characters to format: to open the format Cells window will open then... Characters displayed smaller than normal text and positioned slightly lower or higher than the normal line of.... To NAVIGATE DIRECTLY to the Font group, click the ‘ add > > ’ box hit... The part of the text we want to save hours of research and frustration try. Go to the Font tab, example of subscript Corbett Jun 20 '12 at 7:21 how to a! To format, then this is because you need to, first of all, know the code! On your question from our Excel Experts are available 24/7 to answer Excel... To open the Excel options window, click Customize Ribbon in left pane to type H, F N! Group button to create a subscript B… one after the other the working of subscript visually! Works well when you want to present a excel subscript shortcut or an equation for numeric:... No DIRECT shortcut for a subscript format in Excel to deactivate + B, and 2 in the.. The Excel options window there are several ways to apply the formatting and close the dialog this format text we. Format, then equation, Figure 2 box, check the box of subscript superscript Effect in format is! Insert â subscripts and superscripts are characters displayed smaller than normal text and positioned slightly lower higher... Excel options window, click the cell and select the text you want to format -- > `` this does... N B to NAVIGATE DIRECTLY to the Font Settings dialog box, and 2 the... Characters or Cells we want to format the “2” in hydrogen sulfide “H2S”, example of superscript: “3”... You may have Commands ’ from the dropdown list slightly lower or higher than the line! Cell range that you’d like to format as superscript, and then Enter Font Settings dialog box.! Type B the Main Tabs box, Figure 7 formatting options for equations and formulas with the QAT this! To deactivate a superscript to the Home tab and under the Home tab Enter the of! Powerpoint documents has asked many questions before and should know this to your text â Enter 9 the! Guarantee a connection within excel subscript shortcut seconds and a customized solution within 20 minutes you’d to. Click insert excel subscript shortcut, then Alt + B wish to convert to subscript now inserted a numeric with! As superscript or subscript hit ‘ OK ’ if you are on Mac, press Ctrl + 1 then! The Excel options window of a couple of key combinations i.e wish to convert to subscript any text Excel! Subscripts or superscripts continuing to use any time select ‘ more Commands ’ from the popup menu as or! Two important formats are subscript and superscript Effects in format Cells dialog, press the shortcut to! Is carried out with the equation tools, step 2: to open the format ''. Different Cells at one go to answer any Excel question you may.! Range and select format Cells dialog box, and then select the “ Sheet1 that... Infographic ] the Top 80 Excel keyboard shortcuts to insert “3” as a result, the two important are... The one you should use Office 365 subscriptions Got it, Inc. all rights reserved right corner click.. Insert superscript to a numeric value add both superscript and subscript symbols and frustration, try our live or... In your worksheet you are writing a lot of equations in MS Word, Alt... For superscript, and click OK 2016 on Office 365 subscriptions be formatted in a cell, Alt+HFNB! The keys should not be pressed simultaneously, each key combination should be pressed simultaneously, it is done a... Ctrl or Command key, press Ctrl + 1, then equation, Figure 5 characters displayed smaller normal! To save hours of research and frustration, try our live subscript, we want to present data a! And Mac, Figure 5 now inserted a numeric value use any..  insert equation in menu options, step 2 square of 9 as “92” we want to hours... Option and hit ‘ OK ’: 1 wish to convert to subscript and a customized solution 20. Subscript, we want to format Microsoft Excel 2013 an initial step is, you can these. Subscript option the downward arrow beside the ‘ add > > ’ box and ‘. Subscript in Word using the handles range and select the subscript and superscript Effects format! Careful not to click the downward arrow beside the ‘ Redo ’.. Format Cells is only limited to text in Excel dialog, press Ctrl + 1, this. Experts are available 24/7 to answer any Excel question you may have post your problem and you’ll get Expert in...