Hi Saurabh, and thank you for the suggestion, but I don't think that is the setting. It is probably because I was in a rush to post the question from work before I finished. I kept getting interrupted and perhaps didn't explian myself too well.
What I was trying to say is that where I used to arrow left, right, up, and down, the selected cell would respond to that exactly. In other words, if I pressed the right arrow when in cell A1, it would move to select B1, and pressing the down arrow, it would move to select B2, and so on.
Now when I press the arrow keys, the actual page moves, but the cell I had selected stays as the selected cell. Hmmm. How do I describe this? I don't have software installed to capture screen events to video, so I'll have to explain it. I am at home now and at my own PC which behaves normally, so I'm going by memory.
OK, so say I have B1 selected and arrow right. Column A disappears off the left of the Excel window with Column B now the leftmost column. If I have cell C3 selected, and arrow down once, cell C3 stays selected and the page moves up so that Row 1 is now above the viewing area of the page and row 2 is now the topmost column. It's almost like dragging the screen display of a PDF file around in Adobe Acrobat Reader with the hand icon, except that this is being done with the keys in Excel.
I've looked at all my Tools > Options in my own Excel 2003, just in case some user options were hidden on my work PC, but I can't see an option that controls what the arrow keys do.
Any ideas?
Main Topics
Browse All Topics
by: saurabh726Posted on 2008-10-08 at 00:06:12ID: 22666749
I believe this is what you meant
go to tools-->Options-->Internatio
Saurabh...