View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Sorting problem- This operation requires...

It tells you never to use merged cells, in fact I am flabbergasted how many
people use merged cells. Unless you merge cells only as top headers it will
always come back to haunt you sooner or later. These newsgroups are full
with the ruins of merged cells and the regular contributors warning against
using merged cells. In fact I think it is so destructive that MS should
remove it
Best would be if you could unmerge the cells, you can get similar display by
for instance select the number of cells you normally would merge, then do
formatcellsalignment and select center across selection

--
Regards,

Peo Sjoblom


"ChrissySher" wrote in message
...
This operation requires...the merged cells to be identically sized

This statement comes up when I try to sort Alphabetically, what does this
pop-up mean??