Home » Blogs » Nick's blog

Teach Yourself Excel Lesson 20 - Sort Data

Nick's picture
Submitted by Nick on 1 June, 2009 - 15:32


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.

Steps:

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

sort-data

 

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:

AttachmentSize
sort-data.xls20.5 KB
»