How can I sort an Excel Doc containing merged & non-merged cells?

[KellyH]

I have a doc that contains both merged and unmerged cells and need to be able
to sort it alphabetically. When I try, I get a message saying that all
merged cells need to be sized identically. I have tried resizing the cells,
but this does not solve the problem. Any suggestions?

 

[FSt1]

hi
might be best to get rid of the merged cells.

Regards
FSt1

 

[Gord Dibben]

You can't.

Get rid of those merged cells that cause so many problems.


Gord Dibben MS Excel MVP

 

[Jon Peltier]

It doesn't mean height and width of the cells, it means number of rows and
columns of cells in a merged cell. I'll be the third to say, get rid of the
merged cells. They cause more problems than this.

- Jon

 

[BarbMac]

Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells
until I had entered ALL the data and tried to sort.

 

[BarbMac]

Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells
until I had entered ALL the data and tried to sort.

 

[BarbMac]

Getting rid of merged cells causes you to lose data. I am using a template
and didn't merge any cells. didn't even know there were any merged cells
until I had entered ALL the data and tried to sort.

 

[Gord Dibben]

Getting rid of merged cells does NOT cause any loss of data.

Merging cells will cause loss of data.


Gord Dibben MS Excel MVP

 

[Jon Peltier]

No, merging cells causes loss of data. Unmerging cells puts blank cells
where you hadn't noticed them before.

- Jon

 

[Jon Peltier]

What data did you lose by unmerging cells? It doesn't work that way. The
data in a merged cell will be retained in the top left cell of the unmerged
cells that had been merged.

- Jon

 

[BarbMac]

I unmerged and tried to sort. It put my totals in the middle of the page.

 

[Jon Peltier]

Then you have to select the exact range to sort, without including header
row and total row.

- Jon