LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine the maximum lost? Eric Excel Discussion (Misc queries) 3 March 6th 06 09:49 PM
CHANGE DATA SERIES WITH A COMMAND BUTTON Raymond Willis Charts and Charting in Excel 5 December 5th 05 05:49 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"