Pasting in Rows?

F

FattyLumpkin

Hi. Would anyone be so kind as to enlighten me about a simple pastin
procedure in excel? I have a list (which I copied from a vertica
column) that I want to paste into a horizontal row in Excel. I jus
don’t see an option for this and the data gets put in vertically. Ther
are hundreds of cells to paste so I’m hopeful that someone with mor
experience can shed some light on the situation. I had the same proble
with Access.

Thanks in advance for any help you can offer
 
P

Piranha

FattyLumpkin,
After you copy your vertical data go to the cell you want the new data
to start.
Then "right" click an "Paste Special"
Click "Transpose" and OK.
This help?
Dave
 
F

FattyLumpkin

Piranha, unfortunately there is no option to transpose. I get an option
for unicode or text. I'm probably overlooking something....
 
P

Piranha

FattyLumpkin,

You are not copying and pasting this from Excell are you. Copying from
another
application and then pasting into Excel??

Dave
 
P

Paul Sheppard

If pasting from another application, paste into Excel first as a column
and then do what pirhana suggested
 
F

FattyLumpkin

Ok, sorry....I should have mentioned that I'm trying to copy a list fro
another source. What you're telling me to do now makes perfect sense bu
it does not want to past w/ the transpose because the number of cells i
not the same size/shape. I don't see a way to count this and there ar
currently 573 cells to paste.

Sorry, I'm sure this is pretty basic stuff
 
R

Ragdyer

Do you realize that XL has only 256 columns?

So, that means that you should copy *only* the first 256 rows, THEN
"PasteSpecial" and "Transpose" to a row.

Then do the copy *again*, with the next 256 rows, and transpose to the next
adjoining row.

And then finish off with the remaining 61 rows of data.
 
Top