Selecting a single column expands selection to span of merged cell

  • Thread starter Thread starter Jeroen
  • Start date Start date
J

Jeroen

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding merged cells 3
Unmerging and populating merged cells by column 3
How can I merge data from multiple columns into a single column in Microsoft Excel? 0
Possible to select a string in a locked cell? 1
copy a column of single cells into a column of merged cells 3
Merge column into a single cell 2
Complex Question on Filtering on a merged column 1
Expand selection 6

Back
Top