Ravindra BagaleCourses & study guides

6. Tables, Sorting and Filtering

6.4 Sorting: Multi-level and Custom Sort

By Last updated:

Steps in Excel

  1. Quick sort: click a cell in a column › Data › Sort & Filter › A→Z or Z→A (whole Table/range is sorted together).
  2. Multi-level: Data › Sort & Filter › Sort › Sort by City (A to Z) › Add Level › Then by Amount (Largest to Smallest) › Add Level › Then by Order Date (Oldest to Newest) › OK.
  3. Custom order: in the Sort dialog, Order › Custom List… › type Pune, Nashik, Nagpur, Sambhaji Nagar, Kolhapur, Solapur › Add › OK.
  4. Sort by colour or icon: Sort On › Cell Color / Font Color / Conditional Formatting Icon.
  5. Sort left to right: Sort dialog › Options… › Sort left to right.
  6. Formula alternative (Microsoft 365 / Excel 2021+): =SORT() / =SORTBY() – Module 9.

Worked example. Ravina's management report must list cities in business priority order (custom list above), within each city the highest orders first. Two levels – City (custom list), Amount (Largest to Smallest).

Ravindra Bagale's Tip

Sagalyat dhokadayak chuk: fakt ekach column select karun sort karne – Excel "Expand the selection?" vicharto aani khup students "Continue with the current selection" dabtat. Mag amount ek kade aani order dusrikade – data kharab! Nehmi ekach cell var click karun sort kara kiwa Table vapra.

Practice task

Sort tblOrders by Platform, then City in your custom order, then Delivery Mins (fastest first). Sort the Status column in the custom order Delivered, Returned, Cancelled.