


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
