Sorting

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?
 
C

Chip Pearson

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
 
G

Guest

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
 

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

Excel Sorting 2
Locate merged cells to sort on 3 columns 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
Sorting data in excel 1

Top