[libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
Hello, I want to move cell A1 to A2 with the mouse: I select A1, then press Alt, and move the cell with the mouse: Nothing happens I select A1, then press Ctrl, and move the cell with the mouse: A2 is also selected and nothing happens Also tried Shift, Ctrl+Shift, Alt+Ctrl, etc.: Doesn't work How can I drag and drop a cell with the mouse? As a temporary solution, I just Cut (Ctrl+X) and Paste (Ctrl+V). I read this, but I can't figure it out. http://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop Thank you. -- View this message in context: http://nabble.documentfoundation.org/3-4-4-Windows-How-to-move-cell-with-mouse-tp3650473p3650473.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
Gilles wrote: > I want to move cell A1 to A2 with the mouse: This is easy enough. You just select the cell, and then click-and-drag it - you don't need to press any keys on the keyboard. The trick is to actually *select* the cell. Try this: To move A1:A2 to B3:B4, simply select A1:A2 and click-and-drag A1:A2 to B3:B4. To move A1 to A2 (which was your original question), click on A1 (don't release the mouse button yet). Then drag the mouse down (or to the side) to select more than one cell (still don't release the mouse button). Then drag the mouse back to A1 (while still holding the mouse button). When the mouse is over A1, you can release the mouse button again. Now A1 is actually *selected*. You can now drag A1 to A2 (or wherever you wanted it). In the examples above, you could also use the keyboard to select the cell. To do this, hold down shift, press down, press up and release shift. Now you can drag the cell to wherever you want. Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
On Wed, 2012-01-11 at 04:45 -0800, Gilles wrote: > Hello, > > I want to move cell A1 to A2 with the mouse: > > I select A1, then press Alt, and move the cell with the mouse: Nothing > happens > > I select A1, then press Ctrl, and move the cell with the mouse: A2 is also > selected and nothing happens > > Also tried Shift, Ctrl+Shift, Alt+Ctrl, etc.: Doesn't work > > How can I drag and drop a cell with the mouse? > > As a temporary solution, I just Cut (Ctrl+X) and Paste (Ctrl+V). > > I read this, but I can't figure it out. > http://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop > > Thank you. > > -- > View this message in context: > http://nabble.documentfoundation.org/3-4-4-Windows-How-to-move-cell-with-mouse-tp3650473p3650473.html > Sent from the Users mailing list archive at Nabble.com. > I'm not sure you can move just one cell. Two or more cells can be moved by clicking on the first cell and then selecting the rest to the cells. Then this group of cells can be moved in the various ways that Help describes. If there is an empty cell adjacent to the cell you want to move, then you can move these two cells together. But that obviously has some draw backs. --Dan -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
On Wed, Jan 11, 2012 at 7:45 PM, Gilles wrote: > Hello, > > I want to move cell A1 to A2 with the mouse: > > This stumped me for ages, then I found the solution. 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. Click and hold to drag highlighted cell to new destination :-) -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/11/2012 11:09 AM, Alan Boba wrote: > On Wed, Jan 11, 2012 at 7:45 PM, Gilles > wrote: > >> Hello, >> >> I want to move cell A1 to A2 with the mouse: >> >> This stumped me for ages, then I found the solution. > > 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on > desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. > Click and hold to drag highlighted cell to new destination > > :-) > Using these instructions work for me as well. Fedora 16, LXDE, LO 3.4.4 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQIcBAEBAgAGBQJPDcHhAAoJEIefqZ0kni1dzQoP/idiBn7r8SKdr7EltudRoiYP m/Lt1+aLX1YiD14LQXN/wwvND+JKpceRgp4AnZyWWwM/iIqLbU7a8M8hAx1yj0n4 3j6uB2ntW5xzmymNaOTP8ReTn2LtHLYdVYD6RbvPadXUWCvAWl+S+JRHG6jT/FEn QksLDtIUwCHzRqhHeueXxk7zFL4gMQ1b+9Nzkq3Q0qPayyKAUVdE2ewR84soA7lG vkf7awmJV4vRzh+1VhpyLMdIEOYKljiEKVAqTK5sFgbZub17s3RqMVKOP0zL9hoB OFFqI9M9Po927D2DcdaxIbdNYF0vTdXJvV6PwLQil1oqRvFrPLQ2vSnX034DVK/J k/DJyhKz2EPEB6xXTt3JVoGVJzRI38zeqezuxP/kECDUU8Sq3fFnuWsMg/I0oMC9 W/1elUdOUeMcJV/qxc1C8qJZt2I4Z3SQHvyiTo60s585wRn2UO1h6mGkXhvUsFuE AUy5a72KffLzxAeETqMJWYHD09ytpUv7fvhgHNE1u1cHOi35hlugMgwQ8cphceYd jVchmkxg2VqaWcpyU+RPrFmbuEC58XRKT3CHE1/AtmNg6yhNuuXtHFd1zb2nKWIX imEelpqJlxYqdlbeV8UD3dIKXw9mcdtX9z23DLBMcR0ZJUz0EICJMXLz0zIVQuWy xuBmQ1HMEIvqrak0YmeE =nYY1 -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
On 01/11/2012 11:09 AM, Alan Boba wrote: On Wed, Jan 11, 2012 at 7:45 PM, Gilles wrote: Hello, I want to move cell A1 to A2 with the mouse: This stumped me for ages, then I found the solution. 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. Click and hold to drag highlighted cell to new destination :-) Hi, Works very well for me also. Now I've learned two new ways today!! :) Don -- ** -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
Hi :) Superb! 2 new ways for me too :) Many thanks and regards from Tom :) --- On Wed, 11/1/12, Don C. Myers wrote: From: Don C. Myers Subject: Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse? To: users@global.libreoffice.org Date: Wednesday, 11 January, 2012, 18:09 On 01/11/2012 11:09 AM, Alan Boba wrote: > On Wed, Jan 11, 2012 at 7:45 PM, Gilles wrote: > >> Hello, >> >> I want to move cell A1 to A2 with the mouse: >> >> This stumped me for ages, then I found the solution. > 1. Move cell pointer to desired cell > 2. Press Ctrl > 3. Click on desired cell (note: Click, not Click and hold) > 4. Release Ctrl > 5. Click and hold to drag highlighted cell to new destination > > :-) > Hi, Works very well for me also. Now I've learned two new ways today!! :) Don -- ** -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
Alan Boba wrote: > 1. Move cell pointer to desired cell > 2. Press Ctrl > 3. Click on desired cell (note: Click, not Click and hold) > 4. Release Ctrl > 5. Click and hold to drag highlighted cell to new destination I think this method is better than the one I described. Thanks for pointing it out. Just make sure not to skip step 1. Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?
Alan Boba wrote: > 1. Move cell pointer to desired cell > 2. Press Ctrl > 3. Click on desired cell (note: Click, not Click and hold) > 4. Release Ctrl > 5. Click and hold to drag highlighted cell to new destination For the sake of completeness, let me add that you could also use the Shift key instead of the Ctrl key. So then it would look like this: 1. Click on the cell you want to move 2. Shift+click on the same cell (hold shift, click on the cell, release shift) 3. Click and drag the cell to where you want it -- For unsubscribe instructions e-mail to: users+h...@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