Ask Your Question. Experts Answer You ASAP.

PROTECT EXCEL WORKSHEET BUT EXEMPT SOME CELLS FROM PROTECTIONI
Sent to General Experts October 12 04:12 AM

I just installed Office 2003 ... on the old Office 97 when I Protected worksheets in Excel I could exclude certain cells or columns from the Protection .... How do I do this with Office 2003 ... I want to Protect aan Excel Worksheet but I want to set certain cells on the worksheet as Not Protected ???

Thanks for help

 

Customer (name blocked for privacy)
Status:  Closed   Value: $9.95
Answer
October 12 5:36 AM (1 hour and 24 minutes and 2 seconds later)
         
ACCEPTEDCheck Mark

Thank you for your question and welcome to Just Answer.

Before you turn on the Protection you'll need to select all of the cells you don't want to protect. You can hold down the shift or ctrl key to highlight multiple cells at once. Go to Format->Cells->Protection Tab. Click on the "Locked" box to unselect it. You can now go back and protect the rest of the worksheet by going to Tools->Protection->Protect Sheet.

I hope this helps! If so, please don't forget to "Accept!"

Regards,

Ryan



If you found my help useful please don't forget to "Accept " A Bonus and Feedback is greatly appreciated
Picture
Ryan -- Professional Researcher -- 100% Positive Feedback on 275 General Accepts
I only answer questions I'm 100% confident in. If you got an answer from me it's because I know it!
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the Just Answer service comes from those individuals, not from Just Answer!, and that Just Answer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on Just Answer! are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. Just Answer! is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

Just Answer! > General