![]() (“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 |