Unlock the locked cells
To manage lock settings:
Click Data > Lock > Manage Lock Settings.
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.
Related Articles
Lock cells
To lock a range of cells, Select the particular cell or range of cells that you wish to lock. Select Data > Lock> Lock Cells. You can also right click on the selected range and click Lock Cells. The Lock Cells dialog box appears. Choose the ...View all the locked cells/range
To highlight locked cells: Click Data > Lock > Highlight Locks or go to the View Settings in the side panel > Highlight Locks. The cells that have been locked for all collaborators will be highlighted and visible now. To remove the cell/range ...Lock and Unlock a Slide
Lock a slide to protect it from being edited, modified, or deleted by users with whom you have shared your presentation. A locked slide can only be opened and viewed by other shared collaborators. There are two methods to lock or unlock a slide: ...Lock a sheet
You can also lock a particular sheet to be made inaccessible to edit for other collaborators. To lock a sheet Click Data > Lock> Lock Sheet. Lock the sheet to those collaborators for whom you wish to lock the cells. The sheet stays locked to newly ...Apply borders to cells
To apply borders for cells: 1. Select the cell(s). Click the Borders icon from the toolbar. 2. You can choose from a range of border types that are available . These are the types that you can choose from : You can also choose from the various ...