Sort range changes during sort

C

coffedrinker2003

After highlighting the columns and rows I want sorted, I select data and
sort. At this point the sort range changes to include the entire row from A
to IV of each row I selected. I've searched the options screen and help menu,
but don't know why this is happening.

Thanks in Advance.
 
D

Dave Peterson

This is a complete guess--I couldn't duplicate what happened to you in xl2003.

Do you have merged cells in that range?

If yes, maybe that's the problem.
 
Top