Arrow key issue

[jimi11x]

I use excel 2003 at my place of work and and currently experiencing this problem which only happens on some of the pc's at work others are ok.
If I select a cell e.g. [A1] and type for example 'h' then navigate using the arrow keys right it fills in cell [A1] as follows 'h+a2+a3+a4' instead of just selecting the next cell [A2]
Anybody have any ideas of what's happening.
I think some switch my have been activated but I don't know what.
Many Thanks in advance.

 

[kpark91]

I'm not too sure what your problem is in the first place.
But from my interpretation, you might have EXTEND option on.
Press F8 to toggle it off.

 

[jimi11x]

Problem is I have created a sheet for users to enter data using a key.
E.g. A=apple B=banana c=carrot
if you select cell {a1} on the sheet and enter 'B'{for banana} then press right arrow to select the next cell to enter the next value, instead of selecting the cell ready for input cell{a1} will show 'B+a2' instead.
So the problem is if the sheet is used by a novice it will cause confusion.
The thing I cant understand is that I'm finding it hard to replicate on my home pc.
P.S. I've tried F8 but no joy.
P.P.S. If after typing 'B' I press enter or TAB no problem, but when I try the arrow keys it won't select the next cell.

 

[shg]

Use the TAB key to move right.

 

[jimi11x]

As the sheet is very large using the tab key is not an option.
The user needs to be able to move around the sheet using the arrow keys.
I'm sure it is something that has been turned on which is causing the issue, as stated the arrow keys need to be used as making over 200 entries I at any one time using the mouse is not ideal.

 

[kpark91]

Hmm. This is a weird problem indeed xD
Try checking your code if you have any sendkeys for the arrow keys and commenting them out.

 

[wigi]

Or Worksheet_SelectionChange event code that runs in the background, in any possible file.

 

[jimi11x]

I don't think its an issue with the sheet as it works fine on other workstations.
I think it has something to do with the way excel is set-up on the individual machines.

The problem I have is that I am unable to duplicate the problem on any other machine to start to troubleshoot it.

Which takes me back to the first point is it an option or something that has been selected on the machines that I'm having problems with.

I'm stumped as I've never come across this issue before and cant find it on any other forum.

 

[wigi]

I would tend to think it's not a setting anywhere (I never saw this before).
Maybe reinstalling Excel/Office will help?

 

[jimi11x]

Office is running on a server in a different location.
Access is gained through thin clients and virtual desktops on PC's.
So reinstalling is not an option.
Like I said if this is only happening on selected workstations and pc's it must be something to do with the way excel is set-up or some sort of add in which is causing the problem.
Out of 14 thin clients and 4 PC's the problem is only occurring on 3 thin clients and 1 PC.