![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |