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

Maybe you want paste specialtranspose to copy A1:A5 into B1:F1


Gord Dibben MS Excel MVP

On Thu, 11 Jun 2009 20:07:23 -0400, John Smith wrote:

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.