-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hide formulas in cells
- Thread starter john5599
- Start date
pboltonchina
Well-known Member
- Joined
- Apr 24, 2008
- Messages
- 1,104
You can set this in the Options menu
Upvote
0
Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,907
- Office Version
- 365
- Platform
- Windows
Hello
Select the cells with the formula
Go to the Protection tab in Format Cells (CONTROL+1).
Check 'Hidden' > Ok
The formula will be hidden when you protect the sheet, so make sure you also unlock the relevant cells / ranges in the Format Cells (Protection tab) dialog.
Precise instructiuons for protecting the worksheet will depend on your excel version.
Select the cells with the formula
Go to the Protection tab in Format Cells (CONTROL+1).
Check 'Hidden' > Ok
The formula will be hidden when you protect the sheet, so make sure you also unlock the relevant cells / ranges in the Format Cells (Protection tab) dialog.
Precise instructiuons for protecting the worksheet will depend on your excel version.
Upvote
0
