View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default ENTER skips unlocked cells

On Wed, 4 Feb 2009 11:14:20 +0900, "Joerg Mochikun"
wrote:

Make sure that Tools|Options|Edit "Move selection after enter'" is not
checked or is set to "Right"


Thank you, it was set to "Down" and changing it to "Right" or
uncecking did solve the problem when using the "ENTER" key.

But I do a couple of further questions for the net experts:

- The arrow keys still skip some of the unlocked cells

- Before changing the option I would have thought the ENTER key would
have sequenced through the cells correctly due to their locations.

The unlocked cells in question a

B14
B16
B18
B20
B22
B25 C25 D25

When the ENTER key (or still the down arrow key) are pressed the
selected cell would go fro B14 to D25.

Any gurus out there to provide further insight???


John Keith