Microsoft Office Tutorials and References
In Depth Information
cells unlocked so that you can type necessary data without unlocking the entire worksheet.
Before you protect a worksheet, select the cells you want to keep unlocked, click Format on
the Home tab, and click Lock Cell, as shown in Figure 6-23. Lock Cell is selected by default
for all cells, so clicking it clears it, unlocking the selected cells.
Figure 6-23 Click Format, Lock Cell to unlock specific cells for editing.
You can easily move between unprotected cells on a locked worksheet by pressing the
One way to verify the locked status of a cell is to select it and look at the little padlock
icon next to the Lock command. If the icon appears to be clicked already, it means that the
selected cell is locked, which is the default state for all cells.
You can tell if selected cells are locked by looking at the icon adjacent to the Lock Cell
command. If the icon appears to be “pressed” like a button (as shown in Figure 6-23),
the cells are locked. Keep in mind that Excel does not provide any other on-screen
indication of the protection status for individual cells. To distinguish unlocked cells from
protected cells, you might consider applying a specific format, such as cell color or