Sorting

[Guest]

Hi,

I have an Excel table consisting of 2 sheets. Both sheets have names, dates, text etc.
When I sort the first sheet on name (for instance) the whole table is sorted (Correct: the person still has his data attached)
On the second sheet however, only the chosen column is sorted, creating mayhem in the table (person D now lives in person G's town!). How can I configure the sheet so that the whole line follows the sorted items.

Thanks Jean-Marc

 

[Paul]

Hi,

I have an Excel table consisting of 2 sheets. Both sheets have names, dates, text etc.
When I sort the first sheet on name (for instance) the whole table is

sorted (Correct: the person still has his data attached)

On the second sheet however, only the chosen column is sorted, creating

mayhem in the table (person D now lives in person G's town!). How can I
configure the sheet so that the whole line follows the sorted items.

Thanks Jean-Marc

When sorting, it's best to explicitly select the area you want sorted. So,
if you have data in (say) columns A to E, select these columns and then
sort. If you don't select the area before sorting, you rely on Excel getting
it right, which in itself depends on the data structure (where are there
blank cells, etc.). It may be something like this that's causing the
apparent difference in behaviour between the two sheets.