Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following:

  1. Formatted headers
  2. No gaps of empty rows/columns
  3. Have the same type of information under each heading e.g. if you have a date heading, only have dates in that column.

This video shows you how to do it and as always there is a file underneath that you can use to practise on..

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/09_Sorting_in_Excel.m4v’]






Click on this link to download an Excel file you can practise on: sorting_in_excel