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

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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Raman325" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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, bu
column D was unhidden and was skipped over as well

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=39646

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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Raman325" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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.


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=396463