Need Help? Chat with us

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.

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

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.






Notes:

  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.

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook