Sort - Merged cells

[Guest]

I am trying to sort my sales table, it doen't seem to work for me. A
comment comes up: this operation requires the merged cells to be idendically
sized. Can you help? Thanks

 

[RagDyeR]

Easiest way is to *unmerge* the cells, and then use "Center Across
Selection" instead.

<Format> <Cells> <Alignment> tab,
And expand the "Horizontal" window, and choose,
"Center Across Selection"

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am trying to sort my sales table, it doen't seem to work for me. A
comment comes up: this operation requires the merged cells to be
idendically
sized. Can you help? Thanks

 

[Gord Dibben]

ED

If all the merged cells are the same size..........no problem.

If varying sizes, you can't sort.

You must unmerge the cells before sorting.


Gord Dibben MS Excel MVP