In the Title box, type the name for the range that you want tounlock.
On the Review tab, in the Changes group, click Allow Users toEdit Ranges.
Select the worksheet that you want to protect.
In the Restrict Formatting and Editing task pane, click StopProtection.Īlso Know, how do you unlock an Excel file for editing? Unlock ranges on a protected worksheet for users toedit.
On the Review tab, in the Protect group, click ProtectDocument, and then click Restrict Formatting and Editing.
Then uncheck the' Locked' checkbox, and you're done!Ĭorrespondingly, how do I unlock a Word document for editing? The quickest method is to select all the filesyou want to unlock, then press "Option + Command + I" (orhold down Option while choosing "Get Info" from the File menu) toopen one Info pane for all of them.