error message: merged cells must be same size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buckskin - 15 May 2006 15:02 GMT

scanned part and entered part of contact list alpha in Excel 2002. Need to
sort by state which is separate column. Keep getting error message: merged
cells must be same size. Can't see any difference. How to find out what
cells are different? Or is there a different way to sort this list than
using the "Sort" function?

Thanks!

Reply to this Message

Duke Carey - 15 May 2006 19:15 GMT

Somewhere in the data you have a merged cell.

Work on a copy of the data. Select the data and use
Format->Cells->Alignment and uncehck the Merge Cells checkbox. Then you'll
be able to sort

> scanned part and entered part of contact list alpha in Excel 2002. Need to
> sort by state which is separate column. Keep getting error message: merged
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message

Buckskin - 16 May 2006 15:35 GMT

Thanks, Duke. Your advice worked like a charm. Much obliged.

> Somewhere in the data you have a merged cell.
>
[quoted text clipped - 9 lines]
> >
> > Thanks!

Reply to this Message