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

Merging cells will cause loss of data.


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 06:41:01 -0700, BarbMac
wrote:

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" wrote:

You can't.

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


Gord Dibben MS Excel MVP

On Thu, 8 May 2008 05:59:01 -0700, KellyH
wrote:

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?