I make a lot of tables of data, typically including a differently-formatted Header Row. There's usually some other stuff above the Header Row, sometimes separated from it by a blank row, sometimes not.
Normally I can sort the data by selecting a cell within the table and using the Sort dialog box or the easy A-Z or Z-A icons I've added to my toolbar. Sometimes I have to tell Excel that there's a Header Row, but often it seems to figure that out on its own. The sorting is typically perfect, quick, and easy.
But sometimes Excel gets confused about where my data is. No matter what I do, it wants to sort the whole worksheet, not just the data below the Header Row. This often (always?) happens when there's a group of merged cells somewhere above the Header Row. I get a message about merged cells, and the data won't sort. No matter what I do, I can't get Excel to return to just sorting my data instead of everything on the worksheet. I can unmerge the cells, insert a blank row above the Header Row, close the worksheet and reopen it, etc. Nothing seems to restore the "normal" sorting process.
Who's got a fix?