Excel Sorting

[Lori]

I did not create the worksheet, but need to sort the data. Get a message
saying " This operation requires the merged cells to be identically sized"
An excell newby, and help doesn't help. Help??

 

[Gord Dibben]

Get rid of the merged cells which cause no end of problems.......one of
which you just encountered.

2003...........Format>Cells>Alignment>Uncheck "merge cells"

2007...........Home>Format>Format cells>Alignment.

Or Home>Alignment section>Open Merge dropdown and "Unmerge cells"


Gord Dibben MS Excel MVP

 

[Gary Brown]

Your headings probably have merged cells.
You can either...
- take the merge off the cells (FORMAT > CELLS > ALIGNMENT > click off the
'Merge Cells' checkbox)
or
- do your sort without the headings rows (DATA > SORT > click on 'No Header
Row').