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
Who is Participating?
tilsantConnect With a Mentor Commented:
the attached file have cells (J1:M3) & (Z1:AB3) & (f1:G4) as locked.
to unlock them go to Tools >> Protection >> Unprotect Sheet

Once, the data that u want to put on these cells is done then again Protect the Sheet (with a password if reqd.)

1. Select all the cells of your sheet >> go to Format Cells >> Protection Tab >> UNTICK "locked".
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.

from Excel Help.

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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!!

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.

ahem ahem......... i dont think the above is "Another" suggestion!!
Its the same as i suggested.

HassanayAuthor Commented:
Thanks tilsant
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.