Trying to sort by row and getting errors.

[joe54345]

I'm trying to do a simple sort by rows instead of columns and every
time I try to do it I get this message:


This operation requires merged cells to be identically sized.

What am I doing wrong?

 

[Gord Dibben]

First of all, select all cells then Format>Cells>Alignment.

Click the "merge cells" option a couple of times to clear it.

Now try your sort.

Merged cells cause many problems and are very rarely necessary.

Use Center Across Selection instead.


Gord Dibben MS Excel MVP

 

[joe54345]

Thanks Gord, that worked