Forum home » Delegate support and help forum » Microsoft Excel Training and help » application development excel - Protecting a cell?
|
|
|
The UK's most regular 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. |
application development excel - Protecting a cell?
Resolved · Low Priority · Version Standard
Reply Thu 9 Nov 2006, 15:25
Edited on Fri 10 Nov 2006, 12:23Delegate Steve said...
Steve has attended:
Excel Intermediate course
Protecting a cell?
Hello,
Further to my training course that i attended on Monday, please can you tell me where i can find the section on protection a cell, that prevents another user seeing what the sum is.
I would appreciate it if you can let me know the answer.
Kind Regards
Steve
For upcoming training course dates see: Pricing & availability
RE: Protecting a cell?
Hi Steve,
To protect a cell in an Excel worksheet, use the Tools > Protection> Protect Sheet menu option. Worksheet protection will affect /apply only to "Locked" cells, and by default Excel cells are locked. A password can be enabled to restrict user access.
To unlock an Excel cell or range of cells, select the cell(s), click on the Format > Cells menu and select the Protection tab sheet. Untick the Locked option. Please also note that to not display the contents of cells in the formula, such as a Sum function, tick Hidden.
Where you state, ..."prevent other user seeing what the sum is", I understand that to mean the sum formula in the formula bar.
Hope this helps
|