Sort - Merged cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top