workbook protection

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Workbook protection

Workbook protection

resolvedResolved · Low Priority · Version 2010

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

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.


 

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips


Server loaded in 0.13 secs.