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 » Workbook protection
Workbook protection
Resolved · Low Priority · Version 2010
Fri 16 Dec 2011, 17:18Delegate Hatice said...
Hatice has attended:
No courses
Workbook protection
Hi,
Is it possible to protect my workbook data from being hijacked by other people. I only want certain cells to be overtyped but at the same time I would like to keep my formulated cells to be locked?
Thank you
Hatice
Wed 21 Dec 2011, 10:00Trainer Simon said...
RE: Workbook protection
Hi Hatice,
Thank you for your question and welcome to the forum.
Select the cells that need to be overwritten and right click over one of the selected cells. Choose Format Cells and then select the Protection tab. Finally, untick the Locked checkbox.
Now you are ready to protect the sheet with a password. Go to the Review Tab on the ribbon and click Protect Sheet. Type a password in and re-enter to confirm.
All the cells on that sheet will be locked apart from the ones you unlocked.
I hopw this answers your question.
Regards
Simon
Wed 28 Dec 2011: Automatically marked as resolved.
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:Hiding and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |
