Sorting data in one sheet

[Gwen]

I created a sheet with many columns and rows. I want to be able to sort the
data in different columns but keep all of the row information together. For
instance when I sort one of my rows alphabetically, the rest of the
information in the other columns that pertains to it doesn't follow.

 

[Sean Timmons]

when you do your sort, are you highlighting the entire table of data?

everything within your highlighted data should sort along with yoru selected
field.

 

[Gwen]

I think part of the problem might be that I have the information in the first
column frozen so that when you're scrolling to the right you can still see
the info in the first column.
Do I have to highlight the whole table every time I want to sort?

 

[Sean Timmons]

It's typically only an issue when you have blank columns in the middle of
your table. If you put anything in the header row for all columns, it should
automatically highlight the entire table.

The frozen pane should not cause an issue with sorting...

 

[Gord Dibben]

Do not let Excel guess at the range to be sorted.

Always pre-select the entire range you want to stay together.


Gord Dibben MS Excel MVP