Excel sorting

R

RobinLind

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When trying to sort a large bibliography I get the message "This operation requires cells to be identically sized"
How is that done?
I have failed in all attempts to format the cells,

Thanks in advance.
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When trying to sort a large bibliography I get the message "This operation
requires cells to be identically sized"
How is that done?
I have failed in all attempts to format the cells,
Click to expand...

You've got merged cells somewhere in the column you're sorting (most
common is the top row).

Merged cells are the spawn of the devil. Friends don't let friends use
merged cells. They're just plain bad.

Unmerge the cells and try the sort again.
 
J

JE McGimpsey

Still no luck. Any way to find or identify merged cells?
Click to expand...

One quick way:

Select the one column. The highlight color will fill all the selected
cells (except the active cell). Look for highlighting outside the
selected column.
 
Top