This prevents a typographical error in the password from locking up your spreadsheet forever.

In the Confirm Password dialog box, Excel asks you to retype the password you selected.

If you want your users to do any of these operations for unlocked cells, then check them here. S/he cannot format, delete, insert, or edit. If you select OK now, the user without the password can do nothing but click on cells, whether those cells are locked or unlocked. Notice that by default the Select locked cells and Select unlocked cells checkboxes are selected. No one (including yourself) will be able to unprotect the sheet to make changes without typing the password, so do not forget the password!

In the Protect Sheet dialog box, type a password.

On the Review ribbon, click Protect Sheet.

Important Step: Setting the cell format to hidden has no effect until you protect the sheet! Locked prevents the user from changing the contents of the cell. Note: Hidden is what prevents the user from seeing the formula.

In the Format Cells dialog box, click the Protection tab.

Right-click the cell (or cells) and choose Format Cells.Select the cells for which you to want to hide the formulas.The sheet is now unprotected.īy default, when you click on a cell, its formula appears in the formula bar. If the button is labeled Unprotect Sheet, then click it.If the button is labeled Protect Sheet, then do nothing.On the Review ribbon, find the button labeled either Protect Sheet or Unprotect Sheet.

Luckily, Excel makes it fairly simple to hide formulas. I don’t want them to know how other producers’ rates are calculated. On occasion I need to send the same spreadsheet to a list of competing vendors. Perhaps you need to hide Excel formulas from recipients and users for proprietary, security, or confidentiality reasons. If that’s not enough, you can select the Formulas ribbon and click Evaluate Formulas for a step-by-step walkthrough.īut what happens when you don’t want the formulas displayed? If you are working with a lot of complexity, it can get cluttered or confusing fast. When you click on the cell, the formula is displayed in the formula bar. By Christy Perry Categories: Formulas Tags: Excel Formulas, Hide FormulasĮxcel makes it easy to decipher why a formula produces its result.

Cara unprotect sheet excel