To choose who can edit the range or sheet: select "Restrict who can edit this range." Choose:.To show a warning when anyone makes an edit: Select "Show a warning when editing this range." It doesn’t block people from editing, but they’ll see a message asking them to confirm if they really want to make an edit. Click Set permissions or Change permissions.If you want a set of cells to be unprotected in a sheet, check the box next to "Except certain cells." Range: To change or enter the range you’re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.Click Add a sheet or range or click an existing protection to edit it.Simultaneously lock the formatting of cells and allow users to edit input values.Important: When you protect a sheet, you can’t:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |