Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about copying long rows of data
Hello--
I trying to find an easier way for copying large amounts of data: What I have: Current my spreadsheets have information in six colums and each of them take about about 60,000 rows of data: I am using Excel 2007 For Instance: A B C D E F G H 201200 .05 301300 .06 401400 ..07 201201 .06 301301 .08 401401 ..05 and all the way down to row 60,000 (Give or Take) So I want to take these six rows of data and condencse it into two rows of data that has a total of 180,000 cells. (not a limitation in 2007) Today, I go through and highlight the first cell, scroll all the way down down down down. Then copy and paste those cells. This can be a long and tedius process. If there a better way? I appreciate your help. -- Jim Radtke Communication Alliance Partners 636-391-7738 MSN: |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about copying long rows of data
Not sure whether this is what you are looking for...If you have continuous
data from A1 use Ctrl+Shift+Down Arrow from cell A1 which will extend the selection to the last cell.. -- If this post helps click Yes --------------- Jacob Skaria "Jim Radtke" wrote: Hello-- I trying to find an easier way for copying large amounts of data: What I have: Current my spreadsheets have information in six colums and each of them take about about 60,000 rows of data: I am using Excel 2007 For Instance: A B C D E F G H 201200 .05 301300 .06 401400 .07 201201 .06 301301 .08 401401 .05 and all the way down to row 60,000 (Give or Take) So I want to take these six rows of data and condencse it into two rows of data that has a total of 180,000 cells. (not a limitation in 2007) Today, I go through and highlight the first cell, scroll all the way down down down down. Then copy and paste those cells. This can be a long and tedius process. If there a better way? I appreciate your help. -- Jim Radtke Communication Alliance Partners 636-391-7738 MSN: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data linking/field matching/formula updating long question | Excel Discussion (Misc queries) | |||
Copying data between duplicated rows | Excel Worksheet Functions | |||
Copying Columns of Data to Rows | Excel Discussion (Misc queries) | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
Copying data without hidden rows. | Excel Worksheet Functions |