• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how did she do that?

Hi all--

Here is a strange one. We have a formula sheet that is protected and only allows users to enter data on a few cells. It would be convenient to use the Styles ==> Calculation feature for this but as the sheet is protected this option is not available. One of salesladies came in and did "something" to use this feature (usually it is greyed out and can not be selected) even though she does not have the password to unlock the sheet. Any thoughts on this? Thanks in advance
 
Perhaps hold Ctrl and hit "`" (the key usually found to the left of the 1). This will toggle formula audit mode on a spreadsheet (even a protected one).
 
Back
Top