link row cells

[Gary]

Is it possible to lock the information in a row together
and have it stay together when sorting one column?

Data goes from A2:X2, I want to beable to sort column
B2:B52 and have that row 2 information and all rows
follow the sort no matter where it ends up in the sort.
Row 2 follows B2, Row 3 follows B3 no matter where it
might end up in the sort.

Gary

 

[Frank Kabel]

Hi
just select the entire data range (all columns) and use 'Data - Sort'

 

[David Biddulph]

Is it possible to lock the information in a row together
and have it stay together when sorting one column?

Data goes from A2:X2, I want to beable to sort column
B2:B52 and have that row 2 information and all rows
follow the sort no matter where it ends up in the sort.
Row 2 follows B2, Row 3 follows B3 no matter where it
might end up in the sort.

Select A2:X52
Data menu/ Sort
Sort By: Column B