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
HassanayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tilsantCommented:
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.


Tils.
0
tilsantCommented:
from Excel Help.

How-to-Password-Protect.pdf
0
tilsantCommented:
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.)


tils.
Book2.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

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

0
ydsonlineCommented:
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.







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


Tils.
0
HassanayAuthor Commented:
Thanks tilsant
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.