How do i "Sort" my Excel 2007 worksheet

[Guest]

Hi everyone,
I'm very (very !!!) new to Excel, and have Excell2007 on my pc.
I know that i can "Sort" a column either ascending/descending, but if have a
row of data going across the worksheet thats all related eg:
Surname Firstname D.O.B Address Telephone etc etc

and i want to "sort" by say the Surname column, but keep all the other data
going accross, with it connected - How do I do it?

Hope you can understand my question better than i've been able to explain it.

Can someone please help.

 

[Guest]

Select the entire table, then go to the data tab and click on the sort dialog
button.

Note that this button says Sort... as opposed to the Z-A or A-Z icon. This
button brings up a dialog box, in which you can specify which column to sort
on. Choose Surname from the drop-down and specify whether you want to sort
ascending or descending.

Also if you're at all unsure about the process, I'd save a copy of your file
before you do this, as you don't want to inadvertently screw up your table by
sorting only one column.

Dave

 

[Peo Sjoblom]

Select the whole range of data then sort by surnames and surnames only, that
will move the rest of the data accordingly

Regards,

Peo Sjoblom

 

[Guest]

That worked just great.

Brilliant !!!

Thanx Dave