Excel - Arrow Keys Move Whole Sheet Instead Of From Cell To Cell

I have Excell 2007, and when I try to move from one cell to another using the arrow keys on the keyboard, it moves the sliders on the side and bottom of the worksheet and move the entire thing, much like a web page moves.

How do I change that? It's frustrating having to use the mouse to navigate throughout the workbook when the keyboard is much faster.

I've always been able to do this before (moving to a different cell in a spreadsheet by using the arrow keys), but for some reason, now when I use the arrow keys, it stays in the cell I'm on, but it's using the scrolling bar at the bottom/side.

Is there any way to get this back to what it was?

Thanks,
K

One of the guys I work with has an interesting Excel navigation problem. When he uses the arrow keys to move up or over to a new cell, the entire worksheet moves, rather the cursor moving into the next cell. Does anyone have any ideas why this came to be? (even better, how to fix it? I recommended the Detect and Repair...)

I am using Excel 2000 and I am having a problem. When I press one of the arrow keys, instead of moving the selection to the cell I want, it moves the whole sheet one column or one row, depending which direction key I have pressed. The selection remains locked in that cell and the whole worksheet moves. I am currently having to navigate around the worksheets with the mouse and really miss the use of the cursor keys.

The scroll lock is not enabled, nor the numlock. I have tried another keyboard in case the control key might have had some bizarre problem. I do not have the Lotus 1-2-3 box ticked or any other of the options which might affect it. I conclude that I have somehow hit a selection of keys which has modfied the basic worksheet template in some way - or have I found a new bug?

It affects all the worksheets I have, including all the ones created before this problem appeared about 10 days ago. I have re-installed Office with no effect.

Any suggestions will be gratefully received.

I've got a worksheet with 10 unlocked cells in a column, all other cells on the sheet are locked and the sheet is protected. Only the unlocked cells can be selected.

Clicking in the top most cell (row 1) allows me to select that cell.
Pressing TAB or ENTER will move the cursor down one row at a time and from row 10 put me back in row one. That works fine.

However, clicking in the top most cell and pressing the down arrow on the keyboard will move the cursor down one row only 3 times. At row 4 pressing the down arrow will move the cursor to row 3 (up).

Clicking in row 5 and pressing the down arrow will move the cursor to row 6, 7, 8, etc, however pressing the down arrow from row 10 will not move the cursor to row 1 as TAB does, but to row 3.

um.......what have I done here?

Hello,
While in a Excel document,the arrow keys move wintin the page but not from
cell to cell.

How do I get the cursor to move from cell to cell instead of up and down the
spreadsheet by using the arrow keys?

Thanks for your assistance.

Janet

I have a userform containing various commandbuttons, which when clicked insert formatted text into the active cell. What i am trying to achieve is to be able to click a commandbutton and then use the keyboard arrow keys t move to a different cell without using the mouse. The problem is the userform has the focus or remains the active window, using the arrow keys simply moves around different commandbuttons. If anyone can help please.

Somehow the settings on my copy of excel (2000) changed. When I use the arrow keys the active cell does not move. Instead the whole window moves up-down-left-right. I went through the options under tools and can't find anywhere I can change this.

Any help will be appreciated.

I am having a problem that I cannot move around in excel 2002 with the arrow keys on the keyboard. I am using a computer that is new to me and I am not sure what the previous person has set up/done to excel!!!

If I try and move using these keys nothing happens.

I am able to use the mouse to move to different cells but this is so time consuming.

Has anyone come across this before?

Any advice on rectifying this would be most appreciated,

Thanks in advance,


Mark

I protected my worksheet so only 5 rows can be edited by the end user, however, after I protect the sheet I can only move the cursor to the right and left with the arrow keys. It will not move up or down, with the arrow keys or hitting enter. I have to be missing something simple because it works like normal when I unprotect the worksheet. Help please!
Mike

This will seem ridiculously simple to most Excel users here, but I always forget what to do when this happens and how to stop it from happening in the first place. Anyway, for some reason I can only use the mouse to move from one cell to the other, when I try the arrow keys it just scrolls in the direction of the arrow. Could someone tell me how to fix this?

Hi,

Images and shapes etc I can move around using the keyboard keys (left, up, down, right arrow keys etc).

However when trying to do the same with charts it just selects the different parts within the chart. I've tried to hold in CTRL + arrow key etc. But nothing seem to work.

Can anyone help? Please don't tell me it isn't possible...

I seem to be stuck on a funny setting where I can not move to select a new cell (up, down, left or right) with the arrow keys. When I press an arrow key on my keyboard it has the same effect as clicking the scroll arrows on the scroll bars. It's driving me crazy! Can someone please help?!

Mark

Hello. I am having some problems with my arrow keys. When I came into work this morning on my excel spreadsheet the arrow keys move the entire spreadsheet up and down, instead of just moving from cell to cell. How do I change this setting? Please help! Thanks!

Hello all,
I know this is a sooo basic question but I can not for the life of me remember how.....
when I am on a excel sheet I can not seem to move from quare to square qiththe arrow keys.
It just now takes me all the way to the left or all the way to the right and not from cell to cell from left to right.

I know its something rather simple yet I can not seem to figure this out.
I have no problem with this on 2003pro.

I have 2000 at work and trying to get this sheet back to normal any help would be wonderful.
Thank you,

I am running Excel 2007, I'm sure that usually when I press the arrow keys on my keyboard, the resulting action is that the cell focus moves on square in the direction that I have pressed.

But now when I try and use the arrow keys to move between cells, the action is to scroll the screen in the direction pressed.

Either I'm going mad or this did not happen before (its been a while since I used excel)

any ideas?

cheers,

Tom

For no apparent reason, the arrow keys on my keyboard have stopped moving
from cell to cell when I press them. Instead, pressing an arrow key causes
the whole worksheet to scroll in the direction of the arrow

Hi, I'm used to using an earlier version of Excel and the 2003 version
doesn't allow me to use the arrow keys to move around the cells in the
worksheet, is there a setting that I can change that does allow me to move
from cell to cell with the arrow keys rather than use just the mouse?

Thanks.

My arrows keys move the workbook page in Excel 2000 instead of moving from
cell to cell. How can I change the settings so that the arrow keys move cell
to cell?

Hi, (using Excel 2003)

if you are in the "refers to" field of named ranges (ctrl+f3), you cannot cycle through the formula using the arrow keys

if you try, you keep changing the cells which are being refered to (because the arrow keys act outside the window, in the active sheet)

Is there a way to move around in the refers to field using the arrow keys (instead of the mouse which because annoying once the formular is sufficiently long)?

(this behaviour can be observed in a number of similar input fields, too)

hope someone can comprehend my problem

regards