Hassanay
asked on
How to make cells uneditable in excel
I have couple of cells (J1:M3) & (Z1:AB3) & (f1:G4).
i want to make these cells uneditable, only theses cells, i dont want the user to be able to edit it
i want to make these cells uneditable, only theses cells, i dont want the user to be able to edit it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jus in case if u are using 2007, then instead of going to tools>>protection......... .. u'll have to go to "Review" tab in which u'll find "Protect Sheet" Button.
Rest all follows the same!!
Rest all follows the same!!
Another Suggestion in a bit more detail
By default, all cells in Excel are already locked.
1. A quick way is to Click the Corner box where A1 is, which selects all cells.
2. Then right click the Selection and select "Format Cells"
3. Click the Protection Tab and select "Unlock" and click ok.
4. Now select the cells you wish to protect by doing the following multiple selections: Click on Cell F1 hold and drag the mouse to G4, Now Hold down the Control Button and click on J1 and drag the mouse to M3, then still holding control select Z1 and drag the mouse to AB3.
5. Carefully right click the Selection and select "Format Cells"
6. Click the Protection Tab and select "Lock" and click OK.
7. Right Click the Sheet Tab at the bottom of your Sheet and select "Protect Sheet"
8. Untick "Select Locked Cells" which help letting someone know that you can't edit the cells, since they won't even be able to select them.
9. Type a password, click ok then confirm the password and click ok and then ok again.
Your sheet will now be protected and only the cells that are unlocked can be selected for editing.
By default, all cells in Excel are already locked.
1. A quick way is to Click the Corner box where A1 is, which selects all cells.
2. Then right click the Selection and select "Format Cells"
3. Click the Protection Tab and select "Unlock" and click ok.
4. Now select the cells you wish to protect by doing the following multiple selections: Click on Cell F1 hold and drag the mouse to G4, Now Hold down the Control Button and click on J1 and drag the mouse to M3, then still holding control select Z1 and drag the mouse to AB3.
5. Carefully right click the Selection and select "Format Cells"
6. Click the Protection Tab and select "Lock" and click OK.
7. Right Click the Sheet Tab at the bottom of your Sheet and select "Protect Sheet"
8. Untick "Select Locked Cells" which help letting someone know that you can't edit the cells, since they won't even be able to select them.
9. Type a password, click ok then confirm the password and click ok and then ok again.
Your sheet will now be protected and only the cells that are unlocked can be selected for editing.
ahem ahem......... i dont think the above is "Another" suggestion!!
Its the same as i suggested.
Tils.
Its the same as i suggested.
Tils.
ASKER
Thanks tilsant
2. Select the cells u want to Lock >> go to Format Cells >> Protection Tab >> TICK "locked".
3. Go to Tools >> Protection >> Protect Sheet >> give a password if reqd. >> TICK "select locked cells" & "select unlocked cells" and then click OK.
Its done.
to remove the protection go to tools >> protection >> Unprotect Sheet.
Tils.