Clear Protect from all cells in sheet

English
#1

When I ask this question I get Tools > Protect turn off OK but I want something slightly different.

How can I find what cells will be protected on a sheet.

I have a sheet that has evolved and maybe more cells than I think are protected. So before turning on sheet protection can I clear protection from all cells then reprotect only those cells I now need to protect.

When I protect I only check Select protected cells. Some must be protected earlier because I cannot edit them now.

Any advice please

#3

Menu / Edit / Select / Select Unprotected Cells

1 Like
#4

Value Highlighting

2 Likes
#2

Cells are attributed to be protected by default if sheet protection is on. Select all cells (Ctrl+A) or the cell range you want to unprotect, then Format → Cells… (Ctrl+1), tab Cell Protection, Protection, uncheck Protection, OK. Then select the cells you want to protect and repeat with enabling Protection.

#5

soko192

Thank you

It is sort of working.in that now I can only put the cursor on protected cells when sheet protected. Of course I do get the warning messsage.

When unprotected only those I want protected show grey bachgroud.

Why is cursor disabled in unprotected cells

#6

Sorry

Just reread the dialog box. checked the wrong box.

#7

Please do not use the Answer or Suggest a solution field for comments that are not an answer to the original question / solution to the problem, use Comment instead. Thanks.

Deleting this your answer and converting it to a comment would be welcome.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.