Page 1 of 2

I'm so mad at Excel right now

Posted: March 18 11, 10:38 pm
by Leroy
Gargh, all I want to do is lock certain cells so people can't screw them up. I want to leave others for them to input their information. Apparently to my dumb mind you either get all or nothing, but I know that isn't true.

Gargh.

Re: I'm so mad at Excel right now

Posted: March 18 11, 10:45 pm
by haltz
highlight cells that you want unlocked
click lock cells in format
protect sheet

All cells are locked by default, so unlock the ones you want unlocked, then lock the sheet.

Re: I'm so mad at Excel right now

Posted: March 18 11, 10:50 pm
by Leroy
I'm still doing something wrong. Man I'm dumb. I either get the whole sheet locked, or nothing locked.

Re: I'm so mad at Excel right now

Posted: March 18 11, 10:57 pm
by haltz
I don't know then. I'm pretty sure that's how you do it, but excel drives me insane so who knows.

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:03 pm
by Leroy
I'm a pretty peaceful person but I really want to beat someone up right now. I've printed out the help and everything and nothing works. Gargh I have worked hard on this thing.

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:08 pm
by cards2468
Are you protecting the worksheet before unlocking specific cells?

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:08 pm
by haltz
ok, so I tried and that's how you do it.

When you click off locked cells, go back to format and hit "protect sheet." Uncheck the box (under "allow all users of this worksheet to:") called "select locked cells" and after two password prompts you should be good to go.

This is all under Format.

edit - I'm using 2007.

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:13 pm
by Leroy
That may be part of the problem, we just bought the 2010 version and I can't find anything.

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:15 pm
by Leroy
cards2468 wrote:Are you protecting the worksheet before unlocking specific cells?
I have tried, but if I un-protect the sheet, everything can be changed. If I protect the sheet, nothing can be changed even with a password.

Re: I'm so mad at Excel right now

Posted: March 18 11, 11:15 pm
by cards2468
Leroy wrote:That may be part of the problem, we just bought the 2010 version and I can't find anything.
Ah, I've never used 2010, I figure as radical as 2007 was they wouldn't stray to far from it, though.