It is amazing, but why such a simple question take ages to resolve?
Why Microsoft didn’t put a huge warning label that SORT ORDER in EXCEL 2007 is now behaves completely different from previous versions.
For years now, I was under impression that is it just a bug, and nothing can be done about it. Finally, some super-small font on some supper-obscure web site whispers that you only can save sort on a table, but on on a range.
What the h*** is a table. A table is LIST in previous Excel versions. Never heard of it. But we do not need to know about this. Let’s just go thorgh the steps:
-01- Select a range of cells just a bunch of columns and convert it to table (Ctrl+T);