98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Security
excel consultant - Security
Resolved · Low Priority · Version Standard
Tue 25 Sep 2007, 17:04Delegate Elaine said...
Elaine has attended:
Excel Intermediate course
Excel Advanced course
Security
How can I check that my formulas are protected ?
Tue 2 Oct 2007, 16:38Delegate Paul said...
RE: Security
Hi Elaine
first of all, check your whole worksheet is protected by hitting tools > Protection and depending on whether it says 'protect sheet' or 'unprotect sheet' you'll know
then, click on the cell that has the formula you want protecting and click format > cells.
click the protection tab at the top of the box you can now see and ensure 'protected' is checked.
that cell is protected, so you can go out of that box and now try typing something into that cell, Excel won't allow it
Hope this helps
Paul
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
