HELP!!!

I'm on the board of directors of a non-profit organization that provides support for families of kids with cancer. We're hosting our second annual caregivers retreat in March. As I was going through the database I created last year with about 130 families on it, I discovered that the last names got shifted up one row so that about 30 families were sent invitations with their correct first names, correct addresses, but the wrong last name! Duh!!! Is there some way to protect information once it's been entered so that one row is a discreet, inseparable piece of data? I'm also having a problem because I recently purchased the latest version of Excel and am having trouble figuring it out. I've done a couple of on-line searches for help, but can't seem to follow what they're saying.

HELP!!!

_________________


"There's a release in knowing the truth no matter how anguishing it is. You come finally to the irreducible thing, and there's nothing left to do but pick it up and hold it. Then, at least, you can enter the severe mercy of acceptance." Sue Monk Kidd

"Never doubt that a small group of thoughtful people can make a difference, in fact it is the only thing that ever has." Margaret Meade

Ann, married to Tim, mom to Sally, Mark, Jane, John (12/02, DS), Paul and Alice

www.caringbridge.org/visit/johnbremer

Not sure what version of Excel you are running? I am running 2007.

But to protect a worksheet open the worksheet, go to Review tab, In the Changes part click on Protect Sheet.

_________________


Nicol - Mom to Alex -18

I did that, but then it wouldn't let me do anything to the worksheet. I need to add data without worrying that the data that's already there is getting messed up. I'm also using Excel 2007.

_________________


"There's a release in knowing the truth no matter how anguishing it is. You come finally to the irreducible thing, and there's nothing left to do but pick it up and hold it. Then, at least, you can enter the severe mercy of acceptance." Sue Monk Kidd

"Never doubt that a small group of thoughtful people can make a difference, in fact it is the only thing that ever has." Margaret Meade

Ann, married to Tim, mom to Sally, Mark, Jane, John (12/02, DS), Paul and Alice

www.caringbridge.org/visit/johnbremer

Can't you just lock the cells already in the worksheet and then be able to add new items to the sheet that are unlocked.

Lock cells by going to the worksheet, highlighting those cells you want locked right click- format cells- protection- lock cells.

That way the cells already in the worksheet will be locked..not the entire sheet?

_________________


Nicol - Mom to Alex -18