Prev: Copy and paste to the last row
Next: make 2003 default version
From: Vote America! Vote on 6 May 2010 22:36
What makes the cursor automatically jump from one cell to another in Excel
when trying to change/enter either new/different alphabetical or numerical
data? The data entered can't be seen on the screen in the first or last
cell. I don't recall changing anything in the file (other than saving it)
the last time I had used it. I've developed my own file to calculate my
checkbook for a couple of years and whatever happened appears to have
happened to both that file and another in which I'm keeping home/personal
expense records. The problem seems to affect even new files I've opened
because no new data can be entered in certain rows/columns--the cursor just
goes to the next cell or several cells to the right.
From: Simon Lloyd on 9 May 2010 02:37

It sounds like your personal.xls has either some code in it or options
have been set, look at your personal.xls and check the VBE to see if
there is any code, secondly make sure there are no protected sheets or
custom views.


V
o
t
e

A
m
e
r
i
c
a
!
;
7
1
8
7
9
4

W
r
o
t
e
:


>
What makes the cursor automatically jump from one cell to another in
Excel
when trying to change/enter either new/different alphabetical or
numerical
data? The data entered can't be seen on the screen in the first or last
cell. I don't recall changing anything in the file (other than saving
it)
the last time I had used it. I've developed my own file to calculate my
checkbook for a couple of years and whatever happened appears to have
happened to both that file and another in which I'm keeping
home/personal
expense records. The problem seems to affect even new files I've opened
because no new data can be entered in certain rows/columns--the cursor
just
goes to the next cell or several cells to the right.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=201250

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Copy and paste to the last row
Next: make 2003 default version