![]() We also looked at the keyboard shortcut used to add subscripts with an example. Here, we learn how to do subscripts in Excel. This article has been a guide to Subscript in Excel. We can work around this limitation by converting the data to text before adding the subscripts. (“Format Cells” dialog box appears) then checkmark on “Subscript.” That’s it.Īdding subscripts to Excel is usually a simple matter of a font setting, but you may run into limitations when adding subscripts to cells containing numbers or Excel formulas. Select the “4” from the formula bar, right-click, and click on “Format Cells.” This time we are using the second method. ![]() In this example, we are applying the subscript to CH4. Step 2: You can reverse or remove the subscript formatting by selecting the cell, accessing “Format Cells,” and clearing the appropriate checkbox.Then, use “Format Cells” to apply subscripts as you like. Step 1: As before, carefully select the text you want to format.The second method is to select a cell and the work directly in the formula bar. Step 5: Then, it will convert the H2O to H 2O.Step 4: On the “Font” tab, under the “Effect” checkmark on “Subscript,” then click on “OK.”.Step 3: The “Format Cells” dialog box appears.Step 2: Then right-click, and select “Format Cells.”.Step 1: Double click on cell A2 and select the value “2.”.You can apply the subscript by using the below two methods in any cell of an Excel sheet. You can download this Subscripts Excel Template here – Subscripts Excel Template Example #1 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |