Sorting data in one sheet

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.

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" wrote:

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.

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" wrote:

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" wrote:

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.

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...

"Gwen" wrote:

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" wrote:

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" wrote:

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.

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

On Wed, 20 May 2009 08:18:01 -0700, Gwen
wrote:

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" wrote:

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" wrote:

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.