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 highlights, disable Highlight Locks by following the same steps mentioned above.
You can view the Manage Lock Settings dialog box by clicking the lock icon present in the range.
Related Articles
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 ...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 ...Select a cell range
To select a cell range, 1. Click, and drag to select the cells you want.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 ...Sort data present in cells
To sort data: 1. Select the range of cells to be sorted. 2. Click Data > Sort > Sort Ascending or Sort Descending. 3. To set your conditions for sorting select Custom Sort. You can also use the Sort icon from the tool bar.