So all of a sudden when i press num lock i can no longer use my arrow keys. Excel all of a sudden decided to force me to press the numlock button in order to use my numpad but when it is pressed the arrow keys wont move cells. instead the left arrow keys shoots me selected cell all the way to the left and the right key moves me one cell up.
IT is not a scroll lock problem.
the num pad works perfectly when numlock is on and the arrow keys work perfectly when the num lock is off.