Microsoft KB Archive/106173

= Microsoft Knowledge Base =

Excel: Using Clear All Command on Unlocked Cell Relocks Cell
Last reviewed: September 12, 1996

Article ID: Q106173

The information in this article applies to:


 * Microsoft Excel for Windows versions 3.0, 4.0 4.0a 5.0 7.0
 * Microsoft Excel for the Macintosh versions 3.0 and 4.0

In Microsoft Excel, if you choose Clear, and then choose All, from the Edit menu when an unlocked cell is selected, the cell will change from an unlocked cell to a locked cell.

NOTE: In versions 4.x and earlier, choose the Clear All command from the Edit menu.

The default protection status for all worksheet cells is "locked." When you choose Clear All from the Format menu, the cell reverts back to this default protection status.

This is expected behavior.