Sort Data – Custom list in Excel

Sort Data as per your own Custom list in Excel in Hindi
You can use a custom list to sort in a user-defined order. Excel provides built-in, day-of-the-week and month-of-the year custom lists, and you can also create your own custom list.

Optionally, create the custom list.

In a range of cells, enter the values that you want to sort by, in the order that you want them, from top to bottom.


  1. You can only create a custom list based on a value (text, number, and date or time). You cannot create a custom list based on a format (cell color, font color, and icon).
  2. The maximum length for a custom list is 255 characters, and the first character must not begin with a number.