To manage lock settings:

1. Click Data > Lock > Manage Lock Settings.

2. The dialog box shows all the cell ranges and sheets that have been locked by the user for various collaborators.

A green lock icon  indicates that the particular cell range has been locked for that specific collaborator. Click on it to unlock that cell range for that specific collaborator.