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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"BarbMac" wrote in message
...
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.

"FSt1" wrote:

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

Regards
FSt1

"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?