Subscript formatting is a number, figure or symbol that is smaller than the standard font type. Each key combination should be pressed and released in turn: Let’s understand the working of Subscript with the below examples. Bug report. This is also used in mathematics for the Algorithm where we give such numbers to the bottom of any base numbers. This can either be the entire cell or only a character in the cell. Applying superscript and subscript format in Excel isn’t straightforward unlike in Microsoft Word.. It’s understandable. 1. ALL RIGHTS RESERVED. Step 1: select one cell, and click the Superscript / Subscript button under Kutools tab; Step 2: select one character, and check the Superscript option, see screenshot (Fig. Hit the Enter key to apply the formatting and close the dialog. The subscript is very simple and can be used in an excel worksheet on any character/number and can be used in VBA. 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. when you present an equation or a formula in numeric value. 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. How to apply Subscript and Superscript in Excel? Contact Us. expression A variable that represents a Font object.. This is carried out with the help of a couple of key combinations i.e. The selected alphabet i.e. 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. But do not worry, Kutools for Excel’s Subscript Numbers in Chemical Formulas utility can quickly subscript all numbers in the selected cells. Click on cell “B4” press F2 key, so that the text value in cell B4 text get in to edit mode. Click the cell containing the text you want to make subscript. Excel functions, formula, charts, formatting creating excel dashboard & others. Step 2: To Open the Format Cells dialog, press Ctrl + 1. Select “nd” alone and do a right-click. . While your mouse is over the selected text, right-click and then select "Format Cells" from the … Here we learned the Error called Subscript out of range (Run-time error:'9') in Excel VBA. About Us. Check the Superscript checkbox. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. TABLE1. The above shortcut key is not pressed simultaneously, it is done by a below-mentioned process. Prior to applying subscript format, ensure to convert the cell to text values if it contains a number or formula. Furthermore, various professions that involve the advance application of numerical and alphabetical values and formulas also depend significantly on this skill. True if the font is formatted as subscript.False by default. We could also use the shortcut key, which is Ctrl+Shift+F, Alt+e. When the Format Cells window appears, select the Font tab. 3 : Superscript / Subscript button. Double click at the chemical formula cell you need, and then select one number that you want to subscript, see screenshot: 2. In Excel 2016, you have an option to add Subscript buttons to Quick Access Toolbar (QAT). You may also look at these useful functions in excel –, Copyright © 2021. 1 will be subscripted in cell “B4”, Here visual changes or representation can be seen in the text value of a cell i.e. There go to the Font tab and tick Subscript to use. In the formula bar, highlight the character you want to set as subscript. electron, muon, and tau neutrinos which are denoted as ν. 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. Let us now see how to use the Subscript Function in Excel with the help of some examples. I am wondering if there is a way to use subscript/superscript in a graph axis. If you have multiple numbers needed to be subscripted in chemical formulas, the above method must waste time and tedious. In order to insert a subscript, we follow these steps: Step 1. Press Ctrl+1 to open the Format Cells window. for t-values where degrees of freedom are given in subscripts, etc. It works fine in all the case but in some case like superscript or subscript, its not working! Under the Effects group check the box of Subscript. .long time user, 1st time poster. 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. In the Format Cells dialog box, under the Font tab, a select Subscript option under Effects. 1, I have to apply a SUBSCRIPT format to 1. The article here points out where the superscript and subscript … Subscript all numbers in a cell/range once with Kutools for Excel . This can either be the entire cell or only a character in the cell. Only in a word document, the text value can be formatted as subscript with the subscript button. Subscript can be used in excel … In this example, we are applying the subscript to CH4. With or without the leading zero seems to give an accurate representation. Please be careful not to click the keys at once, 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. The source for the data validation can be found in sheet 2: For more information about creating drop down lists in Excel please see Excel … Answer: Select the text that you wish to convert to subscript. Here we discuss its uses and how to use Subscript in Excel with excel examples and downloadable excel templates. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Hi. 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. Then, highlight the part of text that you want to put in subscript. 7. 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. To add both superscript and subscript on your ‘Quick Access Toolbar’, click the downward arrow beside the ‘Redo’ icon. Definite integrals are some of the most common mathematical expressions, let's see an example: In LaTeX, subscripts and superscripts are written using the symbols ^ and _, in this case the x and y exponents where written using these codes. 1. e.g. Format Cells dialog box opens up. Post in forum. In the mouse, select only last alphabet i.e. Here visual changes or representation can be seen in the text value of a cell i.e. There is no shortcut for inserting a subscript in Excel in its technical sense, this can be achieved with a few key combinations. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. Question: How do I create a superscript value in a cell in Microsoft Excel 2016? In Microsoft Excel, there is no option or it does not provide any shortcuts or character codes to insert subscripted text or number. Then, In the final step, hit the Enter key to apply the formatting and close the dialog box. Answer: Select the text that you wish to convert to subscript. To set up this we have to follow below-mentioned steps. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. I am reading excel file using Microsoft.Office.Interop.Excel. The one thing I need to know is how to superscript and subscript the text in Excel 2007/2010/2013. Open the Format Cells dialog by pressing Ctrl + 1 or right-click the selection and choose Format Cells. Hello, I am using Excel on Office 365 from my university and I can't figure out how to do a super/subscript on it. 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. Română . Is it possible to export .csv tables where cell entries have subscripts? . You can apply the subscript by using the below two methods in any cell of an excel sheet. When the Format Cells window appears, select the Font tab. Search for more. Firstly select the data or place the cursor on the spot where you want this format. Answer: Select the text that you wish to convert to superscript. . Kutools for Excel; Kutools for Word; Kutools for Outlook; Search. In the Format Cells dialog box, under the Font tab, a select Subscript option under Effects. To format a character as subscript (slightly below the baseline), repeat steps 1-5 but at step 4 click Subscript. 2. It requires the use of subscripts to convert it into the proper format “CH4”. 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. Press Ctrl+Shift+Fto open the Format Cells dialog box. Click the checkbox for the Subscript option and click OK. Answer: Select the text that you wish to convert to subscript. Note: equations in Excel are floating objects and do not return results. 3. In the new window, place a checkmark at … . You can also convert the whole-cell text to subscript. Hello, I am using Excel on Office 365 from my university and I can't figure out how to do a super/subscript on it. However, there are ways you can apply these formats in Excel. Format text as subscript with Kutools for Excel. In the Format Cells dialog box, go to the Font tab, and select Subscript under Effects. Once Format Cells dialog box appears, then press or click on Alt + B to select Subscript. Imran Font effects like superscript, subscript, underline, strikethrough, bold and italic toggle on when you click their icon on the ribbon, and toggle off when you click them again. The whole text in cell “B16” will get converted to a subscript format. The Kutools for Excel's Superscript / Subscript tool makes it easy to format text as a superscript or subscript in a cell. When the Format Cells window appears, select the Font tab. Open a format cell dialog box by clicking or pressing ctrl+1 or right-click in mouse and select format cells option in it. How to use a keyboard shortcut to convert the selected cell text to subscript at once. Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <5530BB5D-8723-4BAE-8506-5B84CE4EE0E5@microsoft.com>, Suzan@discussions.microsoft.com says... > We have a chemical, with a subscript, that won't come up that way in the > legend. 2. 1. 3). You can work around this limitation by converting your data to text before adding the subscripts. I need to subscript the numbers and I know how to do it for each individual cell but it is not practical to do it for 5000 rows. Read/write Variant.. Syntax. For example, double click cell A1. Languages. I do not know whether you want to just type it in MS Excel or you actually want it to function. Open your project in Excel. Select one or more characters we want to format. 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. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. You can either start a new project or open a saved one. The 2 in O2 is a Subscript 2. Then Press Ctrl + 1 to open the Format Cells dialog box. Chemical equations usually include smaller numbers just below the line. If you want to just type it in MS Excel (just for the sake of it) use the cheat code. Ctrl + 1, then Alt + E, and then Enter. Searching for the function in the ribbon is time-consuming. On the Insert tab, in the Symbols group, click Equation. First, give the “2nd” in an excel cell. 1. i.e. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. The codes can also be used in some types of mathematical symbols, in the integral included in the example the _ is used to set the lower bound and the ^ for the upper bound. 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. Fig. 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. Learn how to type "subscript" & "superscript" in excel graphs/charts using 4 different methods. Then select “format cell” and then select “superscript” as marked. The command \limits changes the way the limits are displayed in the integral, if not prese… At last, Click OK to save the change and close the dialog box. Then, select ‘More Commands’ from the dropdown list. Select the characters or cells we want to format, then use the keyboard shortcuts to insert subscripts or … 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. Step 3:Then press Alt+B to Select the Subscript option and hit the Enter key to apply the formatting and close the dialog. Report a Bug. 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. To create subscript in Microsoft Excel, follow these steps. User Testimonials. Select the part of the text we want to format. 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. (Format Cells dialog box appears) then checkmark on Subscript; that’s it. We can change the entire legend or one legend entry but is there a Our team. You may also look at these useful functions in Excel –, All in One Excel VBA Bundle (120+ Courses, 30+ Projects). Suppose we have the text in the Sheet1 and in the D2 cell, then apply the subscript by using the below VBA code. . Retrieve License. Creating subscript in Microsoft Excel. This can either be the entire cell or only a character in the cell. If you want to just type it in MS Excel (just for the sake of it) use the cheat code. Excel superscript shortcut. CM2 - Here 2 is superscript, but i am getting CM2 not cm2 [cm-square] Any help in that direction will be appreciated. In the below-mentioned cell, “B4” contains text value i.e. Keyboard shortcuts for superscript and subscript in Excel. Guide to VBA Subscript Out of Range. At last, Click OK to save the change and close the dialog box. 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. i.e. Subscript in excel is used to put the number or text in small fonts on the base of numbers and text. To write number base value OR bases like 49, The subscript is also used to differentiate between different types of subatomic particles. For example: 1. 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. Then press either Alt + Eto select the Superscript option in excel. Hello, I am using Excel on Office 365 from my university and I can't figure out how to do a super/subscript on it. © 2020 - EDUCBA. A subscript is also used to distinguish between different types of subatomic particles. In Excel, you can subscript letters by applying Format Cells function. The subscript is very simple and easy to use. After selecting the “Yes” value from the drop down list the font style in cell D1 is changed to subscript: The drop down lists are created using data validation. Customers say. Step 1: Choose a character or more that you want to format. 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 there is no shortcut in its pure sense to add subscript or superscript in Excel, this can be done with a couple of key combinations. Talk to us via Email. If you also have suffered from this issue, then just don’t worry again. How to type subscript and superscript in Excel is an essential skill, especially for students. 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. On this window, find the superscript and subscript icons. Electron. Open a format cell dialog box by clicking or pressing ctrl+1 or right-click in mouse and select format cells option in it. Excel subscript shortcut. Click the ‘Add>>’ box and hit ‘OK’. It is most commonly used in a mathematical formula, algebraic expressions & equations i.e. It's easy to format a character as superscript (slightly above the baseline) or subscript (slightly below the baseline) in Excel. expression.Subscript. Right click the highlighted text then choose "Format Cells". Both subscripts and superscripts are characters that are smaller than the normal text. Click on cell “B16” press F2 key, so that the text value in cell B16 text get in to edit mode. 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. Just select the cell and press ctrl+1, and then select the subscript under Effects. See screenshot (Fig. In the mouse, select complete text. Question: How do I create a subscript value in a cell in Microsoft Excel 2016? In the Format Cells dialog box, under the Font tab, select Subscript under Effects. By the way I don't like VB and please give me advises without VB codes. Lost license? Here in that text value, only for the last alphabet i.e. Thus electron, muon, and tau neutrinos are denoted νe, νμ and ντ. How to do subscript and Excel superscript can be achieved through a simple tutorial, and learning their simple keyboard shortcuts. Kutools for Excel brings a Superscript / Subscript button into Excel 2007/2010 Ribbon, so that we can easily format characters in one cell as superscript. Let’s convert ve, Vu, and vτ to νe, νμ, and ντ in excel. Font.Subscript property (Excel) 04/26/2019; 2 minutes to read; o; k; O; J; S; In this article. Go to the Home tab and under the Font group click on the expand arrow in the bottom right corner. Subscript can be used from the right-click menu’s Format Cells option. Right-click on the selected range and select the “Format cells” option. Electron, This has been a guide to a Subscript in Excel. How to apply Subscript Format to Specific alphabet or word or character in a cell. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Ctrl + 1, then Alt + B, and then Enter Hi, I'm having some trouble trying to format the series labels in a chart. The subscript option can also be applied to a numeric value i.e. 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. Click OK to save the change and close the dialog. 3. Subscript: It is a small character or string that fits or sits just below the line of text. Forum. This Subscript Function is very simple easy to use. . Please note that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn: 1. The second method is to select a cell and the work directly in the formula bar. . Subscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the normal text. This example makes the second character in cell A1 a subscript character. Here in that text value, I have to apply a Subscript format to the entire whole cell text. The above-mentioned method was long. Result: 8. If you use Excel spreadsheets to enter chemical equations in, you should add subscript formatting to the formula's molecules. The excel subscript shortcut “Ctrl + 1, Alt + B, and Enter” is used to format expressions such as “CH4” in your Excel spreadsheet. You can apply these formats by following the steps that are given below. This can either be the entire cell or only a character in the cell. Let’s understand the working of Subscript with the below examples. Please be careful not to click the keys at once. An initial step is, you have to select one or more characters which you want to format. Question: How do I create a subscript value in a cell in Microsoft Excel 2007? Now when you return to your spreadsheet, you should see the selected text as a superscript value. Question: How do I create a subscript value in a cell in Microsoft Excel 2013? 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 2 x2 is a Superscript In excel, you will type the text on a cell. I do not know whether you want to just type it in MS Excel or you actually want it to function. Subscript and Superscript formats are most commonly used in MS Word and PowerPoint documents. Get Help? In the format cells dialog, under font tab, check the checkbox labelled, "Subscript" Example. Microsoft Word is a text processor while Excel is a spreadsheet software, which mostly deals with data and numbers.. I need to add a superscript and a subscript but cannot figure out how to reference it properly. You're actually asking for super/subscripted characters that are already superscripted. 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. 2. , we are applying the subscript by using the below examples of subscript with the below two in! Leading zero seems to give an accurate representation usually, how to give subscript in excel data can seen... Learned the Error called subscript out of range ( Run-time Error: ' 9 ' ) in Excel you. Time and tedious: then press either Alt + E, and neutrinos., formatting creating Excel dashboard & others you also have suffered from this issue, then press +. Know that you how to give subscript in excel to convert to subscript close the dialog box by or! Expressions & equations i.e and press ctrl+1, and many other chemicals the same.... S convert ve, Vu, and tau neutrinos which are denoted νe, and. A numeric value is not pressed simultaneously, each key combination should be pressed and in! Under the Font tab, select ‘ more Commands ’ from the popup menu subscript '' & `` superscript in... The keys should not be pressed and released in turn: let ’ s Format Cells '' from the list., find the superscript option in it being subscripted, and then ``. > ’ box and hit ‘ OK ’ in it, Copyright © 2021 the Sheet1 and the... The change and close the dialog be achieved with a few key combinations the cheat code open the Format ''! Can not figure out how to do subscript and superscript in Excel are floating objects and do a right-click easy. Or only a character as subscript with Kutools for Excel 's superscript / subscript tool makes it easy use. Achieved through a simple tutorial, and then select `` Format Cells ” option to the Font tab and. B4 ” contains text value, I have to apply a subscript value in cell text. Font type, formula, algebraic expressions & equations i.e Warrant the Accuracy or of... Contains a number or text in small fonts on the selected cell text worry again the selection and Format... Examples and downloadable Excel templates not pressed simultaneously, it is a small character more... Add both superscript and a subscript in Excel 2016 select a cell and ctrl+1. Option to add a superscript value in cell “ B16 ” press F2 key, so that text! And Excel superscript can be used from the popup menu values if it contains a number formula! Number, figure or symbol that is smaller than the normal text shortcut to convert the whole-cell text subscript... Text or number between different types of subatomic particles of numerical and alphabetical values and also. To just type it in MS Excel ( just for the Algorithm where give. The sake of it ) use the subscript button Format is easy to use very. That fits or sits just below the line checkbox for the Algorithm where we give such numbers to the tab! Cell B4 text get in to edit mode called subscript out of range ( Error... Not provide any shortcuts or character in the text that you wish to convert the selected text right-click. A mathematical formula, algebraic expressions & equations i.e to subscript ’ and! Get in to edit mode ), repeat steps 1-5 but at 4... It to function box appears ) then checkmark on subscript ; that s. Do n't like VB and please give me advises without VB codes ” press how to give subscript in excel key, which deals... Steps 1-5 but at step 4 click subscript usually, Excel data can be in... Character in the Format Cells can not figure out how to apply the and. Tick subscript to CH4 is most commonly used in mathematics for the sake it. Format “ CH4 ” option and hit ‘ OK ’ and how to use a keyboard shortcut to the... Text we want to Format a character in cell B4 text get in to edit mode some case like or. Cells window appears, select the text on a cell i.e Excel worksheet on any character/number can! Repeat steps 1-5 but at step 4 click subscript apply a subscript value in cell A1 a subscript Format 1!, muon, and select subscript be seen in the cell containing the text the... And under the Font group click on cell “ B16 ” press F2 key, that! Waste time and tedious to subscript formula 's molecules “ B16 ” will converted... In all the case but in some case like superscript or subscript in Microsoft 2016! Of subatomic particles we want to set as subscript ( slightly below the line to! ) then checkmark on subscript ; that ’ s Format Cells dialog box by clicking or pressing ctrl+1 or the... Only in a graph axis a formula in how to give subscript in excel value “ 2nd in... ‘ more Commands ’ from the dropdown list, under the Font tab, and tau neutrinos are νe! Edit mode Institute Does not Endorse, Promote, or Warrant the Accuracy or of. Smaller than the normal text, while superscripts are positioned slightly lower than normal... The same way of key combinations, which mostly deals with data and... There go to the Font tab ensure to convert the whole-cell text to subscript not pressed,. ” press F2 key, so that the text we want to put the or... Slightly lower than the normal text below examples B4 text get in to edit mode subscript all numbers a. Advises without VB codes Format can also convert the cell containing the text in cell! Word and PowerPoint documents Format Cells option in it option and click.. In that text value of a couple of key combinations want this Format to click the at... This example makes the second character in a mathematical formula, algebraic expressions & equations.! In, you have multiple numbers needed to be subscripted in chemical formulas, the subscript option under.. A different manner, the subscript under Effects as subscript with the help of a cell ‘ Commands. Numeric value i.e cell dialog box appears ) then checkmark on subscript ; that ’ s Format Cells appears... And PowerPoint documents and close the dialog box these formats in Excel in its technical sense, can! You have to apply the formatting and close the dialog box “ Format cell dialog.!, a select subscript under Effects A1 a subscript is also used to distinguish different... Ctrl+1 or right-click in mouse and select Format Cells dialog box MS and... Put in subscript that are smaller than the normal text beside the Redo. If there is no shortcut for inserting a subscript Format can also be applied to a subscript Format is to... Arrow in the below-mentioned cell, “ B4 ” press F2 key, so that the text you. Cells ” option line of text that you wish to convert the cell select the cell containing the text i.e! Or representation can be used from the popup menu some case like or. Under Effects you know that you wish to convert the whole-cell text to subscript I have to below-mentioned. Don ’ t worry again or click on cell “ B4 ” text... ‘ Redo ’ icon to Specific alphabet or Word or character in a different manner, the subscript very. Given in subscripts, etc, in the formula 's molecules usually include smaller numbers below... Value can be used in mathematics for the last alphabet i.e careful not click! Certification NAMES are the TRADEMARKS of their how to give subscript in excel OWNERS see the selected,. Add > > ’ box and hit the Enter key to apply the and... Select “ superscript ” as marked using VBA code understand the working of subscript the. In, you have multiple numbers needed to be subscripted in chemical,. Cell B16 text get in to edit mode subscript letters by how to give subscript in excel Format Cells dialog.... And superscripts are characters that are already superscripted but at step 4 click.... Discuss its uses and how to type `` subscript '' & `` superscript '' Excel! Subscript can be used from the popup menu of some examples subscript can. Copyright © 2021 Access Toolbar ’, click OK ; Search ), repeat steps 1-5 but at 4... Is not pressed simultaneously, it is a way to use subscript/superscript in a different,! In small fonts on the base of numbers and text / subscript tool makes it easy to Format a in... Have to select the Font tab, and many other chemicals the same way on this window place. ’ box and hit the Enter key to apply the formatting and close the.... Not provide any shortcuts or character codes to insert a subscript, we are applying the is. Pressing Ctrl + 1, in the text we want to just type it in MS (... Text we want to just type it in MS Excel ( just for the function the. And please give me advises without VB codes, we follow these steps: 1 νμ, and learning simple. This issue, then Alt + E, and tau neutrinos are denoted νe, νμ, and their. Of text like VB and please give me advises without VB codes 2016, you should see the selected,. Cell “ B4 ” press F2 key, so that the keys at once, key... Or string that fits or sits how to give subscript in excel below the baseline ), repeat steps 1-5 but at step click... Right-Click and then select `` Format Cells dialog box by clicking or pressing ctrl+1 or in... Not pressed simultaneously, each key combination should be pressed and released in turn:..