Some basic tips on formulas in an Excel sheet
We assume that tu has mastered the basics of this tool; how to manage columns, rows or how to style or format a table or cell in Excel. It all depends on the type of information you are about to manage.
If you don't know how to create formulas in Excel, it is convenient to learn step by step how to insert formulas into text boxes in Excel. Here we will give you some basic tips; It is necessary to deepen, calculate percentages, averages and any other mathematical or statistical formula. Then we will tell you how to perform calculations of elementary functions:
Every formula you make must put a "=" on it, then apply the operation of addition, subtraction, multiplication, division or other mathematical and statistical formulas.
- At the end of the function of each formula you have to press the key Submit, so that it shows you the result.
- When adding, use the expression SUM, then put the range of cells to add in brackets, it can be two or more. You can also add in the same cell using the digits, they must be after the = and the + sign between them. There are also ways to automatically sum a column or multiple cells in Excel.
- When subtracting, use the symbol - between the value of one cell and another.
- When dividing, use the symbol / between the value of one cell and another.
- When multiply, you should know that the sign to use is *, between one cell and another.
How can you hide and show a formula in an Excel sheet
First of all, you need to master the elementary aspects of how formulas are made in Excel and learning to format the numbers or digits required to handle, and if you already master the formulas themselves, it will be easier for you.
So assuming this, after applying the formulas for certain reports, databases, invoices or other formats, we will see very simply how you can hide and show a formula in an Excel sheet:
Steps to hide formulas
- Press the F5 key.
- Then a dialog box will appear, click the button Analysis.
- There select cells with formulas and click OK.
- Now right click and a box will appear, there you go to Formato that.
- On the Protect tab, click Hide and then OK.
Steps to view formulas
- Hover your mouse over a particular cell, you will notice that the applied formula and its values can be automatically displayed in the function bar, which you can find at the top of the Excel sheet.
- If the formulas are hidden, hover the mouse on the sheet label and right click on it.
- Then click Remove sheet protection, then click OK.
Another method of hiding formulas
- Right click on each of the formula cells you want to hide and click Formato that.
- Go to the tab Protect, then select the Hidden option.
- Finally, select OK.
Protect changes made when hiding or showing formulas in Excel:
- Right-click on the sheet label and click the Protect Sheet option.
- Now select Protect sheet and contents of locked cells.
- Give it a password and click OK.
- Finally, confirm the password and click OK again.
Check the changes made when you hide or show formulas in Excel
- Go to the tab revision.
- Now click on the option Protect or Unprotect Sheet.
- A box will appear there put simply the password you inserted to protect the sheet.
With this article on how to hide and show a formula in an excel sheet, you can protect your data and the information you need in different situations. And remember that it is only with constant practice that you will consolidate your knowledge.
TagsEccellere
