Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

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 <b.m.barker@btinternet.com> 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: users+help@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+help@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