Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
locking cells in excel
Name: westsideridaaaa Date: June 19, 2007 at 18:19:23 Pacific OS: xp CPU/Ram: 256 Product: sony
Comment:
I am wondering how I can lock a cell and once locked make the cell unclickable when protected. So that every time tab is hit is goes to the next unlocked cell for information to be inputed into.
Name: westsideridaaaa Date: June 24, 2007 at 16:49:47 Pacific
Reply:
Thanks. Anyone know how I make the cells unclickable when locked?
0
Response Number 3
Name: t8ntlikly Date: June 25, 2007 at 05:36:35 Pacific
Reply:
When you have the cells selected that you want protected, select Protect Worksheet, a menu appears and the first item that is checked is to allow the user to select locked cells. Uncheck that and you are ready to go.
Summary: By default, when you protect a worksheet, all the cells on the worksheet are locked. You can however, lock only specific cells and ranges. Enter "Unlock specific areas of a protected worksheet" in Ex...
Summary: One of our users is having a problem with merging cells in excel 2002. She cannot merge cells, but only in one worksheet. The merge button is even grayed out. Is there check box, or an option somewher...
Summary: I'd like to know if there's a way of locking a certain cell so that noone can overwrite the formula that's in it. I have Excel 97 and have created a sheet where several cells contain formulas. My coll...
0 
