Help! Lost Data with Fill Command!!
 

Okay, I was working out the data for this survey. And I wanted to delete
one of the people's responses (rows represent individual people, columns
questions) because there was a lot of unfilled answers in his survey
responses. Anyway, so I delete his data and there's this big gap. Now,
I don't like that, bugs me.

So, this guy's like number 109, and there's 283 people (rows) involved.
So I highlight it all from his down, and then couldn't find any shift
command, but I, very stupidly, selected "Edit=Fill=Up," and it
changed 100's of people's data to the same repeating pattern.

I went to edit undo, but it said "can't undo," and now I'm stuck and
don't know what to do. I really don't want to have to re-input all
those people's responses, it having taken a few hours the first time,
so please, please help.

Very grateful,

--Omega Weapon


--
Omega Weapon
------------------------------------------------------------------------
Omega Weapon's Profile: http://www.excelforum.com/member.php...o&userid=32764
View this thread: http://www.excelforum.com/showthread...hreadid=525980

Help! Lost Data with Fill Command!!
 

Did you save the spreadsheet occasionally as you entered hours worth of data?

If you can't undo, the best you can do is go back to the last saved version.
Save your file under another name in case you ever need it, close the file and
load the most recently saved version.

--
Regards,
Fred


"Omega Weapon" wrote
in message news:Omega.Weapon.255ouy_1143173700.8715@excelforu m-nospam.com...

Okay, I was working out the data for this survey. And I wanted to delete
one of the people's responses (rows represent individual people, columns
questions) because there was a lot of unfilled answers in his survey
responses. Anyway, so I delete his data and there's this big gap. Now,
I don't like that, bugs me.

So, this guy's like number 109, and there's 283 people (rows) involved.
So I highlight it all from his down, and then couldn't find any shift
command, but I, very stupidly, selected "Edit=Fill=Up," and it
changed 100's of people's data to the same repeating pattern.

I went to edit undo, but it said "can't undo," and now I'm stuck and
don't know what to do. I really don't want to have to re-input all
those people's responses, it having taken a few hours the first time,
so please, please help.

Very grateful,

--Omega Weapon


--
Omega Weapon
------------------------------------------------------------------------
Omega Weapon's Profile:
http://www.excelforum.com/member.php...o&userid=32764
View this thread: http://www.excelforum.com/showthread...hreadid=525980