How do i "Sort" my Excel 2007 worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top