When you lock cells in Excel and then protect the worksheet, they are protected and cannot be edited. This means users cannot make changes to the locked cells unless they unprotect the worksheet (if they have the necessary password) or if you specifically allow certain actions while protecting the sheet.
Question 21
When you lock cells in Excel, what happens to the locked cells when you protect the worksheet?
They are protected and cannot be edited.
They are automatically formatted with a different colour.
They can still be edited and modified
They become hidden and cannot be accessed.
1 answer