I solved my problem in another but simple way, finally. It would still be handy to have a shortcut to column start though...
I made a Macro that moves the current row up (and another one to go down). And i have a handy shortcut to use it. Step by step, it does: - select current row: Shift+Space - copy: Ctrl+C - delete current row: Ctrl + "-" - move up: up arrow - insert row: Shift+Space, Ctrl + "+" - go to line beginning and copy: Home, Ctrl+C DONE! Intructions for use: Record this Macro, make a customized shortcut for it (in Tools->Customize->Keyboard). It's extremely convenient for me. I hope it helps someone else. To do the same thing for moving columns around, i thought that i needed to go to the first cell of the column, for the last step. In fact i didn't. Same for the "move_row_up" macro that i just presented: there is no need to press "Home" at the last step of the macro. And it's even better without the "Home" in the sequence! Then you can also add this in the end: - unselect row: down arrow, up arrow And the selected cell remains the same as it was initially. On 27 February 2013 11:26, Brian Barker <[email protected]> wrote: > At 09:39 27/02/2013 +0000, Pierre Masci wrote: >> >> Hello, with "Home" i can move to the start of the current row. How can i >> do the same thing with a column? > > > I don't know that you can. But Ctrl+up-arrow may help. If the cell > immediately above is occupied, this moves to the top of the current block of > data. If it is not, this moves to the nearest cell (that is, the lowest) in > the next contiguous block of data in the column. So repeated use of > Ctrl+up-arrow will get you to the top of the column. This will work easily > if most cells in your spreadsheet are occupied, but will be pretty useless > with sparse data. > > Note that you can move about in similar ways using combinations of Ctrl plus > the other three arrow keys. > > I trust this helps. > > Brian Barker > > > -- > For unsubscribe instructions 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 > -- For unsubscribe instructions 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
