 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / November 2007Locking cells
I would like to lock all cells except the ones where I have cells set up for entries. I don't want the non entry cells to be edited, because I have formulas in there that I don't want changed. Thanks, Ron Hi Ron - The process may seem somewhat convoluted, but *all* cells are Locked by default - it just doesn't go into effect until you turn Protection on:-) So... Select the cells that need to remain editable then go to Format> Cells - Protection. Remove the check for Locked. When finished go to Tools>Protection>Protect Sheet.  SignatureHTH |:>) Bob Jones [MVP] Office:Mac >I would like to lock all cells except the ones where I have cells set > up for entries. I don't want the non entry cells to be edited, because > I have formulas in there that I don't want changed. > > Thanks, Ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.