Forum Discussion
Hide formulas without protecting Sheet
Hi Guys, I need to hide my formulas but without protecting the sheet. Can you pls help on this!!!
3 Replies
- I think the question is why you say 'without protecting the sheet'. My guess is because you need them to be able to enter information in other parts of the sheet so you need to select the regions/cells that you want the users to be able to edit, goto 'Format Cells', select the 'Protection' tab and UNselect 'Locked'. Then when you protect the sheet those cells will not be locked and others can still edit them.
As far as I know, that is not possible.
- Depending on your need, you may protect the sheet without setting a password. I use it quite often to guide users to enter only into of me selected input cells but they still have the possibility to unlock the sheet and change everything.
