Jump over 10 cells in a row

K

katiekay

Hi,
If A1=1, the next 10 cells fill with 88. How can I jump to the 11th cell? I
tried highlighting the 10, Ctrl 1, unlocking & protecting, but that takes me
down to the next row. Ideas?
Thank you.
 
R

RagDyer

Don't quite understand exactly where you're trying to go.

Is the cell you want to "jump" to empty?

If so, this will get you right *next* to it.
Try selecting A1.
Hover the cursor over *that* border of the selection in the direction that
you wish to "jump", until the cursor changes to an arrow.

Double click, and you'll jumpt to the last cell of contiguous data.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,
If A1=1, the next 10 cells fill with 88. How can I jump to the 11th cell? I
tried highlighting the 10, Ctrl 1, unlocking & protecting, but that takes me
down to the next row. Ideas?
Thank you.
 
Top