LOCKING CELLS

B

Bob Newton

Can someone tell me how I can look only certain cells in a worksheet. I want
the whole saheet to be unable to change except for a few certain cells.

Also, where can I go to learn more advanced formulas in ecel?

Thanks in advance all
Bob
 
B

BrianB

All cells in a worksheet are locked by default. To unlock odd cells,
select them and use Format/Cells/Protection.

To unlock all cells (to lock odd cells) click the little box where row
and column numbers join - which selects the whole sheet - and format
cells as above.

Regards
BrianB
=========================================
 
Top