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)
Hi,
I am trying to sort a sheet's column names, which should be possible with Sort & Filter>Options>Sort Left to right. However, the option is greyed out, and only sort top to bottom is available. The sheet does have headers setup to allow visibility and data entry in bottom rows. When I remove this header setting, all column titles are removed, and the option to sort left to right is still grey.
I am using Microsoft Office 365 ProPlus, version 1706 Excel (Current), and am signed into 365
Please Help!
***Post moved by moderator to appropriate forum category***
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
Hi Lucas,
Have you tried Mark's suggestion? Does the option available now? To convert the table to a range, please select any cell in the table, and then clicking Table Tools > Convert to range.
Let us know it helps.
Regards,
William
Just one idea.
Is your data in an Excel Table. If so, it is not possible to sort left to right in a Table. You would need to convert it back to a normal range, sort it left to right, then convert it back to a Table.