strange scrolling in Excel 2003
 

I have a protected worksheet on which users cannot "select locked cells."
However, with this protection on, the keyboard arrow keys now scroll through
the far left and top of the worksheet - hitting up in row 1 takes you to the
last row - hitting left in column A takes you to the last column. How can I
stop this?

I tried this in xl2002 and could only duplicate it if the lastrow (65536) was
unlocked.

(Did you mean last row of the worksheet or last row of the unlocked cells?)

If you meant that excel took you to the "next" available cell, then this seems
like a pretty good design choice to make data entry easier. (My guess, anyway.)



Ryan wrote:

I have a protected worksheet on which users cannot "select locked cells."
However, with this protection on, the keyboard arrow keys now scroll through
the far left and top of the worksheet - hitting up in row 1 takes you to the
last row - hitting left in column A takes you to the last column. How can I
stop this?

--

Dave Peterson