# How to custom sort in ms excel

> To custom sort in Microsoft Excel, select File and Options, go to Advanced to edit a custom list, create a new list by importing selected cells, and then apply the new list through the Data Sort menu and save with OK.

Canonical: https://livedemo.ai/tutorials/how-to-custom-sort-in-ms-excel/
Apps: Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3aa4ab56e05a00fe1c15/preview?step=1

## Steps

1. Select "File."
2. Click "Options."
3. Select "Advance" then scroll and click "Edit Custom List."
4. Click "NEW LIST" and select the arrow up button beside "Import."
5. Select the cells you want to sort and click the arrow down.
6. Tab on the button "Import."
7. Select "Data."
8. Click "Sort," choose the List you created, and press "OK."
9. Select "OK" to finish.