Sorting a worksheet disrupts the columns in a row.

[Ted Brewer]

Hi all,

I have a WS that when sorted on a column, the other columns of that row will not stay together.

Example:

File Name Owner Size

xyz.co A 2kb
abc.co C 5kb
fgh.co Z 10kb

If I sort on the File Name column, the Size cell for the row does not get sorted. ie:

abc.co C 2kb
fgh.co Z 5kb
xyz.co A 10kb

Can anyone tell me how to prevent this?

Ted

[Ogilvy, Thomas, W., Mr., ODCSLOG]

Select the whole range you want sorted. In this case, select the
filename, owner and size columns over all filled rows and then run the
sort.

This should work.

Regards,
Tom Ogilvy

[Peter Beach]

Ted,

Try selecting the whole range and then sort on the third column. Thus if
file name, owner and size are in column A, B, C select all 3 columns and
then do the sort (specifying that you want to sort by Col C). This should
keep all the data together.

HTH

Peter

Ted Brewer wrote in message
<#33#a7OD#GA....@uppssnewspub05.moswest.msn.net>...

[Ted Brewer]

Thanks for your replies.

It's easy, when you know how.<g>

T

Ted Brewer <the...@ticon.net> wrote in message #33#a7OD#GA....@uppssnewspub05.moswest.msn.net...