View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Omega Weapon
 
Posts: n/a
Default 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