data sort error :this operation requires the merged cells to be i.

N

Nick Hodge

Deanna

Unfortunately, you can do little with ranges with merged cells. What the
error means is they cannot be merged effectively. If you look at a merged
cell although it looks like many cells (width) it is actually only the cell
top left. That means in is 'not the same size' as the other cells in that
row.

In short, you will have to un-merge

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Operation requires the merged cells to be identically sized 2
excel sorting error 1
Sorting Range that Contains Merged Cells 1
Help with copying merged cells 2
Locate merged cells to sort on 3 columns 2
sorting problems - error message: identically sized merged cells. 2
Excel Sorting 2
Error in Excel Sort 1

Top