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:
- Formatted headers
- No gaps of empty rows/columns
- 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