Re: Use of the END key



On 03/10/2013 08:32 PM, Andreas Guelzow wrote:
On Sun, 2013-03-10 at 20:21 -0500, Jim Byrnes wrote:
On 03/10/2013 05:53 PM, marc dunord wrote:

For test purposes I have a sheet with cells A1,B1,H1 containing numbers
and C5 has a formula in it.

cntrl+right-arrow: go to rightmost filled cell

Does not go to H1. It just moves to B1. If I delete the the contents of
B1 then it will go to H1.  It seems that key combination skips over
blank cells to the next one occupied but does not simply  go to the last
occupied cell in the row.

These movement keys intentionally work within data blocks. So your
description is not quite correct:

ctrl-right-arrow skips over any number of occupied cells to the last
cell in the current data block. If you are already at the last cell of a
data block and there is more data further to the right it jumps to the
beginning of the next data-block. So if

A2,B2,C2,F2,G2,H2,K2 are occupied then starting at A2 it will jump to
C2, then F2, then H2, then K2.

Andreas


That's what I meant, you said it better. In the above scenario I am looking for the key combination that will jump directly to K2. This is what the END key does in LibreOffice.

Regards,  Jim




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]