Course contents · Sort, filter and tables

Sorting

Open the practice in the trainer →

Sorting moves whole rows: the order, the manager and the amount stay together. Click any cell of the column you need and choose Sort A to Z or Sort Z to A (Data or Home → Sort & Filter). Excel finds the table edges itself and recognises the first row as headers.

In the trainer there is a toolbar above the sheet: Sort A→Z, Z→A, Filter, Format as Table. The column of the active cell is sorted.

Tasks in the trainer

  1. Sort the orders by amount, largest first.
  2. Now by manager, A to Z.
  3. Two-level sort: region A to Z, and within a region amount largest first.

Solve the tasks in the trainer →

Check yourself

  1. You selected only the Amount column and sorted with "Continue with the current selection". What happened?
  2. Where do blank cells go when sorting?