Instructions on how to enter chemical formulas in Excel

The following article details how to enter chemical formulas in Excel.

For example: Enter the chemical formula of the strongest acids according to the following table:

Instructions on how to enter chemical formulas in Excel Picture 1

For example: Enter the chemical formula of Fluoroantimonic Acid: H2SFbF6 .

Method 1

Step 1: In cell enter typed formula H .

Instructions on how to enter chemical formulas in Excel Picture 2

Step 2: Right-click in the cell that is entering the formula and select Format Cells .

Instructions on how to enter chemical formulas in Excel Picture 3

Step 3: A dialog box appears and select the Subscript -> OK .

Instructions on how to enter chemical formulas in Excel Picture 4

Step 4: Go back to the cell that is entering the formula to type the number 2 -> which is indicated below.

Instructions on how to enter chemical formulas in Excel Picture 5

Step 5: To return to normal typing mode, right-click in the cell that is entering the formula, select Format Cells .

Instructions on how to enter chemical formulas in Excel Picture 6

Step 6: Dialog box appears unchecked in Subscript -> OK .

Instructions on how to enter chemical formulas in Excel Picture 7

Step 7: Return to the cell that is entering the formula to type other symbols.

Instructions on how to enter chemical formulas in Excel Picture 8

Step 8: Proceed as in step 3 and enter the index below 6 -> the result has entered the chemical formula of Fluoroantimonic Acid: H2SFbF6 .

Instructions on how to enter chemical formulas in Excel Picture 9

Method 2

Step 1: Enter all the characters in the formula including the index.

Instructions on how to enter chemical formulas in Excel Picture 10

Step 2: Highlight the characters under the index -> right click and choose Format Cells .

Instructions on how to enter chemical formulas in Excel Picture 11

Step 3: A dialog box appears and select the Subscript -> OK .

Instructions on how to enter chemical formulas in Excel Picture 12

The result has written the index below:

Instructions on how to enter chemical formulas in Excel Picture 13

Similar to other indicators:

Instructions on how to enter chemical formulas in Excel Picture 14

For the remaining acids, do the same thing -> the result:

Instructions on how to enter chemical formulas in Excel Picture 15

With the above two ways are basically the same, only different in the order of operations.

Good luck!