Hiding the formulas on an Excel worksheet is just like protective your Excel sheets with a password, or being selective approximately which cells, rows or columns you defend, however with a twist, you aren't hiding the cells, just the formulation. Multiply in excel formula Once you already know a way to do it, it honestly is easy and a feature I know you may use again and again once more.

The first component you want to do is unencumber all of the cells you in reality want to cover. Seems ironic however, you need to do this in Excel to then permit the cells to be hidden. By default all cells in an Excel worksheet are actually locked inside the first example. So to liberate you cells-

1. Select all your worksheet

2. Home Tab

three. Format alternative on the cells organization

four. Click on Lock Cell option 2nd bottom of the listing of options

The Lock Cells certainly works like an on/off button and as you could see they're first of all through default are locked. You will want to liberate them within the first example which will use this method. If you're unsure if they're locked or now not you then need to move right to the bottom list and select format cells from the menu and click on at the safety tab wherein you can see if the locked box is ticked or now not. Ticked is locked, and un ticked isn't locked. Easy as that!

Well carried out you have correctly finished Stage 1 of this manner.

Let's circulate onto Stage 2.

1. Highlight the cells that include the formulation you need to hide.

2. Home Tab

3. Format alternative at the cells organization

4. Protection tab

five. Tick Hidden choice

6. Hit adequate.

You will nonetheless at this factor see your formulas, as there as one final degree to this- shielding the worksheet.

Let's move onto Stage three.

1. Home Tab

2. Format option of the cells group

three. Scroll all the way down to safety

4. Protect Sheet

five. Enter a password

6. Hit OK

7. Re - enter your password when induced

Your formulas should now be hidden faraway from prying eyes. Well accomplished, all of that hard paintings you put into to your formulation is now included.

You remain the Excel guru of your office over again! Go beforehand and give this a pass, you will be using it on a ordinary basis - I did after I observed this Top Excel Tip.