Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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: 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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.