In general, it's helpful to include your XL and MacOS version when youI am trying to do a sort on a very simple (nor formulas) 5-column worksheet.
Each time I go through the "sort" process I get a message that ways "the
operation requires the merged cells to be identically sized. I have no merged
cells that I am aware of. I expanded my column width and I still get the same
message. What am I missing on this one?
You find them by clicking on the suspects and see if the cell outline coversI have the same problem as taraporter. My office computer has Mac OSX 10.4.11
and Excell 2004 11.0.
A couple of years ago I started a 4 column alphabetical list of closed files.
I updated the list today and when I attempted to sort I got the message "this
operation requires the merged cells to be identically sized"
I believe I did merge cells. Column D (labeled "additional information") was
the widest of my columns and somehow it had become columns D through G, even
though the written information spanned all those columns and wasn't partially
hidden, as happens when you write more than can fit into the width of the
column. The only way to tell that there were more columns is that my
"additional information" column had faint blue vertical lines through the
writing, and there were extra column letters shown at the top.
The faint lines through my writing annoyed me, so I changed column widths
until I "pushed" the extra columns off the page. Then when I tried to sort my
list I got the "merged cells" message. (I don't know how to say things
technically, I just know what I see.)
Now what do I do? How do I "unmerge" the cells so I can get my list
alphabetized? J.E. McGimpsey says to look for merged cells, but how do I find
them and fix them?
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.
|identically sizing cells||1|
|UNABLE TO DATA SORT DUE TO CELL SIZE VARYING||3|
|Highlight a cell past a specified "due date"||1|
|Error message: operation can only be performed if the column sizes are identical||1|
|Cell identity when printing comments on separate page||3|
|Calculating balance due on a loan||1|
|2 identical copies opening in Excel||1|
|Summing up identical worksheets with multiple rows and columns into one.||0|