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.