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