Manager Employee Amount Year
John Mark 1 99
John Paul 1 91
John Paul 1 93
John Paul 1 99
John Paul 2 99
Sue Jane 1 90
Sue Jane 1 95
Sue Jane 1 99
Sue Jane 2 98
Sue Mary 2 93
  1. Click on (the head of) the column you want to use as the primary sorter.
  2. If necessary click again until you get the correct sorting order (ascending or descending) in your primary column.
  3. Hold Shift key down and select the secondary column.
  4. While still holding Shift key down: click again on this secondary column until you get the correct sorting order.
  5. And do the same for the tertiary column.