• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Excel 97 question. Help me out!

T

TheDingo

Senior member
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?
 
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.
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top