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!
You should read it
- Guidelines for importing Chemistry formulas in Excel
- How to hide formulas in Excel
- How to enter formulas in Excel
- How to create an Excel formula in Notepad ++
- Instructions on how to copy formulas in Excel
- How to type chemical formulas in Word
- MS Excel - Lesson 5: Excel formulas and functions
- Instructions for hiding formulas in Excel
- What is ### error in Excel? how to fix ### error in Excel
- Instructions and examples of array formulas Array Formulas in Excel
- How to display formulas and print formulas in Excel
- A complete guide to Excel 2016 (Part 14): Create complex formulas