MS Excel 97 question. Help me out!

[TheDingo]

Ok, I've got an odd problem in Excel 97. I have a spreadsheet with 4 columns and I would like to sort the whole sheet by one of the columns. Unfortunatly it only sorts the selected column, not the related data. How do I fix it so every column will sort in relation to my one column?

 

[BreakApart]

Select the ENTIRE sheet first using the upper/left empty grid-(above the 1, to the left of the A, click the EMPTY gray box) then run your data-->sort-->column

The entire sheet must be selected in order to sort while keeping the correct data aligned in the rows.

 

[TheDingo]

Awesome, works great. Thanx

 

[Broncho]

It should be even easier than that. The key is to not select anything. Click one cell in the column you want to sort by and do the sort. It should keep the rows locked in with the other column. At least that is the way I do it in Excel 97 on two different machines and it works every time.