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

Question

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.

Answer 1

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