In Excel 2007 I am having trouble sorting out the 123 and ABC because I have

donthitmeah

New member
merged the top two rows. Help? I am trying to sort column A but my merged heading in
A1 ---------------------------D1
A2---------------------------D2
Is giving me this error .

The cell range that you attempted to sort or remove duplicates from includes merged cells. However not all cells in the range are merged to the same size.
To complete this operation, unmerge all the merged cells in the range, or make each group of merged cells the same size as the largest group.

I have to merge the heading because it is the title and it has to be in BIG font.
Anyway around this?

Thanks!

I will add details if you don't know what I mean.
 
Back
Top