How to cut multiple non consecutive rows in Excel

Im using LO version 6.0.4.2.I have to select, cut and paste many rows from a list.The matter is that rows I need to cut are not contiguous in the list.When I:select my lines with C

How to cut multiple non consecutive rows in Excel

Im using LO version 6.0.4.2.
I have to select, cut and paste many rows from a list.
The matter is that rows I need to cut are not contiguous in the list.
When I:

  • select my lines with CTRL+left mouse click
  • press CTRL+X to cut them

Calc says this feature is not working with multiple selections.
Has this feature been added in current stable release (or planned in the future and worhing on current develpment version)?
I think its a must for a spreadsheet application

Anyway how to achieve the above task:

  • select many rows
  • cut them
  • and paste in an other place or in an other sheet

I noticed the copy and paste feature is working:

  • multiple selection with ctrl+mouse
  • CTRL+C to copy
  • CTRL+V to paste in an other place

But now, to delete copied lines from the original list I have to re-select the lines (same selection I did) and finally press Canc to remove lines content or maybe some other function to remove the lines too.
Is there a better way?

Thanks in advance!

:slight_smile:

Video liên quan