Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

A very basic excel question about protecting cells

  Asked By: Sienna    Date: Dec 03    Category: MS Office    Views: 801
  

I have a few, < 10, cells containing numbers that are the inputs to my
spreadsheet. I want these to be unprotected for ease of entry.

Then the outputs of the computation appear in more unhidden cells.
These I want to be strictly protected.

I have tried this in Excel2003 without success. How do I do it, please?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Bonnie Hughes     Answered On: Dec 03

If I understand you correctly you want the 10 input cell unprotected and
unhidden and the output just protected.

What I do in Excel 2003 is to lock all the cells  in the sheet (Control A,
right click, cell properties, Protection Tab, Locked), then select the 10 cells,
return to the properties and unlock the 10 cells. After you this step, you might
be forgetting to protect the sheet. This will activate the the protection of
cells. (tools/protection/protect sheet). Hide cells is here too, if you don't
want your user to see your formulas.

 
Answer #2    Answered By: Percy Morgan     Answered On: Dec 03

By default, the individual cells  are protected. Just unprotect the ones you
want unprotected.

But ... by default, the worksheet and workbook are unprotected. Go to Tools
/ Protection (I think, or similar) and protect the workbook and sheet.

 
Didn't find what you were looking for? Find more on A very basic excel question about protecting cells Or get search suggestion and latest updates.




Tagged: