If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
paste to the right
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. |
#2
|
|||
|
|||
paste to the right
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.... editpaste specialtranspose. regards FSt1 "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. |
#3
|
|||
|
|||
paste to the right
They are in rows but Excel pastes them in one single column.
FSt1 wrote: 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.... editpaste specialtranspose. regards FSt1 "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. |
#4
|
|||
|
|||
paste to the right
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. |
Thread Tools | |
Display Modes | |
|
|