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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Parvaiz" wrote:

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 whole range of data then sort by surnames and surnames only, that
will move the rest of the data accordingly

Regards,

Peo Sjoblom


"Parvaiz" wrote in message
...
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.

That worked just great.

Brilliant !!!

Thanx Dave


"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Parvaiz" wrote:

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.