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)
I have a table with multiple columns. When I select a cell in any one column and select the shortcut toolbar option to sort ascending, it includes the header row in the sort and moves it to the bottom. I can go to the 'data' menu and select sort and then check the 'header row' option and it will sort correctly but then if I try the sort button in the toolbar again, not the 'data' menu, then it loses the header row again.
This is something new. For months I have been able to select a cell in a column, hit the sort ascending button, and whammo, the sort was done leaving the header row intact. Now, the toolbar button sort somehow does not realize there is a header row.
How do I get the sort to recognize the header without using the 'data' menu, sort option?
The data contains both text and numbers.
I am using Excel 2003.
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
The header row needs to be "different" from the data rows or Excel can't tell. It could be as simple as making the header row BOLD, then the buttons may work just fine!
Bob Umlas
Excel MVP
My apologies. I figured out last night that there was one column without a title. Apparently Excel does not like untitled columns. Once I entered a title everything was fine!
Thanks for the reply and sorry for the inconvenience of posting an issue that was my own fault...
Hi,
When sorting, it is a good practice to select the explicit data range (with the first row as the header row) and then go to Data > Sort. May a times, due to the existence of blank rows, the data range selected by MS Excel for sorting is not correct.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
I have a table with multiple columns. When I select a cell in any one column and select the shortcut toolbar option to sort ascending, it includes the header row in the sort and moves it to the bottom. I can go to the 'data' menu and select sort and then check the 'header row' option and it will sort correctly but then if I try the sort button in the toolbar again, not the 'data' menu, then it loses the header row again.
This is something new. For months I have been able to select a cell in a column, hit the sort ascending button, and whammo, the sort was done leaving the header row intact. Now, the toolbar button sort somehow does not realize there is a header row.
How do I get the sort to recognize the header without using the 'data' menu, sort option?
The data contains both text and numbers.
I am using Excel 2003.
I have this problem but my header text is a different colour, with a different background, bolded and in a different font size. Still Excel no longer recognizes my header automatically when I sort. What am I doing wrong? I can't find the answer anywhere.
I am also using Excel 2003.