Share via

Excel turn a sort into an index

Jerry Kramer 25 Reputation points
2026-04-14T13:11:04.2333333+00:00

When I create a complex sort with a hierarchy of sorts, I don't know how to keep it. If I happen to sort the rows with any other criteria, the complex sort vanishes.

User's image

Can this sort be saved or do I have to recreate it everytime I want it?

Microsoft 365 and Office | Excel | For business | Windows
0 comments

Answer accepted by question author

  1. Sirri Berat Cinkilic 75 Reputation points
    2026-04-14T13:42:03.3033333+00:00

    Hi there,

    You're right—Excel does not retain multi-level sorts. Once you sort by another column, the previous sort order is removed.

    To avoid recreating it each time, you can use a helper column to combine your sort logic, which is the most reliable approach. You can also create a custom list for fixed category orders or record a macro if you frequently repeat the same sort.

    This way, you can quickly restore your intended sorting without rebuilding it each time.

    Was this answer helpful?

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jerry Kramer 25 Reputation points
    2026-04-14T13:58:11.03+00:00

    Ctrl+Alt L did not return my original complex sort as Copilot suggested. When I was testing it, I found that I could create a new Sheet View that I called "sorted." After resorting another column, I could return to the "sorted" sheet view, which rearranged the rows to the complex sort I had originally created.

    The Sheet View is accessible from the column header drop-down menu. It seems that it is necessary to switch back to the "sorted" sheet view right after applying another sort and before saving.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Deleted

    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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.