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

Procedure
  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

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

    Adv_sort3
  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. 
    Adv_sort4
    Click OK data is sorted in desired sequence.Click here to Download Sample worksheet