How can I select non-consecutive rows in Calc?
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,...?
First time here? Check out the FAQ!
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,...?
You can select a collection of non adjacent rows with Ctrl
+click
:
Cntrl
and add something to the selection (dragging with mouse or agin clickink on row rank)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.).
I think I tried that but I'll check again. Might there be a third-party software program that will do it?
Asked: 2019-04-24 10:27:19 +0100
Seen: 356 times
Last updated: Apr 24 '19
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
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)
"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.