unable to sort

[vallerose]

i have been working on a large database and suddenly I get a message
saying: unable to sort because operation requires merged files need to
be identically sized. I have no idea what this means. I can sort parts
of the file but not the whole thing so somewhere a piece is corrupted
or something. The database has 7 columns and 8208 rows. Any clue is
appreciated.
Vallery Feldman

 

[JE McGimpsey]

i have been working on a large database and suddenly I get a message
saying: unable to sort because operation requires merged files need to
be identically sized. I have no idea what this means. I can sort parts
of the file but not the whole thing so somewhere a piece is corrupted
or something. The database has 7 columns and 8208 rows. Any clue is
appreciated.

I suspect it really says the merged *cells* need to be identically
sized...

This is one of the reasons that merged cells are nearly always a bad
idea. Find the merged cells and unmerge them in order to sort...

 

[vallerose]

(e-mail address removed) wrote:

Thank you for your reply. At the risk of sounding stupid. What is a
merged cell and how do I find it. Since the original database was in a
mess, straightening it out is requiring using a few Excel formulas. I
have used the concatenation formula. Is this the problem? I have used
this before for other databases and didn't have problems. Thanks again,
Vallery Feldman

 

[JE McGimpsey]

Thank you for your reply. At the risk of sounding stupid. What is a
merged cell and how do I find it. Since the original database was in a
mess, straightening it out is requiring using a few Excel formulas. I
have used the concatenation formula. Is this the problem? I have used
this before for other databases and didn't have problems. Thanks again,
Vallery Feldman

From XL Help:

merged cell
A single cell created by combining two or more selected cells. The cell
reference for a merged cell is the upper-left cell in the original
selected range.

For more, see the "Merge or split cells that span several columns or
rows" topic in XL Help.

 

[Willis Eschenbach]

The only stupid questions are the ones you don't ask.

To convert merged cells:

Go to the menu item "Format/Cells

Go to the tab called "Alignment", and uncheck the bottom checkbox.

w.