98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » application development excel - Protecting a cell?
application development excel - Protecting a cell?
Resolved · Low Priority · Version Standard
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
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
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:Jumping Across the Excel ScreenPgDn and PgUp keys scrolls up and down a screen page in most applications. |