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 <[email protected]> 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: [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 -- **** 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: [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
