You’ll have to select the text one by one in each cell and repeat the above steps. Note: There is no way to apply this formatting to text in different cells at one go. This would make the selected part appear as a superscript. In the Format Cells dialog box, check the Superscript option.Right-click on the selected text and select Format Cells.Select the text to which you want to apply the superscript formatting.Select the cell and double click on it to get into the edit mode (or press F2 to get into the edit mode).Here is how you can apply the superscript format in Excel: When you want to enter the temperature along with the degree sign but in a superscript format. Superscript Format in ExcelĪ superscript format is needed when you want to have 1st, 2nd, 3rd with the alphabets in the superscript format.
In this tutorial, you’ll learn how to apply the superscript and subscript format in Excel. This is one of those things where you need to go a level deep to make it happen. If you want to apply superscript or subscript format to the text in a cell, you may not find anything for it in the ribbon. Subscript is a small character or string that sits below the line of text.Watch Video – How to Apply Superscript and Subscript Format in Excel 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.