Ask Your Question

How can I select non-consecutive rows in Calc?

asked 2019-04-24 10:27:19 +0100

kingwillard gravatar image

updated 2019-04-24 10:28:08 +0100

I need to move non-consecutive rows in Calc. How do select a group of these rows and then move them, delete them, copy them,...?

edit retag flag offensive close merge delete


What do you mean by "non-consecutive rows"? Rows are always consecutive - one row follows the other. Do you mean "ranges containig rows without any entry (blank rows)"?

If yes - consider a filter and unselect "(empty)"

Opaque gravatar imageOpaque ( 2019-04-24 12:18:47 +0100 )edit

I meant rows that are not next to the other rows I want to move. I have a file that has all of my current contacts, newer contacts that need to be organized, and all of the contacts that Gmail recorded for me from the time I got my Gmail account (way back around 2000) until earlier this year. So I've got a a huge collection of contacts, complete with many duplicates, that I started to organize. If I can select multiple non-sequential rows and delete, move. or copy them, it would save me a hell of a lot of time. I tried to do it in OpenOffice but was that it wasn't possible and I deleted OpenOffice as it had become increasingly unstable anyway. Thanks for your help.

kingwillard gravatar imagekingwillard ( 2019-07-13 01:14:37 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-24 13:13:37 +0100

ajlittoz gravatar image

You can select a collection of non adjacent rows with Ctrl+click:

  • select the first row through usual means, e.g. clicking on its rank in the left "margin"/column
  • press Cntrl and add something to the selection (dragging with mouse or agin clickink on row rank)
  • repeat at wil

But, I don't know if you can move the selection. You can anyway apply common "processing" to the collection (delete values, change visual attributes, set common formula, etc.).

edit flag offensive delete link more


I think I tried that but I'll check again. Might there be a third-party software program that will do it?

kingwillard gravatar imagekingwillard ( 2019-07-13 01:16:47 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-24 10:27:19 +0100

Seen: 356 times

Last updated: Apr 24 '19