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

Hi

I select the part of the spreadsheet I want to move. Then I click in
the middle of that area and drag the selection to the new position.

I hope my brief explanation is clear enough.

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv


On 26 February 2014 15:28, Tanstaafl <tanstaafl@libertytrek.org> wrote:
> 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

-- 


**** DISCLAIMER ****

http://www.tvh.com/newen2/emaildisclaimer/default.html

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

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