More Information on How to Make a Text Box in Excel 2010 We guarantee a connection within 30 seconds and a customized solution within 20 minutes.For example, you can remove the border from your text box if you wish to do so. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Output: Insert superscript to a numeric value Instant Connection to an Excel Expert We have now inserted a numeric value with superscript through the Equations feature of Excel.įigure 10. Enter 9 in the first box, and 2 in the second box. We want to enter the square of 9 as “ 9 2 ”. Click the Script button and select Superscript. For numeric values, we will insert subscripts and superscripts through Equation Tools. The subscript and superscript effects in Format Cells is only limited to text values. How to insert subscript and superscript in numeric values? Select the characters or cells we want to format, then use the keyboard shortcuts to insert subscripts or superscripts. Output: How to insert superscript Subscript and superscript shortcut sīelow are the keyboard shortcuts for subscript s and superscripts:Įxcel subscript shortcut: Ctrl + 1, then Alt + EĮxcel superscript shortcut: Ctrl + 1, then Alt + B Superscript Effect in Format CellsĪs a result, the number “3” is entered as a superscript. Selecting the characters to format as superscriptįigure 5. In this case, we want to insert “3” as a superscript.įigure 4. Select the part of the text we want to format. The procedure is the same as in the above example, but this time we tick the Superscript box under Effects. Output: How to insert a subscript How to insert superscript in text values? Subscript Effect in Format CellsĪs a result, the number “2” is entered as a subscript.įigure 3. Press Ctrl + 1 to open the Format Cells dialog boxįigure 2. Selecting the characters to format as subscript In this case, we want to insert “2” as a subscript.įigure 1. In order to insert a subscript, we follow these steps: 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. Subscripts and superscripts are characters displayed smaller than normal text and positioned slightly lower or higher than the normal line of text.Įxample of subscript: the “2” in hydrogen sulfide “ H 2 S ”Įxample of superscript: the “3” in cubic meter “ m 3 ” How to insert subscript in text values? How to Insert Subscript and Superscript in Excel – Excelchat
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |