How do I stop column headers from being sorted in a row?
Is the row below your heading blank? If not, it will be sorted with the rest
of your data. If there is a blank row, the method you use should work the
way you want.
"Sally the newbie" wrote:
I have always sorted a column in Excel by clicking on one cell in the column
to highlight it and then clicking on the A-Z or Z-A icons. Now the column
headings are sorted along with the other data in the column. The headings
are in a different font and the panes in the row are frozen. Why are they
being sorted? Do I need to change something else?
|