You might have to enter a password if the Worksheet was protected with one originally. If the Worksheet has already been protected, the first step is to unprotect it by clicking the REVIEW tab within the Ribbon and selecting Unprotect Sheet. ![]() When the Worksheet is shared, the team member will be able to adjust all unlocked cells however, the locked cells will remain the same. When sharing projects among several team members, sometimes it is necessary to lock certain cells within the Worksheet to ensure the data isn’t deleted or changed. Hiding or locking cells has no effect at all on the Worksheet until you protect the Worksheet. This element within Excel allows others to enter or edit information into all other cells except those locked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |