I have worksheets where the first two rows are the header rows. For most worksheets I just click one of the header rows and click the Sort Ascending button. But for some worksheets sorting does not work where the sorted data is shifted to very top and the header rows are at the bottom. I tried also using the Data – Sort function on the menu bar and selected “Header row” and first heading row is missing. How can solve this problem?