Have you attempted selecting the entire spreadsheet prior to sort? A split
only shows the view differently. It would have no impact on sorting.

"NM" wrote:

Even if I manually slect the entire data, when I sort it reduces the
expansion,selects only the coulmns I mentioned below!!

"xlmate" wrote:

Excel is not smart enough, its use the current region.
You need to manually select the table and then do the sorting

cheers

"NM" wrote:

Hi,

My file has columns till DR. I have a spilt in the sheet at AP13.I am using
'Sort ascending' from the auto filter at CQ to sort the my file but my sort
selection is not expanding to entire columns. Column A-AP are not getting
sorted ascending, and now i have data all jumbled up!

Thanks for your help.