RE: Worksheet protection

Hello Tracy,

Hope you enjoyed your Microsoft Excel Intro & Intermediate courses with Best STL.

Thank you for your question regarding protecting part of a worksheet.

Every cell in a worksheet is locked by default and only when you apply protection to the worksheet will the locking take effect. If you do not unlock any cells before applying protection with a password then you cannot do anything in the worksheet except for formatting items which have been allowed.

So, to protect only a part of the worksheet you must first select the cells which will be unlocked and then select the Review ribbon, then click the Protect button from the Changes group. Tick whatever formatting options you will allow the user to work with, enter a password, confirm the password and then click OK. If you have ideas about protecting the worksheet without using a password you are wasting your time since anyone can unprotect the sheet.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer