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 .
Step 2:
The Format Cell dialog window appears. Here we select Subcript and select OK .
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.
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.
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.
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:
- You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
- 10 ways to recover corrupted Excel files
- MS Excel - Lesson 4: Working with lines, columns, sheets
I wish you all success!
You should read it
- How to hide formulas in Excel
- How to color formula cells in Excel automatically
- How to enter formulas in Excel
- How to enter formula data in Excel
- How to delete quick recipe on Excel
- Instructions on how to copy formulas in Excel
- 5 useful Microsoft Excel formulas for calculating taxes
- How to lock formulas in Excel
May be interested
- A complete guide to Excel 2016 (Part 14): Create complex formulasafter 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 Excelwhen 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 Wordsimple 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 Excelthe 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 Excelwhen 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. 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 formulasafter 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 Excelin 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 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:
- How to insert math formulas in Excelin the learning process, you often use ms excel to calculate and process data. because of some requirements that you need to insert mathematical formulas into excel, but you do not know how to manipulate.