Ask Your Question
2

how to insert copied columns [closed]

asked 2013-03-02 02:54:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

In excel when columns or rows are selected and copied an insert option is available to insert the copied columns or rows elsewhere on the sheet.

Is there a way to do this in Calc?

When I copy a group of contiguous columns and go to insert the copied columns there is only the insert column option in the context menu which only creates a single new blank column.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 21:02:20.846642

Comments

Try drag-and-drop selection with hold Ctrl+Alt... See here

JohnSUN gravatar imageJohnSUN ( 2013-03-02 18:22:28 +0200 )edit

@JohnSUN -- please add your suggestion as an Answer instead of a Comment so that it can be marked as correct if it solves @taklecker's question :-)

qubit gravatar imagequbit ( 2013-03-06 07:25:12 +0200 )edit

@qubit - The decision to which I referred in the comments, we are talking about moving the rows, not columns. Therefore, it is not a complete answer to this question.

JohnSUN gravatar imageJohnSUN ( 2013-03-06 09:09:18 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-03-06 09:12:55 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

@JohnSUN's link to the short video is a great demonstration once the objective is to move/copy rows/colums at the end of table. ( I would like to know how to make such a movie. JohnSUN??? )

Moving/copying rows/columns in between rows/colums is a bit tricky and require preparation of space.

What I am explaining and showing for the example of copying colums is valid for rows and moving as well.

Start situation: I want to copy colums B+C between columE+F image description

Preparing space: Inserting of 2 columns to create space image description

Copy result can be achieved with copy & paste or drag &drop with ctrl key pressed image description

edit flag offensive delete link more

Comments

We can omitted step 2 - drag-and-drop selections with pressing Ctrl and Alt (both keys). @ROSt52 - I use just a small portion of the possibilities of this program - UVScreenCamera

JohnSUN gravatar imageJohnSUN ( 2013-03-06 09:40:45 +0200 )edit

@JohnSUN - I tried key combinations but missed the alt+ctrl. This is very good feature. If i am not completely wrong, EXCEL doesn't have this one. Thanks also for the hint with the camera. I need to test.... but need some time....

ROSt52 gravatar imageROSt52 ( 2013-03-06 14:18:04 +0200 )edit

@JohnSUN - I tried key combinations but missed the alt+ctrl. This is very good feature. If i am not completely wrong, EXCEL doesn't have this one.

ROSt52 gravatar imageROSt52 ( 2013-03-06 14:18:11 +0200 )edit

@JohnSUN - I tried key combinations but missed the alt+ctrl. This is very good feature. If i am not completely wrong, EXCEL doesn't have this one.

ROSt52 gravatar imageROSt52 ( 2013-03-06 14:18:16 +0200 )edit

Excel do it with context menu after drag by right button of mouse

JohnSUN gravatar imageJohnSUN ( 2013-03-06 15:08:31 +0200 )edit
0

answered 2014-04-19 08:55:47 +0200

Kunjomachen gravatar image

updated 2014-04-19 09:15:12 +0200

see this extension- Wrap & insert toolbar

This extension for calc create a toolbar which has button for wrap text in selected cell(s), unwrap text in selected cell(s), insert copied row(s) or cell(s), insert copied column(s)or cell(s) and paste value

see this also

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-03-02 02:54:32 +0200

Seen: 6,470 times

Last updated: Apr 19 '14