Excel - locking cells Pamela Hoene 12/26/2008 6:48:10 PM How do I lock a cell in excel without protecting the whole doc

Re: Excel - locking cells JE McGimpsey <jemcgimpsey[ at ]mvps.org> 12/26/2008 7:20:30 PM Locking doesn't work until the worksheet is protected. OTOH, you can simply unlock all the cells except for the one you want to be locked, then protect the worksheet. In article <04D4C515-90A1-445F-BEFB-021DE6EE40CB[ at ]microsoft.com>, Pamela Hoene <Pamela Hoene [ at ]discussions.microsoft.com> wrote: [Quoted Text] > How do I lock a cell in excel without protecting the whole doc

Re: Excel - locking cells "Shane Devenshire" <shanedevenshire[ at ]sbcglobal.net> 12/27/2008 4:28:14 PM Hi, Excel 2003: 1. Select the entire sheet 2. Choose Format, Cells, Protection, and uncheck Locked 3. Select the cell or cells you want locked and choose Format, Cells, Protection and check Locked. 4. Choose Tools, Protection, Protect Sheet. If this helps, please click the Yes button. Cheers, Shane Devenshire "Pamela Hoene" <Pamela Hoene [ at ]discussions.microsoft.com> wrote in message news:04D4C515-90A1-445F-BEFB-021DE6EE40CB[ at ]microsoft.com... [Quoted Text] > How do I lock a cell in excel without protecting the whole doc