Buzz
In the previous Excel lesson, you learned how to write fraction formulas in Excel to write fraction functions in Excel spreadsheets. Fraction formulas are often complex, so if you don't understand them well, you'll find it difficult to understand fractions in Excel.
Inserting chemical formulas in Excel is similar to inserting mathematical formulas in Excel. If you already know how to insert mathematical formulas in Excel, then with the content below, Mytour will guide you how to insert chemical formulas in Excel applicable to all Excel versions 2010, 2013, 2007.
Enter chemical formulas in Excel spreadsheet
Suppose you want to input chemical formulas as shown in the image below
Here's how to do it:
Step 1: For example, you input the formula H2SO4, first you type 'H', then right-click and select Format Cell.
Step 2: A dialog box appears, you check Subscript, click OK, and type the number 2. You will get the result as shown in the image below.
Step 3: To return to normal text after typing the subscript for the following letters “SO”, you continue right-clicking and select Format Cell, uncheck Subscript, then press OK. You will get the result as shown in the image below.
You will get the result as shown in the image below.
Step 4: To type the remaining subscript, repeat the steps you have performed. You will get the chemical formula result as shown in the image below.
Now you've learned how to input chemical formulas into Excel spreadsheets with Excel 2010, 2013, or Excel 2007. To input chemical formulas in Word, you can refer to the article write superscript in Word to help you type superscripts and subscripts for some in Excel spreadsheets.
