Ask Your Question

Can I have a column repeat or copy the info into another column? [closed]

asked 2012-12-24 16:30:59 +0200

anonymous user


Repeating columns with data

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 2015-10-19 14:28:16.566804

2 Answers

Sort by » oldest newest most voted

answered 2012-12-25 08:51:52 +0200

JohnSUN gravatar image

Try it:

  1. Select source column

  2. Start to drag the selection with the mouse to a new position in the target column.

  3. Hold down Ctrl or Ctrl+Shift (the cursor will change - add a plus or arrow)
  4. Drop selection on target column
edit flag offensive delete link more

answered 2012-12-26 01:44:46 +0200

ROSt52 gravatar image

If you want to copy/repeat the very left column there is also the possibility to freeze the column which keeps the column always visible when you scroll to the right sight. To do so, place cursor in B2, open Window > Freeze. See also Help "freezing rows or columns".

All depends on what you want to do.

edit flag offensive delete link more


+ROSt52 I also wanted to say something about Calc. But at the last moment noticed the tag "Writer" ;-)

JohnSUN gravatar imageJohnSUN ( 2012-12-26 09:00:57 +0200 )edit

@JohnSUN - ups, I did not see the tag "writer". Then my answer doesn't apply at all. Now I also better understand your answer. Sorry for confusion.

ROSt52 gravatar imageROSt52 ( 2012-12-26 13:09:38 +0200 )edit

Question Tools


Asked: 2012-12-24 16:30:59 +0200

Seen: 93 times

Last updated: Dec 26 '12