Teach Yourself Excel Lesson 20 - Sort Data

Nick's picture

Sort Data

Download starting Sheet

So you've entered a load of expenses, and now realise that you have entered them in the wrong order. It would be nice to sort them.


  1. Select A1
  2. Press in sequence: Alt then D then S
  3. Choose Date to sort by
  4. Press OK



Your sorted sheet should now look like this

Next Lesson: Teach Yourself Excel Lesson 21 - Filter Data

Training Video on how to sort data in Excel:

sort-data.xls20.5 KB