I'm so mad at Excel right now

The forum for ranting, raving, complaining and praising
User avatar
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

Post 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.

User avatar
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

Post 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.

User avatar
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

Post by Leroy »

I'm still doing something wrong. Man I'm dumb. I either get the whole sheet locked, or nothing locked.

User avatar
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

Post 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.

User avatar
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

Post 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.

User avatar
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

Post by cards2468 »

Are you protecting the worksheet before unlocking specific cells?

User avatar
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

Post 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.

User avatar
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

Post by Leroy »

That may be part of the problem, we just bought the 2010 version and I can't find anything.

User avatar
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

Post 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.

User avatar
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

Post 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.

Post Reply