Sort ascending requires merged cells to be the same size.

P

Peterbrum

The list of names that I tried to sort does not have any merged cells.
Please tell me what might be wrong.
 
J

Joel

You must have merged cells. Select a worksheet range object (like a column,
row, or entire sheet) then go to menu - Format - Cells - Allignment and
unclick the Merged Cell box.
 
G

Gord Dibben

You've got some merged cells somewhere in the range.

Re-check.


Gord Dibben MS Excel MVP
 
Top