I'm so mad at Excel right now
- Leroy
- a bad penny always turns up
- Posts: 25229
- Joined: April 17 06, 12:27 pm
- Location: Hanging out with my redneck, white socks and Blue Ribbon beer.
- Contact:
I'm so mad at Excel right now
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.
Gargh.
- haltz
- Hall Of Famer
- Posts: 22630
- Joined: November 9 06, 6:45 am
- Location: a proud midwestern metropolis
Re: I'm so mad at Excel right now
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.
click lock cells in format
protect sheet
All cells are locked by default, so unlock the ones you want unlocked, then lock the sheet.
- Leroy
- a bad penny always turns up
- Posts: 25229
- Joined: April 17 06, 12:27 pm
- Location: Hanging out with my redneck, white socks and Blue Ribbon beer.
- Contact:
Re: I'm so mad at Excel right now
I'm still doing something wrong. Man I'm dumb. I either get the whole sheet locked, or nothing locked.
- haltz
- Hall Of Famer
- Posts: 22630
- Joined: November 9 06, 6:45 am
- Location: a proud midwestern metropolis
Re: I'm so mad at Excel right now
I don't know then. I'm pretty sure that's how you do it, but excel drives me insane so who knows.
- Leroy
- a bad penny always turns up
- Posts: 25229
- Joined: April 17 06, 12:27 pm
- Location: Hanging out with my redneck, white socks and Blue Ribbon beer.
- Contact:
Re: I'm so mad at Excel right now
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.
- cards2468
- Hall Of Famer
- Posts: 14745
- Joined: October 28 06, 11:10 pm
- Location: LOVE IT OR LEAVE IT
Re: I'm so mad at Excel right now
Are you protecting the worksheet before unlocking specific cells?
- haltz
- Hall Of Famer
- Posts: 22630
- Joined: November 9 06, 6:45 am
- Location: a proud midwestern metropolis
Re: I'm so mad at Excel right now
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.
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.
- Leroy
- a bad penny always turns up
- Posts: 25229
- Joined: April 17 06, 12:27 pm
- Location: Hanging out with my redneck, white socks and Blue Ribbon beer.
- Contact:
Re: I'm so mad at Excel right now
That may be part of the problem, we just bought the 2010 version and I can't find anything.
- Leroy
- a bad penny always turns up
- Posts: 25229
- Joined: April 17 06, 12:27 pm
- Location: Hanging out with my redneck, white socks and Blue Ribbon beer.
- Contact:
Re: I'm so mad at Excel right now
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.cards2468 wrote:Are you protecting the worksheet before unlocking specific cells?
- cards2468
- Hall Of Famer
- Posts: 14745
- Joined: October 28 06, 11:10 pm
- Location: LOVE IT OR LEAVE IT
Re: I'm so mad at Excel right now
Ah, I've never used 2010, I figure as radical as 2007 was they wouldn't stray to far from it, though.Leroy wrote:That may be part of the problem, we just bought the 2010 version and I can't find anything.

