moving to the next cell problem

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

I have a problem moving to the next cell using the arrow
to the right button, and i can use the left arrow key to
move back. Can anyone help it was just working a while
ago, is there some option i need to reclick?
 
no the problem is that i cant move right and left with the
arrow buttons but i can with tab
 
Did you just edit some data in the cell? If so, then you need to tell Excel
you are done with that cell before it will move. Enter and Tab will do
this. If you are still in edit mode (you either double-clicked the cell or
moved p to the formula bar and made some changes to the cell), the the right
and left arrows keys will only move you inside the cell.

Ed
 
Just to add to what Ed wrote. If you look at the statusbar (lower left corner),
you'll see either Edit or Enter (when you're changing a cell).

You can toggle between edit/Enter with the F2 key.
 
Back
Top