To see protected cells, click View Protected ranges. Copy permissions from another range: Reuse the same permissions you set up on a different set of cells or sheet.
Learn how to protect cells in Google Sheets, and even pages.
Click Data Protected sheets and ranges.Simultaneously lock the formatting of cells and allow users to edit input values.Folks, I was wondering if it is possible to lock selected cells without protecting a worksheet I know how to unlock selected cells while the remaining cells are locked by protecting. 18 Comments 1 Solution 7704 Views Last Modified. Important: When you protect a sheet, you can’t: Lock selected cells without protecting worksheet.