C
Cheryl
I have two spreadsheets, one dumped into Excel from another program and one I
am creating by scanning the first and copying selected rows from it into the
second.
To do the copy and paste, I select the row I want to copy, highlight it, and
hit cntl-c. I then go to the second spreadsheet, select the first cell in
the row where I want to paste the row and hit cntl-v.
This mostly works. The trouble is that some of the cells in each row
contain several sentences and when I paste the row, the data in these cells
is cut short. I then have to scan for cells that aren't complete and cut and
paste them individually to make sure that all of the data is included.
I have investigated the "Paste Special" option, but none of the choices seem
applicable. The only one that actually pastes the row into individual cells,
"Microsoft Excel 8.0 Format", still cuts off the data in a couple of cells.
Is there any way I can cut and paste whole rows from one spreadsheet to
another without losing data in individual cells?
I am using Microsoft Office Excel 2003 with SP2 (part of Microsoft Office
Professional Edition 2003).
Thank you,
Cheryl
am creating by scanning the first and copying selected rows from it into the
second.
To do the copy and paste, I select the row I want to copy, highlight it, and
hit cntl-c. I then go to the second spreadsheet, select the first cell in
the row where I want to paste the row and hit cntl-v.
This mostly works. The trouble is that some of the cells in each row
contain several sentences and when I paste the row, the data in these cells
is cut short. I then have to scan for cells that aren't complete and cut and
paste them individually to make sure that all of the data is included.
I have investigated the "Paste Special" option, but none of the choices seem
applicable. The only one that actually pastes the row into individual cells,
"Microsoft Excel 8.0 Format", still cuts off the data in a couple of cells.
Is there any way I can cut and paste whole rows from one spreadsheet to
another without losing data in individual cells?
I am using Microsoft Office Excel 2003 with SP2 (part of Microsoft Office
Professional Edition 2003).
Thank you,
Cheryl