Sorting problem

  • Thread starter Thread starter Ed Kearns
  • Start date Start date
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
 
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
Excel hyperlink problem after sorting 3
Excel Macro 4
Locate merged cells to sort on 3 columns 2
Problems sorting spreadsheet - Please Help 6
Sorting 3
Column widths in Excel 2013 16

Back
Top