HomeApplicationOffice information

Guidelines for importing Chemistry formulas in Excel

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 1

Step 2:

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

Guidelines 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 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 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 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
ExcelExcel tipsExcel functionsExcel formulas

You should read it

May be interested

  • How to Copy Formulas in ExcelHow to Copy Formulas in Excel
    the excel program has a feature that makes it easy for users to copy formulas for entire rows or columns, but you don't always get the results you want. when you receive results that are not as expected or encounter #ref and /div0 errors, you will definitely feel unhappy. don't worry, though - you don't need to edit every cell in a 5,000-line spreadsheet. this article will provide some simple ways to help you copy formulas to other cells.
  • A complete guide to Excel 2016 (Part 14): Create complex formulasA complete guide to Excel 2016 (Part 14): Create complex formulas
    after learning about the recipe in excel 2016, tipsmake.com continues to guide you how to create more complex formulas. invite you to consult!
  • How to lock formulas in ExcelHow to lock formulas in Excel
    when sharing an excel file, you don't want other people to edit the formulas, see the formulas, then lock the formulas again.
  • How to type chemical formulas in WordHow to type chemical formulas in Word
    simple text editing is extremely simple. however, in chemistry to type formulas, the reaction equation if you do not know it will be difficult to express it in word. the following article shares with you how to type chemical formulas in w
  • Instructions and examples of array formulas Array Formulas in ExcelInstructions and examples of array formulas Array Formulas in Excel
    the following article details array formulas and practical examples in excel to help you better understand and apply them in your work most effectively.
  • Lock cells with formulas in Excel - Lock and protect cells containing formulas in ExcelLock cells with formulas in Excel - Lock and protect cells containing formulas in Excel
    when sharing excel files with others, you don't want to be edited by other formulas. the following article will help you know how to lock formulas in excel.
  • Instructions for hiding formulas in ExcelInstructions for hiding formulas in Excel
    instructions for hiding formulas in excel. you do not want anyone to know the calculation formulas in excel spreadsheets, you simply want others to manipulate the results do not want them to know the details of how to calculate the results.
  • Complete guide to Excel 2016 (Part 13): Introduction to formulasComplete guide to Excel 2016 (Part 13): Introduction to formulas
    after learning about the page format and spreadsheet printing, please join tipsmake.com to learn about the introduction article in excel 2016!
  • How to fix formulas in Excel, fix data ranges in ExcelHow to fix formulas in Excel, fix data ranges in Excel
    in excel when using a formula that refers to a range of data if you use the relative address of the formula and the range will change as you move to another cell. in this article, you can help fix formulas or ranges of data referenced in excel.
  • PI (PI Function) in Excel - How to use PI numbers in ExcelPI (PI Function) in Excel - How to use PI numbers in Excel
    pi (pi function) in excel - how to use pi numbers in excel. pi number is a mathematical constant with an approximate value of 3,1415926535897 ... we can find pi numbers in many trigonometric and geometric formulas. especially the formulas related to circles, ellipses, and spheres:

Office information