Guidelines for importing Chemistry formulas in Excel

Entering Chemistry formulas in Excel spreadsheets helps us to handle formulas more easily, especially for those who often have to work with Chemistry or with Math when they have the above index, the index below.

Microsoft Excel is currently the most popular spreadsheet processing tool, especially for those who often have to work in computational work. Therefore, Excel formula functions are important that every person working with Excel should remember. Besides, if you know more shortcuts in Excel, it will help our work become simpler.

In the process of using data entry on Excel, there will be quite a lot of operations that you are not sure and know how to use. Such as inserting Chemistry formulas with the above indicators for example. If you often have to work on Excel formulas without knowing how to do it, then follow the tutorial below of Network Administrator.

Step 1:

You open the Excel file in the computer. For example, you want to enter the formula H 2 SO 4 for example. So enter the H first, then right-click and choose Format Cell .

Guidelines for importing Chemistry formulas in Excel Picture 1Guidelines for importing Chemistry formulas in Excel Picture 1

Step 2:

The Format Cell dialog window appears. Here we select Subcript and select OK .

Guidelines for importing Chemistry formulas in Excel Picture 2Guidelines for importing Chemistry formulas in Excel Picture 2

Step 3:

Then we return to the data in Excel and type the index below 2 after the letter H. Immediately the result returned to you is H 2 as shown below.

Guidelines for importing Chemistry formulas in Excel Picture 3Guidelines for importing Chemistry formulas in Excel Picture 3

Step 4:

To return to normal typing mode . At the position of the mouse cursor next to the number 2, you also right-click and choose Format Cell. Then remove the check box in the Subscript box , click OK to return to the original state.

Guidelines for importing Chemistry formulas in Excel Picture 4Guidelines for importing Chemistry formulas in Excel Picture 4

In addition, if you accidentally write the letter S in the status of the lower indicator, you can highlight the letter S, then right-click and choose Format Cell and also leave the Subscript gone.

Finally, you enter the Chemistry formula for H 2 SO 4 in the above way to complete the data.

Guidelines for importing Chemistry formulas in Excel Picture 5Guidelines for importing Chemistry formulas in Excel Picture 5

So, you can already insert all Chemical formulas in the Excel spreadsheet. Hopefully with this writing, you will learn more necessary actions to handle content in your Excel.

Refer to the following articles:

  1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
  1. 10 ways to recover corrupted Excel files
  1. MS Excel - Lesson 4: Working with lines, columns, sheets

I wish you all success!

4.1 ★ | 7 Vote