Ask Your Question

Change paste direction Calc?

asked 2019-09-08 06:31:56 +0200

appreciatethehelp gravatar image

updated 2019-09-08 10:31:51 +0200

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


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 e.g. horizontal left-to-right characters 1, 2, & 3, each in it's own cell, copy-pasted as 3, 2, 1...?

edit retag flag offensive close merge delete


Into what are you wanting to paste them? I gather you want them pasted one under the other, although the formatting of your question doesn't correctly show this.

robleyd gravatar imagerobleyd ( 2019-09-08 07:22:15 +0200 )edit

@ robleyd Into sundry other cells in the same Calc document; your answer did the question justice.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-09-08 10:27:33 +0200 )edit

For changing the order, I suspect the simple solution is Sort; once pasted, the cells are highlighted and it is a simple matter of one click on the relevant Sort icon.

robleyd gravatar imagerobleyd ( 2019-09-08 10:49:03 +0200 )edit

That would be my go-to as well, just wondered if there was an option inherent in the paste section. Would make a handy addition, no doubt.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-09-08 12:18:54 +0200 )edit

Did you see an option there? I don't.

robleyd gravatar imagerobleyd ( 2019-09-08 14:52:53 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-08 07:31:28 +0200

robleyd gravatar image

updated 2019-09-08 07:31:55 +0200

If you want to paste in a Calc sheet, use Ctrl+Shift+V and select Transpose. I found that with a few moments of fiddling with Paste Special.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

edit flag offensive delete link more


Using Transpose through Paste Special does indeed work, however transpose only toggles paste direction between left-to-right and top-to-bottom, which makes me wonder: is it possible to paste in reverse order e.g. copy paste 123 as 321? I can't seem to achieve that using Transpose alone... Will leave question open, in order to discourse on this.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-09-08 10:25:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-08 06:31:56 +0200

Seen: 400 times

Last updated: Sep 08 '19