View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
BarbMac BarbMac is offline
external usenet poster
 
Posts: 4
Default How can I sort an Excel Doc containing merged & non-merged cel

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?