Scrolling through cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alice - 29 Nov 2007 17:39 GMT

I'm having trouble scrolling through the cells using the arrows. When I was
typing in a cell I used to be able to press one of the arrow keys and it
would automatically go to the next cell. Now when I press the arrow key is
sticks the next cell in as part of a formula. I'm not sure what's happened
to change this. Can anyone help????

thanks :)

Reply to this Message

Niek Otten - 29 Nov 2007 19:33 GMT

You are probably in Extend mode. This happens when you press F8. It shows "EXT" in the Status bar (to the right)
Press F8 again to deactivate this.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm having trouble scrolling through the cells using the arrows. When I was
| typing in a cell I used to be able to press one of the arrow keys and it
[quoted text clipped - 3 lines]
|
| thanks :)

Reply to this Message

Gord Dibben - 29 Nov 2007 22:33 GMT

This is default behaviour when in "Edit" mode.

You will see "Edit" on status bar.

Touching an arrow key will select the next cell and add it to your formula or
whatever.

Start typing then hit F2 and you will go into "Enter" mode.

Now an arrow touch will move you out of the cell.

Gord Dibben MS Excel MVP

>I'm having trouble scrolling through the cells using the arrows. When I was
>typing in a cell I used to be able to press one of the arrow keys and it
[quoted text clipped - 3 lines]
>
>thanks :)

Reply to this Message