Protecting cells

[GregP1962]

Back in the good old days, when we had lotus, we could simply protec
cells. Why doesn't Excel tell us how to protect cells? Why is it no
simple? How do you do it

 

[Chip Pearson]

By default, all cells are locked. When you protect the worksheet
(Tools menu), all cells will be protected. To protect only some
cells, first select all cells (click the gray box above the
column header and to the left of the row headers), go to the
Format menu, choose Cells, then the Protection tab. There,
uncheck the locked checkbox. The select the cells you wish to
protect, go back to the Protection tab and check the Locked
property. Then, protect the worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"GregP1962"
message
news:[email protected]...

 

[Guest]

hi, you can protect the full spreadsheet. but you can also select all cells,
unblock all of then, and block the cells that you want, after protect the
worksheet, you just protected the cells that you block.

regards

"GregP1962" escreveu: