Why does the sort area change?

[paulo57509]

I have a simple spreadsheet without formulas. Just names, dates, etc. My sheet has a header row.

When I perform the very first sort of my worksheet, Excel highlights all the columns and rows under the header rows automatically. I will then click on OK and the sort proceeds normally. However, if I later run the same sort again, Excel automatically adds one of the header rows to the sort selection and continues to do this from that point on with every subsequent sort. If I close and re-open the file the scenario repeats itself; kind of like a reset.

It does this whether or not I've modified the worksheet or not. I can open the file, perform a sort and immediately run the same sort and the above occurs.

Is this just a quirk of Excel 2010 or.....? It's not a big deal but it is annoying to have to re-define or manually choose the sort area every time.

Sort procedure I use:

1. Choose any cell in worksheet.
2. Menu --> DATA --> Sort (button) --> Sort box appears --> click OK

I've attached a screen shot if this helps.

Thanks.