Advanced sorting MS Excel

Advanced Sorting in MS excel sorts data in ascending/ descending order while maintaining data consistency.

This Guide applies MS Excel 2007 onwards


  1. Here we are using region wise sales data. Create a list in desired sort order in a column. We are using sequence Region B, Region C, Region D, Region A
  2. Click on Microsoft office button -> Excel options -> Popular category. Top options for working with excel will have an option of Edit Custom list. Adv_sort1

    From Custom list select Import list from range and select the range, click on import. List gets saved in Custom list.

  3. Select data range. Under data tab click on sort. Under sort by select region, In Sort on select value and under order select the list created from drop down. 
    Click OK data is sorted in desired sequence.Click here to Download Sample worksheet