View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Excel 07 Sort & Filter A to Z

I am reasonably sure you would get the same problem in Excel 97 too.

There are merged cells somewhere in your sort range...

For example if you sort Col A and B upto row 100... if in any row Col A & B
are merged then you will get the error message you are getting...
You can test it by merging Cell A3 and B3 and then try to sort A1:B10 or
something like that.

You need to find the merged cell, unmerge it and you will be able to sort.

"Tia" wrote:

I'm brand new at 07 and I'm having trouble sorting rows from A-Z. It's
giving me the error "This operation requires the merged cells to be
identically sized". As far as I can see they are. I've never had this
problem before, but then again all I have been using up until this point is
Excel 97. I'm very confused with this new version.

Thanks,
Tia