paste to the right

[John Smith]

I have Excel 2003. When pasting multiple cells, Excel pastes the
cells vertically (down) instead of horizontally (to the right).

How do I configure Excel so it'll paste to the right? Thanks.

 

[FSt1]

hi
confused. are the multiple cells you are coping in a column?
if you are wanting to transpose the paste then on the menu bar....
edit>paste special>transpose.

regards
FSt1

 

[John Smith]

They are in rows but Excel pastes them in one single column.

 

[Gord Dibben]

If the cells you are pasting were vertical to start with that's the way they
will paste.

Maybe you want paste special>transpose to copy A1:A5 into B1:F1


Gord Dibben MS Excel MVP