Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Change paste direction Calc?

Say I've copied some characters from four, horizontally adjacent cells i.e. 1, 2, 3 & 4. If I copy them like this: 1 2 3 4 How do/can I paste them like this, (other than pasting each character individually into the correct position)? 1 2 3 4

Thanks.

Change paste direction Calc?

Say I've copied some characters from four, horizontally adjacent cells i.e. 1, 2, 3 & 4. If I copy them like this: 1 2 3 4 How do/can I paste them like this, (other than pasting each character individually into the correct position)? 1 2 3 4

Thanks.

EDIT: now that I know that Transpose via Paste Special will allow the orientation to be changed between top-to-bottom/left-to-right, can anyone weigh in on how the direction of the characters can be changed eg horizontal left-to-right 1, 2, 3 copy-pasted as 3, 2, 1...?

Change paste direction Calc?

Say I've copied some characters from four, horizontally adjacent cells i.e. 1, 2, 3 & 4. If I copy them like this: 1 2 3 4 How do/can I paste them like this, (other than pasting each character individually into the correct position)? 1 2 3 4

Thanks.

EDIT: now that I know that Transpose via Paste Special will allow the orientation to be changed between top-to-bottom/left-to-right, can anyone weigh in on how the direction of the characters can be changed eg e.g. horizontal left-to-right characters 1, 2, 3 & 3, each in it's own cell, copy-pasted as 3, 2, 1...?