Microsoft Office Tutorials and References
In Depth Information
Locking Cells
Figure 7–16. The Protect Sheet dialog box
If you click OK, the sheet will revert to protected status, with the default selections you see checked
above put in place. And what do those selections mean? Select locked cells and Select unlocked cells
mean that you’ll be allowed to click on any cell in the worksheet—but you won’t be able to enter any
data in it. (It does mean, however, that you’ll still be able to see any underlying formulas in any cells.)
And what’s a locked cell? I was afraid you’d ask that question. For starters, what it means is that if you
check both of the above default options off , you won’t even be able to click on any worksheet cell. And if
you click only Select locked cells off , you’ll be able to click on unlocked cells only .
Locking Cells
But I still haven’t defined locked cells—so here goes. By default, turning on worksheet protection locks
all of a worksheet’s cells. But if you want to able to enter data in just some cells and leave the
remainder of the sheet protected, you have to inform Excel about this intention before you turn
protection on (I told you it was quirky). If that’s what you want to do—that is, be able to enter data in
some cells only—then befor e tur ning pr otection on, first select those cells you want to leave available
for data entry, and then click either the Home tab the Dialog Box Launcher in the Font button group,
or Home tab Format in the Cells button group For mat Ce l l s… . You’ l l be br oug ht to thi s di al og box
(Figure 7–17):
 
Search JabSto ::




Custom Search