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'
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.