Trying to sort by row and getting errors.

  • Thread starter Thread starter joe54345
  • Start date Start date
J

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?
 
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
 
Back
Top