strange scrolling in Excel 2003

G

Guest

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?
 
D

Dave Peterson

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

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

Top