sort cells copied from different spread sheets

M

madmat

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

after copying cells from 5 different word data bases into excel i am unable to sort the combined list and get the message: "this operation requires the merged cells to be identically sized". i've changed the font to the same size, verified that the columns are identical but am still unable to sort the data. any ideas?
 
Top