• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel help

crabbyman

crabbyman

Senior member
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?
 
Tools > Protection > Allow users to edit ranges, at least in 2003. I'm pretty sure you can do it in ealier versions as well.
 
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.
 
Sweet..I thank you both! I tried this before at work but it did not work. I probably did it wrong. Thanks again!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top