Solved

password protect a cell in excel 2007

Posted on 2014-02-17
3
377 Views
Last Modified: 2014-02-17
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
Comment
Question by:route217
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39864256
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
 

Author Comment

by:route217
ID: 39864355
Hi rgonzo

Thanks for the feedback...
0
 

Author Comment

by:route217
ID: 39864356
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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question