Re: [libreoffice-users] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns

Pedro wrote:
> Hi Brian
>
>
> Brian Barker wrote
> > What happens if you:
> > o Select the row or column.
> > o Drag it to the new position.
> > o Hold down the Alt key whilst you drop?
>
> Yes! That works!
>
> I'm glad there is an easy way to do it! Thanks!!!
>
> Unfortunately (for LO) it is not obvious even for advanced users... Which
> means that for the average user the conclusion is that LO can't do that...

There are also the following alternatives:
- Hold down Ctrl whilst dropping, to copy a column overwriting any 
content already in the column you're dropping onto
- Hold down Ctrl and Alt whilst dropping, to copy to a new column 
inserted in between two existing columns

Although not particularly obvious, all these options are documented in 
the help - from the index, look up "moving" > "cells by drag-and-drop".

Holding Ctrl while dragging to copy is quite common in other 
applications too. Not so common, but I have seen holding Alt while 
dragging to move things in other applications where copying in the 
default (i.e. with no key held down) action. So now you know about them, 
it might be worth trying Ctrl+drag and Alt+drag in applications other 
than LibreOffice too ;o)

Mark.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted