Adding subscripts to Excel can be quite a simple matter of a font setting, but you might come across limitations when adding subscripts to cells containing numbers or formulas. You can work surrounding this limitation by converting important input data to text before adding the subscripts. There is no subscript button for you really to quickly format text as a subscript in Excel as you can easily format a letter as a subscript in MS Word with the subscript button. And it may be a little hard to format text as a Subscript in Excel 2010.
The subscript is the same but with letters attached to the bottom. Like with chemical formulas: co2, H2, or when mentioning number bases (octal, decimal, etc.) in mathematics. In this short article, I’ll tell you to format text as subscripts or superscript in Microsoft Excel easily.
Formatting the text as Subscript goes the following:
- On a new spreadsheet, write the text as usual, with regular sized letters, and press Enter. In the following example, I used the writing as “co2”.
2. Now double click inside that cell, and carefully choose the characters to become superscript. In the example I have selected the “2” character in the input text co2. And Right click as part of your selection, and choose “Format cells…”
3. Further, you can see the Format Cells window. Check the “Subscript” box and click OK.
4. Finally click outside the cell, and you’re done! The character “2” of the co2 appears to the bottom. Check out the screenshot below.
To Find out Subscript option in the Format Cells dialog box using short cut keys, go through the following easy steps:
At first, Select characters in a cell carefully to become subscript as in the last example to make. And then open the Format Cells dialogue box with holding down Ctrl + Shift + F keys. And follow the step 3 and step 4 of the previous method.
Superscript in Excel
Likewise, Superscript is if you are using small letters or numbers which can be mounted on the top of regular sized letters. As an example, when writing Rank numbers, such as 1st, 2nd, 3rd etc., or when you mention powers or numbers in mathematics. Here I’ve illustrated an illustration for superscript in the screenshot.
read more about sum function in excel at https://sgrdimsr.org/excel-sum-function/