Sort command does not sort some columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
basic.
 
BillBob:

If you want to sort a multi-column range of cells:

Select the entire range of cells
<data><sort>
Set your sort parameters
Click the [OK] button.

If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Thank you for your help Ron. When I go to Data - Sort - I do not seem to
have an option through which I can set the perameters. I am left with a
dialogue box which reads "lists sort by" and "then by" and "then by". When I
go into the pull down menus all I am given an option of is which columns to
sort. A "blue box" is evident on the data - but I don't know how to expand
this box to include the new data. When I try to expand the box it simplly
drops the old infomation on top of the new and overwrites it. So, the
question is how do I set source perameters - where do I need to look?

Thanks
BillyBob

Ron Coderre said:
BillBob:

If you want to sort a multi-column range of cells:

Select the entire range of cells
<data><sort>
Set your sort parameters
Click the [OK] button.

If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


BillyBob said:
When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
basic.
Click to expand...
Click to expand...
 
It seems like you're not performing the first step:
Select ALL of the data in the range, not just the column you want sorted.

Example
If you have data in the range A1:D100 and you want to sort that range by
Col_B in ascending order:

Select A1:D100
<data><sort>
Sort by: Column B
Check: Ascending
Click the [OK] button

That would sort A1:D100 by Col_B, keeping the corresponding records
associated with each Col_B item together with the item.

Does that help? or am I missing something?
***********
Regards,
Ron

XL2002, WinXP


BillyBob said:
Thank you for your help Ron. When I go to Data - Sort - I do not seem to
have an option through which I can set the perameters. I am left with a
dialogue box which reads "lists sort by" and "then by" and "then by". When I
go into the pull down menus all I am given an option of is which columns to
sort. A "blue box" is evident on the data - but I don't know how to expand
this box to include the new data. When I try to expand the box it simplly
drops the old infomation on top of the new and overwrites it. So, the
question is how do I set source perameters - where do I need to look?

Thanks
BillyBob

Ron Coderre said:
BillBob:

If you want to sort a multi-column range of cells:

Select the entire range of cells
<data><sort>
Set your sort parameters
Click the [OK] button.

If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


BillyBob said:
When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
basic.
Click to expand...
Click to expand...
Click to expand...
 
Ron said:
It seems like you're not performing the first step:
Select ALL of the data in the range, not just the column you want sorted.

Example
If you have data in the range A1:D100 and you want to sort that range by
Col_B in ascending order:

Select A1:D100
<data><sort>
Sort by: Column B
Check: Ascending
Click the [OK] button

That would sort A1:D100 by Col_B, keeping the corresponding records
associated with each Col_B item together with the item.

Does that help? or am I missing something?
***********
Regards,
Ron

XL2002, WinXP


BillyBob said:
Thank you for your help Ron. When I go to Data - Sort - I do not seem to
have an option through which I can set the perameters. I am left with a
dialogue box which reads "lists sort by" and "then by" and "then by". When I
go into the pull down menus all I am given an option of is which columns to
sort. A "blue box" is evident on the data - but I don't know how to expand
this box to include the new data. When I try to expand the box it simplly
drops the old infomation on top of the new and overwrites it. So, the
question is how do I set source perameters - where do I need to look?

Thanks
BillyBob

Ron Coderre said:
BillBob:

If you want to sort a multi-column range of cells:

Select the entire range of cells
<data><sort>
Set your sort parameters
Click the [OK] button.

If all of the relevant columns are not pre-selected, they will not sort with
the column you want sorted and you'll have out-of-sync mess.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


:

When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
I am a newbie to this program so I am sure I am doing not doing something
basic.
Click to expand...
Click to expand...
Click to expand...

If you want to sort the entire sheet an easy way to select all cells is
to click the square in the upper left hand corner above the row number 1
and to the left of the column A.

gls858
 
Check the following:

Is there any empty columns without Header labels
Are you selecting any data first - Just be in the column you want to sort by
Any named ranges taking in the old data area

Zoddy
 
Back
Top