THERE IS a WAY to SAVE A SORT in EXCEL 2007
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);
-02- Remove annoying unneeded table formatting (Design –> Table Style –> Clear);
-03- Remove filters (Data – Filter);
-04- Apply a sort.
Next time you are in the file, your sort is finally preserved.
I am pro-Microsoft. I am using only Microsoft products. But they found a sure way to infuriate their customers.
Finally, THERE IS a WAY to SAVE A SORT in EXCEL 2007