This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Excel 2007
Occasional I am working with a sheet of data that headers at the top and the ribbon sort works fine - the header stays put. But on occasion the sheet starts including the header row and it gets shuffled around where it doesn't belong.
Freeze top row doesn't keep it in place.
I tried to change the formatting on just the top row - no joy.
Naming the cells below the header row doesn't work.
How do I get back to the default that exlcudes the top row from the sort?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Found the answer - Data tab, Sort dialog - in upper right is a checkbox My Data Has Headers.
I have the same issue with multiple header rows. I have some columns grouped together, and I merge the cells immediately above those columns to label the group.
What's odd, however, is that the first time I try to sort, it recognizes the second row as my header row, and it's perfect. But the next time I try to sort, it sees the first line as the header row, and sorts the second line in with the rest.
Excel 2010.