Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got a sheet from someone else. In trying to sort, I get the error message
"merged cells must be identically sized". How can I sort?
 
You need to unmerge the cells. In general, you should avoid
merged cells if at all possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I have been following the threads on the subject of Sorting Merged Cells. My
file is strictly a database in which I do NOT utilize the merge fields option
at all. But today, after having successfully sorted once, I am now getting
the message "This operation requires the merged fields to be identically
sized".

Question: How does one determine the cells that are set as merged fields and
secondly, how to you "unmerge" them?

Thanks,

Jim
 
You must log in or register to reply here.

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

Locate merged cells to sort on 3 columns 2
Excel Sorting 2
Keeping Rows Together 1
sorting 1
How I sort data in Excel, it keeps saying "merged cells must be ID 2
Sorting problem- This operation requires... 2
How to sort merged cells 3
error when sorting 1

Back
Top