Microsoft Office Tutorials and References
In Depth Information
Figure 9–46. The Protection tab of the Format Cells dialog box
Note that the Locked check box is checked by default. That means
simply that if you protect the sheet, all its cells will be protected. But
since you’ve selected B7:B16, uncheck the Locked box. Now, once you
protect the sheet, cells B7:B16 will still remain unlocked—that is, you’ll
be able to enter data in only these cells.
And that’s how unlocking cells works—first you designate those cells to be unlocked,
and only then do you protect the sheet. So now if you activate workbook protection, it
will still be possible to enter data in cells B7:B16.
Earlier in this chapter I described how you can reveal your worksheet’s formulas in the
cells in which they’re written. There’s also a kind of flip side to this option—you can hide
worksheet formulas so that they can’t be seen at all, not even in the formula bar.
To hide formulas in cells, you have to work prospectively and select those cells before
you protect the worksheet, just as when unlocking selected cells. The following exercise
Enter these values shown in Figure 9–47 in cells D4:D8 and perform a
in cell D9.