Bill Martin -- (Remove NOSPAM from address)
Guest
Re: Why won't data sort correctly in Excel
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.
------------------
It sounds like you did sort the headers as part of the data. You can
manually cut/paste them back to the top.
When you first open the sort control window, at the bottom are two
buttons. "My list has header row", or "has no header row". You've
apparently got the wrong one selected.
Good luck....
Bill
Bookmarks