Excel help

[crabbyman]

I was wondering if someone could help me. I was wondering if there was a way in MS Excel to create a spreadsheet only editable in certain cells. What I mean is...when you go to a car website and go to their financing thing you can only put in the number amounts and get a final product. Is it possible to make it into a similar fashion so you can edit any other cells except those involved in the formulas?

 

[Snapster]

Tools > Protection > Allow users to edit ranges, at least in 2003. I'm pretty sure you can do it in ealier versions as well.

 

[Traire]

If you right click on a cell and go to "Format Cell", then to the "Protection" tab, you will see two check boxes, on says "Locked" and one says "Hidden".

Then if you go to tools, Protection, Protect sheet and turn on protection, any cell that has the "Locked" box checked will not be editable, and any cell that has the "Hidden" cell checked will be hidden.

By default, all cells have "locked" checked. So to make certain cells remain editable, while all the other cells are locked, you need to select the cells you wnat to be editable and uncheck "Locked" from the format menu.

 

[crabbyman]

Sweet..I thank you both! I tried this before at work but it did not work. I probably did it wrong. Thanks again!