specific cell or colume protection
Posted by Tom on October 25, 2001 4:20 PM
Is it possible to select certain excel columes for protection? What I want to do is protect information in say columes A - C and have the rest of the work sheet unprotected so that new formulas can be made to work off the protected columes.
Posted by Moses on October 25, 2001 6:21 PM
To do this, you need to lock the cells in Collumns a-c, and unlock the remainder of the Cells.
This can be achieved by:
- Select All cells on the worksheet (Ctrl-A)
- Go into Format Cells (Ctrl-1)
- Go to the Protection Tab
- Ensure that "Locked" is unticked
- Click OK
- Select Collumns A-C (Ctrl-Space) to select a collumn, (Shift-RightArrow) to drag
- Go into Format Cells
- Lock these cells
- OK
- Tools, Protection, Protect Sheet
This will only protect the locked cells
Posted by Tom on October 25, 2001 7:00 PM
Moses,
Thanks,
Worked like a charm.
Tom
