Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. You can enter a password to prevent others from unprotecting the sheet.Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled.
The easiest and most common way of preventing people from playing with your formulas is to lock and protect cells which contain formulas in your worksheet. Check Formulas from Select option, and then click OK. All of the cells which contain formulas will be selected.5. Right click on the selected cells, and choose Format Cells from the context menu, and a Format Cells dialog box will display. And there is a dialog pops out to remind you that the fomulas cannot lock until protect the sheet. Now click Protect Sheet to type the password to protect the sheet. Now the formulas are locked and protected, and you can click Close Design to disable the Design tab.2.And a dialog box comes out and shows how many replacements have been made. See above screenshot: And the formulas in the range will be changed to text strings. Copy and paste the formulas to the location that you want of the current worksheet. Select the both changed ranges, and then reverse the step 2.Click Home Above method is to change the formula to text with replacing the = to #. Please copy them and paste into your destination range. And then you can restore the text strings to formula with selecting the text strings and clicking Kutools The formulas changes after copying as a result of relative references. In the opening Convert Formula References dialog box, please check the To absolute option and click the Ok button. Copy the formulas and paste into your destination range. I've created some clever formulas, and I don't want anyone else to see them.Is it possible to hide the formulas but display the results?