Tabbing through Unlocked Cells - Sheet won't scroll

[carat37]

I'm working with a collection of worksheets which, ideally, will be protected with the user tabbing through a number of unlocked cells. What's driving me nuts, is that on the worksheets whose length is more than one screen, tabbing through unlocked cells stops at the last unlocked cell at the bottom of the screen, NOT at the last unlocked cell of the worksheet. In order to get to the rest of the unlocked cells, the user has to page down and select the first one, and can then tab through to the end.

I'm worried that users won't know they need to do this, and will miss the bottom entries.

Is there something I'm not setting correctly?

Thanks!

-Tara

[Bryan Hessey]

I'm working with a collection of worksheets which, ideally, will be protected with the user tabbing through a number of unlocked cells. What's driving me nuts, is that on the worksheets whose length is more than one screen, tabbing through unlocked cells stops at the last unlocked cell at the bottom of the screen, NOT at the last unlocked cell of the worksheet. In order to get to the rest of the unlocked cells, the user has to page down and select the first one, and can then tab through to the end.

I'm worried that users won't know they need to do this, and will miss the bottom entries.

Is there something I'm not setting correctly?

Thanks!

-Tara

Hi,

it (of course) should scroll, but, are your 'unlocked' cells in varied columns such that from column C it tabs to the top and misses further rows in columns G & J?

I usually have an extra unlocked cell top left and bottom right to clearly show the extent of the fields, and of the layout, available.

Can you post a sample sheet (excluding your data)

hth
---