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

Question

The cell contents are automatically deleted.

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

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

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

Answer 1

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