What happens when you try to edit a locked cell in a protected worksheet in Excel?

The cell cannot be selected or edited without unprotecting the worksheet.

The cell contents are automatically deleted.

A warning message is displayed, but the cell can still be edited.

The cell contents cannot be changed, but formatting options are available.

1 answer

The cell contents cannot be changed, but formatting options are available.
Similar Questions
    1. answers icon 1 answer
    1. answers icon 1 answer
  1. How can you identify locked cells in Excel?Locked cells are highlighted with a specific colour. Locked cells are formatted with
    1. answers icon 1 answer
  2. How can you identify locked cells in Excel?Locked cells are highlighted with a specific colour. Locked cells are formatted with
    1. answers icon 1 answer
more similar questions