Sorting problem

E

Ed Kearns

I've got 3 columns I want to sort based on the middle column, something I've
done many times. When I try to sort on this particular spreadsheet, I get an
error message I've never seen: "This operation requires merged cells to be
identically sized."

I don't have any merged cells. I tried copying these columns to a new
spreadsheet, got same error message.

I'm using an iMac, os X, and Excel (for the Mac) 2004, v. 11.3.7.

Thoughts, anyone?

Ed
 
P

Pete_UK

Highlight all the cells in the sort range and Format | Cells |
Alignment tab and ensure that Merge Cells is completely empty (it may
show a grey tick - if so, click on this twice to remove it).

Hope this helps.

Pete
 

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

Sorting Range that Contains Merged Cells 1
problems with data sort 3
problem sorting data, says "this operatioin requires merged cells to be identically sized" 2
trying to sort excel data. won't allow. merged cells sizing.?? 2
Locate merged cells to sort on 3 columns 2
Sorting Rows 2
Excel Sorting 2
sorting problems - error message: identically sized merged cells. 2

Top