• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

password protect a cell in excel 2007

Hi expert's excel 2007

How would you password protect a single cell in a worksheet and leave the remaining cells open for editing.
0
route217
Asked:
route217
  • 2
1 Solution
 
Rgonzo1971Commented:
HI

First select all the cells

Right-click Format cells goto Protection

untick Locked

then do the same with you cell and tick Locked ( so it will be the only Locked)

then to Review Protect Sheet

Add you PW and OK

You could there manage there what are possibilities for the users

Regards
0
 
route217Author Commented:
Hi rgonzo

Thanks for the feedback...
0
 
route217Author Commented:
Hi experts

You also provided feedback on this question http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/Q_28364900.html

I can you kindly look at my posting please.
0
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now