Share via

Data sorting in Excel.

Anonymous
2024-11-13T21:25:22+00:00

How can I keep the same sort criteria after copying the table and adding new data to it. I want to sort 4 levels of criteria in a table, then copy the table and add data to it then sort again using the same 4 level criteria?

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-11-14T04:59:59+00:00

    A table stores the sort settings and you can simply Re-Apply the sort. https://support.microsoft.com/en-us/office/reapply-a-filter-and-sort-or-clear-a-filter-a46f7534-ce5c-4e20-ac9b-e35eec1c48c0

    Example:

    Table in A:B copied as is to D:E applied a sort order, copied to G:H, added "4 c", then reapplied the sort.

    Andreas.

    Was this answer helpful?

    0 comments