Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Hide and Protect the Formulas You Used in Excel

Date:2019-12-28 Author:Cordelia

As the work requires, you may send your Excel spreadsheet to other people at times. It means they can not only view the data, but also click any cell to check the formula it contains, or even modify it without your permission. To keep that from happening, you can try these steps to hide and protect the formulas you used in an Excel sheet.

How to Hide and Protect the Formulas You Used in Excel

1. Press [Ctrl+A] to select the whole sheet, then press [Ctrl+1] to open Format Cells.

You can also right-click the selected area and choose Format Cells in the menu.

How to Hide and Protect the Formulas You Used in Excel

2. Then switch to Protection tab, and uncheck Locked option, which is normally checked by default. Hit OK to confirm it.

How to Hide and Protect the Formulas You Used in Excel

3. Press [F5] to open Go To. Click Special… button at the bottom-left corner.

How to Hide and Protect the Formulas You Used in Excel

4. Check Formulas to activate the grey area, then click OK to implement it.

How to Hide and Protect the Formulas You Used in Excel

5. Press [Ctrl+1] to open Format Cells again, check both Locked and Hidden in Protection tab. Hit OK button.

How to Hide and Protect the Formulas You Used in Excel

6. Switch to Review tab of Excel, click Protect Sheet on the right side.

How to Hide and Protect the Formulas You Used in Excel

7. Enter the password as you like in the textbox. Click OK and re-enter the password to confirm it.

How to Hide and Protect the Formulas You Used in Excel

8. Now check your sheet, even if you click the cell, the formula you used won’t show any more. You also can’t modify the content in the cell which contains a formula. Thus you can send the spreadsheet to others with safety.

How to Hide and Protect the Formulas You Used in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *