Ok, Ive messed with this in the past, never been able to figure it out,
but something always stopped me from pursuing it until now.
I'm just looking for the quickest/easiest way to MOVE rows/columns.
Is this even possible? I've NEVER been able to get it to work, even in
Excel...
If not, then what is the shortest route to MOVE a row/column using
CUT+INSERT?
In Excel it takes just 4 clicks/steps:
1. Right-click a row/column header,
2. Click CUT,
3. Right-click the row/column header above/to-the-right-of the
row/column you want the one you CUT to go, and last
4. Click 'Insert cut cells'
which moves the row/column you cut and place it before or above the one
you right-clicked on.
In Calc it takes 6:
1. Right-click a row/column header,
2. Click CUT,
3. Right-click the row/column header above/to-the-right-of the
row/column you want the one you CUT to go,
4. Click 'Paste Special',
5. Change 'Shift cells' to either 'Right' (for columns) or 'Down'
(for rows), and last
6. Click 'OK'
--
To unsubscribe e-mail to: [email protected]
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
