how to lock certain cells in excel formulas

HOW TO LOCK CERTAIN CELLS IN EXCEL FORMULAS HOW TO

In the Protection dialog box, enter the password that would be needed if you want to unlock the worksheet (in case you don’t want to apply a password, you can leave this blank).In the Protect group, click on the Protect Sheet option.In the ‘Format Cells’ dialog box that opens up, click the ‘Protection’ tab.In the ‘Number’ group, click on the dialog box launcher (it’s the small tilted arrow icon at the bottom right of the group).Select the cells in column D that have the formula that you want to hide.Suppose you have a data set as shown below where you have the formula in column D.īelow are the steps to hide all the formulas in column D: When you hide the formulas (as we’ll soon see how), the users won’t be able to edit the cell as well as not be able to see the formula in the formula bar. By selecting the cell and seeing the formula in the formula bar.

By double-clicking on the cells and getting into the edit mode.

When you have a formula in a cell, a user can see the formula in two ways:

HOW TO LOCK CERTAIN CELLS IN EXCEL FORMULAS HOW TO

How to Hide Formulas Without Protecting the Worksheet.Step 2 – Enable the Locked and Hidden Property only for Cells with Formulas.Step 1 – Disable the Lock Property for all the Cells.How to Only Hide Formulas in Excel (And Keep Rest of the Cells Editable).

How to lock certain cells in excel formulas