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

JE McGimpsey

Bill said:
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?

Note that this is a Mac newsgroup, so XL97 and XL02 questions may be
more appropriate in the microsoft.public.excel.* groups.

However, the behavior here is the same for Mac or WinXL. The only way I
know to do it automatically is to unmerge and remerge using VBA.

This underscores why I think that Merge Cells is the spawn of Satan and
should never under any circumstances be inflicted upon a worksheet.
 

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

Top