HomeMicrosoft OfficeMicrosoft ExcelExcel: How to Hide Formulas from Other Users

Excel: How to Hide Formulas from Other Users

To prevent other users from seeing or modifying your formulas, format the relevant cells as hidden, and then protect the worksheet or worksheets. Use the following tech-recipe to accomplish this.


1. Select the cell or range of cells that contain the formulas.
2. Choose FormatCells to display the Format Cells dialog box. (Alternatively, use Ctrl+1 on the keyboard.)
3. Select the Hidden and Locked check boxes on the Protection tab.
4. Click OK.
5. Choose ToolsProtectionProtect Sheet to display the Protect Sheet dialog box.
6. Make sure that the Protect Worksheet and Contents of Locked Cells check box is selected.
7. Type the password for protecting the worksheet in the Password to Unprotect Sheet text box.
8. Click OK. Excel will display the Confirm Password dialog box.
9. Type the password again, and then click OK.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android