![]() ![]() Unfortunately, Google Sheets doesn’t provide a built-in solution for formatting subscripts and superscripts (but there is an over-complicated workaround solution using ASCII code we won’t go into here). The symbols produced by the HTML codes in the first column are displaying in your browser in whichever font your system finds first in the following list: Helvetica Neue, Arial, Tahoma. For other number codes, see Code Charts for Math & Currency. In the Format Cells window, check Superscript and click OK.įinally, the 2 is now superscript, and the square meter symbol is appropriately displayed. This code chart displays ALT codes and HTML entities for fractions, superscripts, and subscripts. Select just the number 2 in cell B2 and right-click. Say you have “156 m2” in B2 and want to display the 2 as superscript (so “m2” reads as “square meters”).ġ. You can also make a part of the text subscript or superscript. ![]() To apply the subscript or superscript format to just some of the characters in a cell, keep reading. In the Format Cells window, check Subscript and click OK.Īs a result, all text in cell B2 is now formatted as a subscript. Select cell (e.g., B2) and right-click it, then choose Format Cells.Ģ. Now when you return to your spreadsheet, you should see the selected text as a superscript. 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. To make the text in a cell subscript, follow these steps:ġ. MS Excel 2016: Create a superscript value in a cell. In this tutorial, you will learn how to make subscripts and superscripts with text formatting in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |