I select the single cell that I want to sort hit CNTL-A, and then ascend
nothing happens or the same problem happens everthing is all over the place.
I wish I could e-mail my program so someone could help me with the file in
front of them.

"Gord Dibben" wrote:

> Rob
>
> Don't let Excel guess your data range.
>
> Select all columns and rows in your range then sort on one column.
>
>
> Gord Dibben Excel MVP
>
> On Mon, 21 Nov 2005 12:23:18 -0800, "Rob rock" <Rob
> [email protected]> wrote:
>
> > I am randomly entering data in previously created Transmittal log, as I get
> >it, and after I am done I want the area that say\'s weld number to all be in
> >numerical order by number not by date. I hit sort ascending and it puts that
> >row in order but all of the other rows end up all over the place. I need to
> >be able to hit ascend and have everything move into the write order. The
> >dates don’t have to be in order only the weld numbers from low to high.
> >Hopefully you understand my dilemma and can help. If I could upload the excel
> >format to you that I am using, it probably would be more clear as to what I
> >am doing.Please e-mail me back. Thanks
>
>