Scrolling through cells

[alice]

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

 

[Niek Otten]

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.


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

 

[Gord Dibben]

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