I have no idea why this is such an issue, but I can't seem to sort 2010's table by the headers (horizontally - left to right).
I can sort a simple matrix of cells that looks like a table, but as soon as I use Excel 2010's built in table feature to sort by the headers, the header option is grayed out as well as going into options and sorting left to right.
Does anyone have an inkling of an answer? I'd prefer not to remove the table feature as I'm using it for named ranges (which would change all of the names).
Here's my actual Excel 2010 Table: Excel2010Table.jpg.
Here's my Excel 2010 matrix (simply a copy and paste of my Excel Table): Excel2010Matrix.jpg.
And if you don't know what I mean by the difference between the table and matrix, please ask.
Thanks!
Bookmarks