I have had the same problem also. Know exactly what you are talking about.
For some reason, Excel is not automatically recognizing the headings. I have
not found a solution, but have found two ways to work around it.
1. When creating the worksheet, I try to paste from one that works
correctly. OR
2. In my case, I have two heading rows, so I highlight the entire range I
wish to sort including the header row I want to sort by. Then I go to sort.
At the bottom I check "header row". It then recognizes the first row in my
selection as the sorting criteria.


"moonfang" wrote:

i have a worksheet that i need to sort A-Z. I have sorted it in the past but
now it will not sort. There are labels at the top of the worksheet but when
i click Data--sort, the window that comes up shows "column A" instead of
"Name". Also the labels end up down in the worksheet as they are being
sorted also. there are no empty rows or columns.