Selecting a single column expands selection to span of merged cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeroen - 28 Jan 2008 13:08 GMT

When selecting a single column, the selection expands to the span of a merged
cell in that column. I cannot duplicate this behaviour on other Excel
installations, we're using Excel 2003 SP2. Spent a morning googling for a
solution but did not succeed. Help me guys, you're my last resort...

-Jeroen

Reply to this Message

Dave Peterson - 28 Jan 2008 14:25 GMT

I can duplicate that in xl2003 SP3 if I do it via code.

But I can't duplicate it if I do it manually.

You want to share the address of the merged cells and the column that you're
selecting--and how you're selecting it.

But each version of excel seems to behave differently with merged cells. IIRC,
xl97 did expand the selection to include those merged columns when trying to
select a single column manually.

> When selecting a single column, the selection expands to the span of a merged
> cell in that column. I cannot duplicate this behaviour on other Excel
> installations, we're using Excel 2003 SP2. Spent a morning googling for a
> solution but did not succeed. Help me guys, you're my last resort...
>
> -Jeroen

Signature

Dave Peterson

Reply to this Message