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
=========================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top