Arrow Keys not Working Properly

Hi,

I'm looking at a worksheet right now where data has been added in a chart form. In between some of the columns are several hidden columns. For some reason, whenever I arrow right or left, it moves two columns over instead of one. For example, lets say columns B,C,E,F were hidden, and I was in column G. If I hit the left arrow button, it moves to column A instead of D! Am I doing something wrong? Is there a way to fix this? Thanks in advance for your help.

Could it be that that is one of the purposes of hiding??

--
Don Guillett
SalesAid Software
[email protected]
"Raman325" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I'm looking at a worksheet right now where data has been added in a
> chart form. In between some of the columns are several hidden columns.
> For some reason, whenever I arrow right or left, it moves two columns
> over instead of one. For example, lets say columns B,C,E,F were hidden,
> and I was in column G. If I hit the left arrow button, it moves to
> column A instead of D! Am I doing something wrong? Is there a way to
> fix this? Thanks in advance for your help.
>
>
> --
> Raman325
> ------------------------------------------------------------------------
> Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
> View this thread: http://www.excelforum.com/showthread...hreadid=396463
>

Well, the columns that are hidden should definitely be skipped, but column D was unhidden and was skipped over as well.

I just tried with my xl2002 and it didn't skip col d.
Try leaving Excel and coming back...

--
Don Guillett
SalesAid Software
[email protected]
"Raman325" <[email protected]> wrote in
message news:[email protected]...
>
> Well, the columns that are hidden should definitely be skipped, but
> column D was unhidden and was skipped over as well.
>
>
> --
> Raman325
> ------------------------------------------------------------------------
> Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
> View this thread: http://www.excelforum.com/showthread...hreadid=396463
>

I tried that. I also tried rebooting my computer, and that didn't work either. It only occurs in certain rows that have a different color index but that shouldn't matter. Is there a way to define the sequence of selection in a given row? Maybe I somehow need to reset that.