Microsoft Office Tutorials and References
In Depth Information
Unprotecting a Worksheet
In order to make some cells available to receive data in a worksheet that’s otherwise
protected, you need first to select those cells and instruct Excel not to protect them.
NOTE: In order to designate some cells to receive data, the entire sheet has to have been
The following short exercise will demonstrate how this works:
Select cells B7:B16.
Now click Home Format Format Cells… in the Cells button group, as
shown in Figure 9–45.
Figure 9–45. Starting the individual cell protection process by clicking Format Cells….
After selecting that option, you’ll be reintroduced to an old friend, the
Format Cells dialog box; only this time, you need to click one of its tabs
that we haven’t visited before: Protection (see Figure 9–46).