Sorting with merged Cells

B

Bill

When I attempt to sort a section of a spreadsheet which
has columns containing merged cells and other columns not
containing merged cells, I get the message that you must
have all of the merged cells be the same size and it wont
let me sort. Is there a method for doing sorts with some
merged cells that will work on both EXCEL 97 and EXCEL
2002?
..
 
G

Gord Dibben

Bill

In my opinion, merged cells was one of the worst features put into Excel.
New users of Excel get themselves into much trouble with merged cells.

Great for presentations after all the sorting, filtering, copy/pasting is
complete, but not before.

My ususal quote "merged cells are the spawn of Satan!"

If you must use them, you will have to live with the limitations you are
experiencing.

Can you un-merge and use "center across selection" instead?

Is it possible to have your sort range below the merged cells?

Gord Dibben Excel MVP
 

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

Sharing workbooks limitations - Merged Cells 12
sorting two columns of merged cells 1
trying to sort excel data. won't allow. merged cells sizing.?? 2
Merging Cells and Sorting 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Count with merged cells 2
Trailing Spaces in Merged Cells 1
Sorting Rows 2

Top