Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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! ================================================== === "ED" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 On Thu, 24 May 2007 08:38:03 -0700, ED wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
getting msg: cannot sort merged cells not same size | Excel Discussion (Misc queries) | |||
Sort columns containing merged cells. | Excel Discussion (Misc queries) | |||
How to sort merged cells | Excel Worksheet Functions | |||
How to sort merged cells | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |