Select the correct navigational path to sort data using multiple levels.


Click the (Home, Page Layout, Data, or view) tab on the ribbon, and look in the (Get & Transform Data, Queries & Connections, Sort & filter, or Data tools)

gallery. Select the rows or columns you wish to sort. Select (Sort, Filter, Advanced, or Outline.)


Add a level, and another, with the parameters needed, and click OK.