Locking cells in Excel 2

[hkvanx]

Hi:

I have designed a decision support system. I want to lock all cells except a few that I will allow users to input and change perimeters in. So far I am having trouble doing that. It appears the whole worksheet would be locked which is not what I am aiming for. Could some direct me to a solution? Thanks

-Howard

 

[carrr]

Highlight the cells you would like to unlock, using Ctrl. Go to Format, Cells, Protection, and uncheck locked. Now, going back to your sheet, select Tools, Protection, Protect sheet. Everything but those cells you unlocked is now locked/protected.

 

[Loomah]

Hi
In xl 97 onwards all cells are 'locked by default. Before that you had to select which cells to lock!

Select the cells you wish to leave free for input
Go FORMAT>CELLS and choose the PROTECTION tab
Untick the Locked option and OK it
Go TOOLS>PROTECTION>PROTECT SHEET
and RYMB

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[Loomah]

Hi
In xl 97 onwards all cells are 'locked' by default. Before that you had to select which cells to lock!

Select the cells you wish to leave free for input using any method you like
Go FORMAT>CELLS and choose the PROTECTION tab
Untick the 'Locked' option and OK it
Go TOOLS>PROTECTION>PROTECT SHEET
and RYMB

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[hkvanx]

Carr, Loomah: Thanks for you replies, the suggestions worked out great. Thanks again.

 

[Loomah]

Dunno who gave the star here but thanks
However as carr's suggestion was exactly the same (how could it be different) it must deserve a star so I've given one!
;-) If a man says something and there are no women there to hear him, is he still wrong?