#How to make a superscript on excel how to#
Here you can find instructions on how to subscribe a character. Or you can create a formula window and insert your characters there. There are two ways to do this: Either use the font settings to format cells. Subscript is a small character or string that sits below the line of text.To write formulas in Microsoft Excel, you often need to superscript numbers. Which is an example of a subscript in Excel?įor example, you can use superscript to write square units like m 2 or inch 2, ordinal numbers such as 1 st, 2 nd, or 3 rd, or exponents in math such as 2 3 or 5 2. 3 Under Effects, check the Superscript or Subscript box, and click OK. 2 On the Home tab, in the Font group, click the Font Settings dialog box launcher. How to format text values as superscript or subscript?įormat text values as superscript or subscript 1 Select characters in a cell or cell range that you’d like to format. Click and hold on the spot in the text where you want your subscript to begin. Click on the chart to select it, then click on the chart text you want to change. Open the Microsoft Excel 2010 spreadsheet that holds you graph. How do you add subscript to a graph in Excel? Click to check the box next to Superscript. Click the Font Settings dialog box launcher. Click the Home tab (if you aren’t already in that tab).
Select the characters you want to format. Is there a way to do superscript in Excel? Alternatively, you can type any number, and then press “xy” to add any number you want as an exponent. To type a cubed symbol, type a number and press the “x3” button. How do you type to the power of 3 on a phone keyboard? Now when you return to your spreadsheet, you should see the selected text as a superscript value. When the Format Cells window appears, select the Font tab. While your mouse is over the selected text, right-click and then select “Format Cells” from the popup menu. How do you superscript a graph in Excel on a Mac? To make characters into superscripts or subscripts, check the appropriate box in the lower left portion of the dialogue box. Right-click on the highlighted text and go to “Format axis title”. How do I superscript axis titles in Excel? For subscript, press Ctrl and the Minus sign (-) at the same time.
#How to make a superscript on excel plus#
To make text appear slightly above (superscript) or below (subscript) your regular text, you can use keyboard shortcuts. Drag the mouse to the right until you have highlighted all of the text you wish to make into a subscript.
How do you insert a superscript in a graph?Ĭlick on the chart to select it, then click on the chart text you want to change.
0 kommentar(er)
