Jump over 10 cells in a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top