Firstly, you need to highlight all the information that you want to sort.  Make sure you highlight ALL of the columns like in the example above.
It doesn't matter if you highlight the headers (i.e. NAME, ADDRESS, etc). In this example I have them highlighted, as you can see.

OK, this is really easy Jen. I made an example spreadsheet (above) to show you how to sort information in Excel.

Once you have everything highlighted, click on 'Data' and select 'Sort' from the menu

A window will then appear where you can choose how you want to sort the information. I've chosen to sort the information by AREA.

You can also choose a second column to sort by. In my example I've chosen the AMOUNT column.

If you have headers on your spreadsheet (i.e NAME, ADDRESS, AREA, etc) then make sure the 'Header Row' option is selected.

If you don't then select 'No Header Row'.

Then click OK.

As you can see, all the information has now been sorted by AREA as I selected, but notice that it has also put the AMOUNT column in numeric order for each AREA. That's because I also chose to sort by AMOUNT in the sort menu (Figure 4.)

Figure 1.

Figure 6.

Figure 5.

Figure 4.

Figure 3.

Figure 2.

I hope all that was easy enought to follow. It seems it to me, but that because I wrote it, haha. If you're unsure about anything then I can go over it when I see you :)